Backup And Recovery User's Guide-建立正常和保證的還原點

--1.確定資料庫是OPEN或MOUNT狀態。

--  如果資料庫是MOUNT狀態,則它必須已經被幹淨地關閉,除非它是物理備用資料庫

--2.1 建立正常的還原點

sys@TESTDB12>create restore point rp_before_delete;

Restore point created.

sys@TESTDB12>delete from scott.emp where deptno = 10;

3 rows deleted.

sys@TESTDB12>commit;

Commit complete.

--2.2 建立保證的還原點

sys@TESTDB12>create restore point rp_before_insert guarantee flashback database;

Restore point created.

sys@TESTDB12>insert into scott.dept values(50, 'DnameA', 'LocA');

1 row created.

sys@TESTDB12>commit;

Commit complete.