Restore DB from Physical Standby Backup

From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Thu, 20 Nov 2014 11:48:36 -0600
Message-ID: <CAEueRAVkf2nEV=-OEWyhVCbJgBNa9aVWWRnrTCtx0Mcze0yy1A_at_mail.gmail.com>

I've tried this on 12.1.0.2 on Linux 6 and 11.2.0.4 on Windows 2008R2 with the same result.

• Single node database with a single node physical standby.
• Incremental level 0 backup on the standby.
• Create another new instance on the same server as the standby.
• Restore the control file and the database from the backups that were taken from the standby.
• Set new names for the data files during restore.
• Switch all data files to the newly restored copies.
• Rename online log files.
• PITR on new database.
• Receive the error ORA-01194: file 1 needs more recovery to be consistent

No matter how far I try to recover, I continue to receive this error: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1:
'/u01/app/oracle/product/12.1.0/dbhome_1/dbs/data_D-ORCLA_TS-SYSTEM_FNO-1'

All data files that are not read only are at the same SCN and above the SCN of the read only files.

SYSTEM, SYSAUX and UNDOTBS1 are all in a "fuzzy" state, although I can't figure out why.

Seth Miller

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 20 2014 - 18:48:36 CET