| 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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
