Oracle RMAN restore & recover until – assuming you don’t have redo or just want to recover to an earlier point

assuming you have the control FILE and

after a “startup mount;”

using the controlfile to restore/RECOVERABLE

rman target /
restore database UNTIL TIME
“to_date(’12/31/2021 11:34:50 am’,’mm/dd/yyyy hh:mi:ss am’)”;

recover database UNTIL TIME
“to_date(’12/31/2021 11:34:50 am’,’mm/dd/yyyy hh:mi:ss am’)”;

alter database open resetlogs;

OR

run
{
set UNTIL TIME “to_date(’12/31/2021 11:34:50 am’,’mm/dd/yyyy hh:mi:ss am’)”;
restore database;
recover database;
alter database open resetlogs;
}

Leave a Comment

Scroll to Top