Managing Database Resources - OCP: Oracle Database 12c Administrator Certified Professional - page 485

To change the internal database identifier, use DBNEWID Utility
Finished conversion at source at 21-OCT-13
RMAN>
Verify the accuracy of the filenames and directories in the script files before
you run them and attempt to start up your new destination database.
Database Conversion on the Destination System
To create the converted copy of the source database on the destination system, run RMAN
on the destination system and execute the CONVERT DATABASE ON DESTINATION PLATFORM
command. The command produces the convert script necessary to convert the database
files on the destination system, the pfile, and a transport script.
rman connect target=/
RMAN> convert database on destination platform
2>convert script '/tmp/convert_orclnx.rman'
3>transport script '/tmp/transport_orclnx.sql'
4>new database 'orclnx'
5>format '/tmp/orclnx%U'
6>db_file_name_convert '/ora100/oradata/orclnx/datafile','/tmp/stage/';
Step 6: Move Files to the Destination System
If you converted the data files at the source, you should now copy them to the destina-
tion system. If you used your SAN, NAS, or NFS storage, now's the time for the destina-
tion system to take ownership of the database files. Copy the transport SQL script, pfile,
external table files, and BFILES to the destination.
If you chose to convert the files at the destination, you will now need to copy the convert
script to the destination and move the unconverted data files to the staging area. Again, SAN,
NAS, and/or NFS storage should be made read/write for the destination at this time.
Step 7: Complete the Migration
If you converted the data files at the destination, you'll need to run the RMAN convert script
on the destination system.
Whether you converted at the source or at the destination, review and modify the pfile
as required. Now review the transport script created by the RMAN CONVERT DATABASE com-
mand. Verify that the directory locations are correct for the pfile, data files, log files, and
tempfile. After you make corrections and verify, execute the transport script and check for
any error messages.