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

建表create table test1 as select * from v$transportable_platform;
oracle不完全恢复_删除表
删除表drop table test;

oracle不完全恢复_删除表_02
shutdown immediate;
startup mount;

RMAN> connect target sys/000000@ORCL1

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