Home » RDBMS Server » Backup & Recovery » Multiple Times DB PITR from the same database snapshot (Oracle ASM, 11gr2, Linux Redhat 5.4)
Multiple Times DB PITR from the same database snapshot [message #546927] Sat, 10 March 2012 04:15
shrirangphadke
Messages: 1
Registered: March 2012
Location: Pune, Maharashtra, India
Junior Member
Hi Experts,

I am in a big trouble. Any slightest help is appreciated.
I have an Oracle 11gr2 ASM Database with the following diskgroups:

+DATA - Datafiles
+ARCH - Archive logs and Flash Recovery Area
+REDO - Redo and Control file

Lets say I took a snapshot of my ASM DB at 10:00 A.M and mounted DGs as:
+SNP_DATA
+SNP_ARCH
+SNP_REDO

At 11:00 A.M my Database is crashed somehow and I lost control file. So I perform the Incomplete recovery till say 10:45 by copying control file from +SNAP_REDO as:

RMAN> RESTORE CONTROLFILE from '+SNP_REDO/orcl/CONTROLFILE/Current.256.777398761';

And performed DBPIT:

STARTUP MOUNT;
RUN {
SQL "ALTER SESSION SET NLS_DATE_FORMAT = ''dd-mon-yyyy hh24:mi:ss''";
SET UNTIL TIME "06-mar-2012 10:45:00";
RESTORE DATABASE;
RECOVER DATABASE;
ALTER DATABASE OPEN RESETLOGS;
}

Incomplete recovery was successful and after this I could see my restored tables and table spaces and System Incarnation number moved ahead to lets say 3.

After some time my DB is gone again and I want to recover DB again from the same Snapshot.
So I Restored control file again from the same snapshot as:

RMAN> RESTORE CONTROLFILE from '+SNP_REDO/orcl/CONTROLFILE/Current.256.777398761';

and reset the Incarnation number back to 2.

RMAN> RESET DATABASE TO INCARNATION 2;

RESTORE CONTROLFILE from '+SNP_REDO/orcl/CONTROLFILE/Current.256.777398761';
and performed the same PIT recovery, after this I got the following error:

media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/06/2012 12:42:10
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
start until time 'MAR 06 2012 10:45:00'
ORA-00283: recovery session canceled due to errors
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '+REDO/orcl/onlinelog/group_1.257.777249251'
ORA-17503: ksfdopn:2 Failed to open file +REDO/orcl/onlinelog/group_1.257.777249251
ORA-15012: ASM file '+REDO/orcl/onlinelog/group_1.257.777249251' does not exist

Recovery Manager complete.

So I tried performing PIT again using 'NOREDO' as:

STARTUP MOUNT;
RUN {
SQL "ALTER SESSION SET NLS_DATE_FORMAT = ''dd-mon-yyyy hh24:mi:ss''";
SET UNTIL TIME "06-mar-2012 10:45:00";
RESTORE DATABASE;
RECOVER DATABASE NOREDO;
ALTER DATABASE OPEN RESETLOGS;
}

This time I got the following error:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 03/08/2012 13:35:53
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '+DATA/orcl/datafile/system.262.777479565'

Recovery Manager complete.

This behavior is VERY STRANGE. My questions are:

1. How PIT worked for the first time and didn't work for the second time even when I followed the same steps.

and very IMP Question
2. How to perform recovery from a same ASM DB snapshot MULTIPLE TIMES by restoring control file?

Please help.

Same question asked in Oracle forum:
https[//]:forums.oracle.com/forums/thread.jspa?threadID=2358111&tstart=0

[Updated on: Sat, 10 March 2012 04:33]

Report message to a moderator

Previous Topic: RMAN AND ASM
Next Topic: RAC - RMAN restore and recovery to new hosts
Goto Forum:
  


Current Time: Thu Mar 28 14:59:33 CDT 2024