Database Backup and Recovery (MOSC)

MOSC Banner

Restore Dataguard database to Standalone database from backup location files

Database version: 12.1.0.2 with ASM and Dataguard
OS: Linux x64
source db: prod (dataguard)
target db: dev (standalone)

Restore testing on same server.  In this case the QA/DR standby server

To start off with I do want to state that the easiest way to do what I'm asking is via RMAN duplicate and have done many times. Unfortunately, due to the backups that were taken (monthlys and yearlys), the controlfile was not the last thing taken and so it causes problems with RMAN duplicate. I've had to resort to manual RMAN restore/recovery. On to my scenario and questions.

I know the steps involved for this process but the one step that I tend to be concerned with and that is the step where you rename the redo logs prior to issuing the "alter database open resetlogs".

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center