flashback根據SCN恢復資料庫-优快云博客

15:18:28 SYS@orcl>select count(*) from aa;

COUNT(*)
----------
72372

15:18:35 SYS@orcl>select current_scn from v$database;

CURRENT_SCN
-----------
16106869

15:19:06 SYS@orcl>delete from aa;

已刪除 72372 個資料列.

15:19:37 SYS@orcl>select count(*) from aa;

COUNT(*)
----------
0

15:20:30 SYS@orcl>shutdown immediate
ORA-01097: 交易進行時無法關閉－請先確認 (commit) 或倒回 (rollback)
15:20:36 SYS@orcl>commit;

確認完成.

15:20:41 SYS@orcl>shutdown immediate
資料庫關閉.
資料庫已卸載.
已關閉 ORACLE 執行處理.
15:20:54 SYS@orcl>startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE 執行處理已啟動.

Total System Global Area 497995776 bytes
Fixed Size                  1337464 bytes
Variable Size             385877896 bytes
Database Buffers          104857600 bytes
Redo Buffers                5922816 bytes
資料庫已掛載.
15:21:17 SYS@orcl>flashback database to scn 16106869;

完成倒溯.

15:21:41 SYS@orcl>alter database open resetlogs;

已更改資料庫.

15:24:14 SYS@orcl>select count(*) from aa;

COUNT(*)
----------
72372

添加恢復表：

SQL>flashback table pms.pt_pole_drre to timestamp to_timestamp('2012/05/09 14:20:00','YYYY/MM/DD HH24:MI:SS');

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16381228/viewspace-716873/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16381228/viewspace-716873/