Oracle Flashback

FlashBack

1. Regedit edit oracle_sid = unis2/unip2 (set oracle_sid=unis2/unip2)
2. Cmd sqlpuls / as sysdba;
3. Select instance_name from v$instance_name check instance_name=oracle_sid;
4. SELECT timestamp_to_scn(to_timestamp('2011-12-06 08:00:00 AM', 'YYYY-MM-DD HH:MI:SS PM')) FROM dual;
5. Check data
6. Shutdown immediate;
7. Startup mount;
8. Flashback database to scn XXX;
9. Alter database open read only;
10.  Check data
11. Shutdown immediate;
12. Startup mount;
13. Alter database open  (archivelog);//alter database open resetlogs

 

Note:

A. please make sure the archivelog is open before you open you falshback.
B. Check the falshback whether is opened? Open& Close
 select flahback_on from v$database;
 Open: alter database flashback on;
 Close: alter database flashback off;
C. Check the archive log status, and Open&Close it.
 Check status: archive log list
 open: alter database archivelog;
 Close: alter database noarchivelog
D. Check DB status: select status from v$instance;
E. 查看闪回区域详细信息：
 show parameter db_recovery_file_dest;
F. 修改闪回时间，默认1440
 alter system set db_flashback_retention_target=2880
db_flashback_retention_target