RMAN Restore to Point in Time


shutdown abort;
startup nomount;
alter database mount;
catalog start with '/reco/DB_NAME';
run {
set until time "to_date('2019-01-16 10:54:00', 'yyyy-mm-dd:hh24:mi:ss')";
restore database;
recover database;
}
alter database open resetlogs;



HOME