UNTIL CHANGE恢复：
SQL> shutdown immediate;
SQL> startup mount;
SQL> recover database until change 309121;
SQL> alter database open resetlogs;
UNTIL SCN恢复：
RMAN> run {
allocate channel d1 type disk;
allocate channel t1 type sbt_tape;
shutdown immediate;
startup mount;
set until scn 309121;
restore database;
recover database;
alter database open resetlogs;}
SQL> shutdown immediate;
SQL> startup mount;
SQL> recover database until change 309121;
SQL> alter database open resetlogs;
UNTIL SCN恢复：
RMAN> run {
allocate channel d1 type disk;
allocate channel t1 type sbt_tape;
shutdown immediate;
startup mount;
set until scn 309121;
restore database;
recover database;
alter database open resetlogs;}
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11411056/viewspace-733742/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
