RE: Restore DB from Physical Standby Backup
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <sethmiller.sm@xxxxxxxxx>, "'pavan kumar'" <pavan_843@xxxxxxxxxxx>
- Date: Sat, 22 Nov 2014 22:39:33 -0500
Silly question: Did you use ‘using backup controlfile’ so that it does not try
to bring you current?
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Seth Miller
Sent: Friday, November 21, 2014 3:18 PM
To: pavan kumar
Cc: timur.akhmadeev@xxxxxxxxx; Oracle-L Freelists
Subject: Re: Restore DB from Physical Standby Backup
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:
