oracle不完全恢复

先记录下scn select current_scn from v$database;

建表create table test1 as select * from v$transportable_platform;

删除表drop table test;

shutdown immediate;
startup mount;

RMAN> connect target sys/000000@ORCL1

RMAN> run {
 set until scn 1836630;
 restore database;
 recover database;
 }

 

转载于:https://www.cnblogs.com/Babylon/p/8493132.html