select dbms_flashback.get_system_change_number fscn from dual;
sys 用戶 下scn
FLASHBACK TABLE AAA TO BEFORE DROP;(恢復整個表)
FLASHBACK TABLE AAA TO BEFORE DROP RENAME TO OLD_AAA ;(恢復整個表)
ALTER TABLE AAA ENABLE ROW MOVEMENT;(允許表行移動)
FLASHBACK TABLE AAA TO TIMESTAMP (SYSDATE-10/1440); (將表恢復到某個時間段)
FLASHBACK TABLE AAA TO SCN SCNNUMBER; (將表恢復到某個SCN以前)
FLASHBACK database
先設置FLASHBACK on
1. startup mount exclusive;
alter database archivelog;
alter database FLASHBACK on ;
alter database open;
2.shutdown;
startup mount exclusive;
FLASHBACK databse TO SCN SCNNUMBER (TO TIMESTAMP (SYSDATE-10/1440));
alter database open resetlogs;
3.startup mount exclusive;
alter database FLASHBACK off;
alter database open;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25850100/viewspace-703942/ ，如需转载，请注明出处，否则将追究法律责任。
