1) CREATE PFILE WITH DB_FILE_NAME_CONVERT=(OLD PATH,NEW PATH)
2) CREATE DIRECTORY STRUCTURES AS PER PFILE.
3) RMAN TARGET SYS/PASSWORD@TNSNAMES AUXILIARY /
ALLOCATE CHANNEL D1 DEVICE TYPE DISK FORMAT 'BACKUP LOCATION';
DUPLICATE TARGET DATABASE TO NEW DB NAME;
Published Articles » Oracle
6.2 Failover from the Primary to the Standby Database (Disaster Recovery)
Perform following tasks to do failover:
1. Identify and resolve any archivelog gaps. On the standby database server, execute the following statement:
SQL> select * from v$archive_gap;
no rows selected
If this query returns any rows, copy the archivelogs file to the primary site and check whether is is applied
« previous 1 next »
YourWiz.com, is a website that will allow everyone to share their knowledge, tip or information through community micro blogging.