My Oracle Support Banner

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

Last updated on APRIL 01, 2022

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

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.