Re: Restore DB from Physical Standby Backup

From: Ajay Thotangare <at.oracledba_at_gmail.com>
Date: Thu, 20 Nov 2014 12:04:29 -0600
Message-ID: <CAOEiWpzhr=UYxuD2eJTpasxq=9asant1HCS54tvzxQytBcZGJw_at_mail.gmail.com>

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_at_gmail.com> 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
>
>

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

Received on Thu Nov 20 2014 - 19:04:29 CET