Re: Restore DB from Physical Standby Backup
- From: Ajay Thotangare <at.oracledba@xxxxxxxxx>
- To: sethmiller.sm@xxxxxxxxx
- Date: Thu, 20 Nov 2014 12:04:29 -0600
Please try
RMAN> recover database noredo;
RMAN> alter database open resetlogs;
regards,
Ajay
On Thu, Nov 20, 2014 at 11:48 AM, Seth Miller <sethmiller.sm@xxxxxxxxx>
wrote:
> 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:
