My Oracle Support Banner

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

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version to 21.6 [Release 12.1 to 21.0]
Information in this document applies to any platform.


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


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
 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)

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