Please find my environment details,
OS: Window xp
VERSION: Oracle 11.2.0.1.0
SERVER:Test server
Please find My scenario,
Date : June 11
I have created one table called table_level0 and then take Leve 0 Backup
Date : June 12
I have created one table called L1_JUNE12 and then taken Leve 1 Backup
Date : June 13
I have created one table called L1_JUNE13 and then taken Level 1 Backup,
Date : June 14
I have created one table called L1_JUNE14 and then taken Level 1 Backup
Date : June 14
I have created one table called L1_JUNE14
and dropped a table called L1_JUNE14 and then taken Level 1 Backup
Restoration Scenario and my Question based on error which i faced
I made restoration up to June 13 end of the day, by using following script,
run {
set until time "to_date('06/13/15 23:55:00','mm/dd/yy hh24:mi:ss')";
restore database;
recover database;
}
and restoration completed successfully with following RMAN prompt message
after that i opened database with command of 'alter database open resetlogs' ( Database been set based restored time and Redo log also)
media recovery complete, elapsed time: 00:00:06
Finished recover at 15-JUN-15
RMAN> exit;
Below is my Question that,
Question 1
I assumed that i have restored one day advance, so i want to go backup my database up to June 12, like below,
run {
set until time "to_date('06/12/15 23:55:00','mm/dd/yy hh24:mi:ss')";
restore database;
recover database;
}
And i am facing following error,
RMAN> run {
2> set until time "to_date('06/12/15 23:55:00','mm/dd/yy hh24:mi:ss')";
3> restore database;
4> recover database;
5> }
** RMAN output with Error
executing command: SET until clause
new incarnation of database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
Starting restore at 15-JUN-15
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/15/2015 18:12:08
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20207: UNTIL TIME
or RECOVERY WINDOW is before RESETLOGS time
RMAN>
and
Question 2
I decided that i have restored and recover database one day back(June 13) and need to restore and recover based on June 14 and use script like below,
run {
set until time "to_date('06/14/15 23:55:00','mm/dd/yy hh24:mi:ss')";
restore database;
recover database;
}
** RMAN output with error**
RMAN> run {
2> set until time "to_date('06/14/15 23:55:00','mm/dd/yy hh24:mi:ss')";
3> restore database;
4> recover database;
5> }
executing command: SET until clause
Starting restore at 15-JUN-15
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/15/2015 18:17:39
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20207: UNTIL TIME
or RECOVERY WINDOW is before RESETLOGS time
RMAN>
This is real time work scenario, I may be faced this situation,
So, Is it possible to do restore and recover based on backdate / Forward date after once restoration done.
If it is possible then please give some idea or web link or script to achieve it or tell me if it is not possible.