1、 设置Flash recovery area:
两个动态参数(db_recovery_file_dest_size和db_recovery_file_dest)
2、 设置db_flashback_retention_target
3、 设置flashback database为on:
Shutdown immediate;
Startup mount exclusive;
Alter database flashback on;
Alter database open;
4、 闪回操作:
Shutdown immediate;
Startup mount;
flashback database to timestamp(to_date('2008-08-07 08:16:07','yyyy-mm-dd hh24:mi:ss'))
alter database open resetlogs;
5、 查询:
V$flashback_database_logfile
V$flashback_database_log
V$flashback_database_stat
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/38542/viewspace-1009313/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/38542/viewspace-1009313/