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;

 

posted @ 2024-03-20 16:17  任国强  阅读(14)  评论(0编辑  收藏  举报