I have a hot backup from yesterday. Try to do point-in-time recovery and get the following:
RMAN-08031: released channel: d2
RMAN-08031: released channel: d3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20207: UNTIL TIME is
before RESETLOGS time
I do confirm that backupsets are in the catalog database. Here is my recovery script.
run {
allocate channel d1 type 'SBT_TAPE';
allocate channel d2 type 'SBT_TAPE';
allocate channel d3 type 'SBT_TAPE';
restore database
until time "to_date('Aug 27 2001 02:00:00','Mon DD YYYY HH24:MI:SS')";
recover database
until time "to_date('Aug 27 2001 1:25:00','Mon DD YYYY HH24:MI:SS')";
sql "alter database open resetlogs";
release channel d1;
release channel d2;
release channel d3;
}
## If successful, need to run reset database below
##reset database
