Content #
- 创建Restore Point
CREATE RESTORE POINT restore_point_name GUARANTEE FLASHBACK DATABASE;
使用GUARANTEE FLASHBACK DATABASE选项可以确保即使发生介质故障，也可以恢复到这个Restore Point。
select name, scn from v$restore_point;
- 恢复到Restore Point
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
FLASHBACK DATABASE TO RESTORE POINT restore_point_name;
ALTER DATABASE OPEN RESETLOGS;
RESETLOGS选项用于重置联机重做日志的序列号。
-
删除 Restore Point
DROP RESTORE POINT restore_point_name;