Windows Server 2019 Oracle 19c Restore & Recovery
RMAN> CONNECT TARGET /;
RMAN> run {
SQL> shutdown immediate;
startup mount force;
startup mount;
set until time "to_date('2024-03-19 05:36:58','yyyy-mm-dd hh24:mi:ss')";
restore database;
recover database;
alter database open resetlogs;
}
RMAN> shutdown immediate;
RMAN> startup mount; # REM startup mount force;
RMAN> restore database until time "to_date('2024-03-19 05:36:58','yyyy-mm-dd hh24:mi:ss')";
RMAN> recover database until time "to_date('2024-03-19 05:36:58','yyyy-mm-dd hh24:mi:ss')";
RMAN> alter database open resetlogs;