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.