Synchronize Standby database [Oracle 10g Dataguard]－DanBrother的部落格

8 Steps for Synchronizing Standby database:

1. Find the current SCN of the standby database:
>>
select current_scn from v$database;

CURRENT_SCN
--------------------
4276099

2. Create the needed incremental backup from the above SCN
on the primary database.
>>
rman target / nocatalog
RMAN> backup device type disk incremental from SCN 4276099
database format '/home/oracle/tmp/bkup_%U';

3. Create a new standby controlfile on the primary database;
SQL> alter database create standby controlfile as '/home/oracle/tmp/control01.ctl';

4. Cancel managed recovery on the standby database.
SQL> recover managed standby database cancel;

5. Move the incremental backup from (Step 2) to the standby server and catalog it.
>>
rman target / nocatalog
RMAN> catalog start with '/home/oracle/tmp';

6. Recover the standby database from the incremental backup.
>>
RMAN> recover database noredo;

7. Shutdown the standby database and replace the controlfile with the one created in (Step 3)
>>
SQL> shutdown abort
# cd /home/oracle/oradata
# rm control*.ctl
# cp /home/oracle/tmp/control01.ctl ./control01.ctl
# cp /home/oracle/tmp/control01.ctl ./control02.ctl
# cp /home/oracle/tmp/control01.ctl ./control03.ctl

8. Startup the standby database and put it back into managed recovery mode;
>>
SQL> startup mount
SQL> recover managed standby database disconnect;