My Oracle Support Banner

How to Roll Forward a Standby Database Using Recover Database From Service (Doc ID 2850185.1)

Last updated on NOVEMBER 21, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Goal

Note, this procedure is version dependent. The procedure described in this note is for Oracle 12.1 and 12.2.

For 11g see the following procedure:

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

For 18c and higher, see the following procedure:

Roll Forward Physical Standby Using RMAN Incremental Backup in Single Command (Doc ID 2431311.1)

Utilize RECOVER DATABASE FROM SERVICE to skip over a large gap in redo or a gap in redo which is unresolvable(missing logs).

Solution

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
Goal
Solution
 Stop Managed Recovery and Redo Transport
 Save Existing Logfile Names
 Refresh Standby Control File From Primary 
 Document the Current SCN for the Standby
 Save Current RMAN Configuration Settings
 Refresh the Standby Control File
 Replace RMAN Configuration Settings and Remove Orphaned Online and Standby Redo Log Files
 Catalog Standby Database Files to the Refreshed Control File
 Restore Any Missing Files
 Switch Database to Copy
 Clean Up Orphaned Files
 Clear Online Redo Logs and Standby Redo Logs
 Roll the Standby Database Forward
 Restart All Instances to Mount
 Re-Enable Redo Transport
 Determine Section Size to be Used
 Run Recover From Service
 Recover Until Consistent 
 Re-Enable Flashback Database
 Restart the Standby and Managed Recovery
 Take a New Backup (If Needed)
References

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