Rebuilding Standby database

2.3.1.              Steps to follow:

1. Connect to TRAXSP database in SYDDC1TRX01 Server using sqlplus tool and stop the automatic applying of archived log files.

SQL> alter database recover managed standby database cancel;

2. Find the current SCN (System Change Number) in TRAXSP

SQL> select current_scn from v$database;

3. Shut down the Standby database.

SQL> shut immediate

4. On the Production side, connect to TRAXMP as the target database through RMAN.

[oracle@meldc1trx01 ~]$ rman target sys@TRAXMP

5. Create an incremental backup of TRAXMP from the SCN found in TRAXSP.

RMAN> backup incremental from scn <current_scn> database tag 'FORSTANDBY' FORMAT ‘/backup/export/FOR_STANDBY_%U';

6. Then, backup the controlfile of TRAXMP for Standby in the RMAN prompt

RMAN> backup current controlfile for standby format '/backup/export/FORSTDBYCTRL.bkp';

7. Copy the incremental backup from MELDC1TRX01 Server to SYDCC1TRX01 Server to the location ‘/backup/’ through scp command as:

·         Connect to SYDDC1TRX01 server and fire the below command from OS prompt.

scp oracle@meldc1trx01:/backup/export/<incremental backup name> /backup/

OR

·         Connect to meldc1trx01 server and fire the below command from OS prompt.

scp /backup/export/<incremental backup name>  oracle@meldc1trx02:/backup/

Similarly copy the controlfile backup from MELDC1TRX01 Server to SYDCC1TRX01 Server to the location ‘/backup/’ through scp command.

8.       Now, open two putty terminals for SYDDC1TRX01 Server. In the first terminal, connect to TRAXSP database and start the database in nomount stage.

SQL> startup nomount

9.       In the second terminal, connect TRAXSP as target database through RMAN.

[oracle@syddc1trx01 ~]$ rman target sys@TRAXSP

10.    Restore the controlfile using its backup.

RMAN> RESTORE STANDBY CONTROLFILE FROM ‘/backup/FORSTDBYCTRL.BKP’;

               

11.    Now, in the first terminal, bring the database to the mount stage.

SQL>alter database mount standby database;

12.    In the second terminal, Catalog the Incremental Backups on the Standby Server

RMAN> catalog start with ‘/backup’;

13.    Recover the Database and Cleanup Redologs on the Standby Server

RMAN> recover database noredo;

14.    In the first terminal, start the automatic applying of archived log files on TRAXSP.

                SQL> alter database recover managed standby database disconnect from session;

15.    Then check for gaps.