RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time
Dear Buddies,
I am trying to recover upto a certain time and I used this SQL in my RMAN
reset database to incarnation 1;
run
{
set until time "to_date('03-Aug-10 17:50:00','DD-MON-YYYY HH24:MI:SS')";
restore database;
recover database;
}
and I receive this error: RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time
I thought changing the incarnation will solve the problem. I have only 2 incarnations, one which is used after the resetlogs which is number 2. So, I am using incarnation 1 now.
How should I go about it?
Thanks in advance.
Nith