Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

rman restore of backup from standby database

kbrown1333928078Mar 26 2014 — edited Mar 28 2014

I'm working on an exercise to prove recoverability of our production database and believe I'm just missing something.

I have a full backup from my standby database and backups of archivelogs from the primary database.  When I try to restore I am able to recover at any point in time and open the database read only .  When I try to open the database with resetlogs I get an ORA-01666 telling me the controlfile is from a standby database.  I've done the restore from both the standby controlfile autobackup and the primary database controlfile autoback and both with same result.  The database, via v$database, believes it's a standby and I can't figure out how to chage it.

My general process is to restore the control file from backup, mount the control file, catalog the backup folder, restore the database, then recover the db.  It's at this point where the process goes off rail.  Any assistance would be appreciated.

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 25 2014
Added on Mar 26 2014
5 comments
1,714 views