My Oracle Support Banner

Steps to perform for Rolling Forward a Physical Standby Database using RMAN Incremental Backup. (Doc ID 836986.1)

Last updated on OCTOBER 30, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 12.1]
Information in this document applies to any platform.
Checked for relevance on 21-AUG-2015


The steps in this section can used to resolve problems of missing or corrupted archive log file, an unresolveable archive gap, or need to roll standby forward in time without applying a large number of archivelog files.  


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1) Stop the managed recovery process (MRP) on the STANDBY database
 2) Determine the SCN of the STANDBY database.
 3) Take an incremental backup of the PRIMARY database
 4) Transfer all backup sets to STANDBY server
 5) Catalog the backups in STANDBY controlfile.
 6) Recover the STANDBY database with the cataloged incremental backup:
 7) In RMAN, connect to the PRIMARY database and create a standby control file backup:
 8) Copy the standby control file backup to the STANDBY system. 
 9) Capture datafile information in STANDBY database.
 10) From RMAN, connect to STANDBY database and restore the standby control file:
 11) Shut down the STANDBY database and startup mount:
 12) Catalog datafiles in STANDBY if location/name of datafiles is different
 13) Configure the STANDBY database to use flashback (optional)
 14) On STANDBY database, clear all standby redo log groups:
 15) On the STANDBY database, start the MRP

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.