Re: CANNOT ACTIVATE STANDBY
- From: Nassyam Basha <nassyambasha@xxxxxxxxx>
- To: Howard Latham <howard.latham@xxxxxxxxx>
- Date: Thu, 14 Jul 2016 16:50:11 +0530
Hello Howard,
When you say PITR of database, have you performed full database restore(i
hope backup which taken prior to drop table) and then trying to recover
until any particular time/scn? (or) you are trying on the present standby
database?
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
below
ORA-01152: file 1 was not restored from a sufficiently old backup
This happens in case of the MRP is terminated instead of safe cancel, You
can activate standby database any time. So start MRP and immediately cancel
and then for sure you can able to active standby database.
SQL> recover database until cancel using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-01666: control file is for a standby database
This is not applicable for standby, because standby contains standby
control file but not current controlfile or backup controlfile;
The best practice in your case is,, gather the timestamp of scn when the
table was dropped/truncated and you can use log miner, then gather the
datafiles check point and database checkpoint. Ensure database scn is
always less so that you can perform recovery until the point of time you
prefer in order to ensure the table is available.
Thank You.
On Thu, Jul 14, 2016 at 4:05 PM, Howard Latham <howard.latham@xxxxxxxxx>
wrote:
Oracle 112 RH EL4 64BIT
I am trying to do a point in time recovery on a standby to get a table
back for a developer (IT Director)
Anyone got any good ideas? (got a sinus headache as well!...)
pecify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u03/oradata/OLDBARB/system01.dbf'
ORA-01112: media recovery not started
SQL> recover database until cancel using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-01666: control file is for a standby database
SQL>
--
Howard A. Latham
--
Nassyam Basha.
*Oracle Database Consultant*| *Pythian * <
http://www.pythian.com/>
[image: ACED Profile]
<
https://apex.oracle.com/pls/apex/f?p=19297:4:::NO:4:P4_ID:13140>
Oracle 11g Certified Master
<
http://education.oracle.com/education/otn/NassyamBasha.htm>
Co-Author: Oracle Data Guard 11gR2
<
http://www.amazon.in/Oracle-Guard-11gR2-Administration-Beginners/dp/1849687900>
Co-founder of Oraworld-team <
http://www.oraworld-team.com>
[image: Facebook] <
https://www.facebook.com/nassyambasha> [image: Twitter]
<
https://twitter.com/oracle_ckpt> [image: LinkedIn]
<
https://in.linkedin.com/in/nassyambasha> [image: Google +]
<
https://plus.google.com/+NassyamBasha> [image: CKPT Blog]
<
http://www.oracle-ckpt.com/>
<
https://www.facebook.com/nassyambasha>
Other related posts:
