Oracle Database migration to a remote Data Protector cell--Best practices

If you are not able to create a PFILE from the original RAC database (not available), you may want

to create a file system copy of the restored SPFILE (binary file) and remove with your ASCII editor

the binary characters (officially unsupported)

RMAN> startup mount force pfile='/opt/oracle/product/10.2.0/db_1/dbs/initRAC1.ora'

Oracle instance started

database mounted

Total System Global Area 4294967296 bytes

Fixed Size 2063792 bytes

Variable Size 754975312 bytes

Database Buffers 3523215360 bytes

Redo Buffers 14712832 bytes

RMAN>

At this point, we can follow as on the other scenarios with the restore and the recovery of the

database.

In case the datafiles location has changed, remember to include the following command on your

RMAN script:

set newname for datafile 1 to ‘new datafile path’;

Appendix G: Reference documentation

• HP Data Protector Software Documentation and White Papers

Oracle

• Oracle 10g Backup and Recovery Advanced User’s Guide