Restore DB from Physical Standby Backup
- From: Seth Miller <sethmiller.sm@xxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 20 Nov 2014 11:48:36 -0600
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
Other related posts:
