Re: Restore DB from Physical Standby Backup
- From: Seth Miller <sethmiller.sm@xxxxxxxxx>
- To: pavan kumar <pavan_843@xxxxxxxxxxx>
- Date: Fri, 21 Nov 2014 14:18:06 -0600
Pavan, I am not trying to create a new standby database. I'm trying to
create a primary database from the backups produced from the standby.
Tony, I tried applying a dozen logs after the backup was completed and
still no luck.
Timur, the BACKUP DATABASE command does that automatically. It also
archives the log following the backup and includes that in the backupset.
Ajay, I seemed to have luck with using NOREDO on testing of my system but
when I tried to use it against the database I am trying to fix, it is not
making any difference. I don't get the error about file 1 needing more
recovery but when I go to open the database with resetlogs, I get the error.
Seth Miller
On Thu, Nov 20, 2014 at 9:31 PM, pavan kumar <pavan_843@xxxxxxxxxxx> wrote:
> Hi,
>
> Actually, end-user is trying to create/duplicate new standby from existing
> one. So, he needs to cancel the MRP which makes the files consistent.
> Else MRP would be up and running and SYSTEM datafile and rest of the
> data-files would be fuzzy.
>
> - Thanks
> Pavan Kumar N
>
> ------------------------------
> *From:* Timur Akhmadeev <timur.akhmadeev@xxxxxxxxx>
> *To:* "sethmiller.sm@xxxxxxxxx" <sethmiller.sm@xxxxxxxxx>
> *Cc:* Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
> *Sent:* Thursday, 20 November 2014 11:57 PM
> *Subject:* Re: Restore DB from Physical Standby Backup
>
> Do you archive current log on primary before taking backup on standby?
>
> On Thursday, November 20, 2014, 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
>
>
>
> --
> Regards
> Timur Akhmadeev
>
>
>
>
Other related posts:
