Hi experts ;)
i have a question on incomplete recovery with RMAN, with UNTIL TIME CLAUSE.
I have this situation:
T1............. T2 ......T? ..............T3........................... T4......... T5
___________ __________________ ___________________ ________
................BKP.........................BKP...........................BKP
T1 is initial time, T5 is now.
T2, T3, T4 r the time in which i make backup (BKP)
I'd like to restore my DB, at T? time. It's between T2 and T3.
I make correct syntax but i receive this error:
run {
shutdown immediate;
startup mount;
sql "alter session set nls_date_format = ''DD-MON-YYYY HH24:MI:SS''";
set until time '14-MAR-2008 12:11:00';
restore database;
recover database;
alter database open resetlogs;
}
Error:
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20207: UNTIL TIME is before RESETLOGS time
It's possibile this kind of recovery? or i can only recover the last version of backups?
PS:Sorry for my poor english