REFRESH STANDBY USING INCREMENTAL(SCN BASED) BACKUP
This method is used to resolve problems if a physical standby database has lost or corrupted archived redo data or has an unresolvable archive gap.
STEP1—STOP THE MRP PROCESS
STEP2—ON THE STANDBY DATABASE,
FIND THE SCN WHICH WILL BE USED FOR THE INCREMENTAL BACKUP AT THE PRIMARY DATABASE.
STEP3—IN RMAN , CONNECT TO THE PRIMARY DATABASE AND CREATE AN INCREMENTAL BACKUP FROM THE(lowest) SCN DERIVED IN THE PREVIOUS STEP
backup incremental from scn 1502443 database format ‘/u01/mybackups/backupset/dgproprim%u.bkp’ tag ‘forstandby’
STEP4—TRANSFER ALL BACKUP SETS CREATED ON THE PRIMARY SYSTEM TO THE STANDBY SYSTEM
STEP5—ON THE STANDBY ,CATALOG THE BACKUPPIECES
STEP6—ON PRIMARY DB, CREATE STANDBY CONTROL FILE
STEP7— COPY THE BACKUP AND CONTROLFILE TO STANDBY SERVER
STEP8—-ON STANDBY, REPLACE THE EXISTING CONTROLFILE WITH NEW CONTROLFILE
Now shutdown standby db,
STEP9— MOUNT STANDBY DATABASE
STEP10— RECOVER STANDBY
Now START THE MRP PROCESS
Recommended Posts