本文主要是介绍FLASHBACK的一些设置经验，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
以下是工作中对database flashback的一些设置经验：
1)Change the initialization Parmeter- init.ora.
db_recovery_file_dest_size=20g
db_recovery_file_dest='/axptpharch/axptphq/flasharea'
DB_FLASHBACK_RETENTION_TARGET=10080
log_archive_dest_1='location=/oradb/arch'
control_file_record_keep_time=14
#
log_archive_format=oradb_arc_%t_%s_%r.arc
and comment out
#log_archive_dest='/oradb/arch'
2)Starting database in flashback Mode:
svr << EOF
spool $spooltofile_temp
shutdown immediate;
startup mount;
alter database flashback off;
drop restore point WMOS_GOLD_COPY;
alter database flashback on;
alter database open;
create restore point WMOS_GOLD_COPY guarantee flashback database;
spool off
3)Flashing back the database to previous image:
svr << EOF
spool $spooltofile_temp
shutdown immediate;
startup mount;
FLASHBACK DATABASE TO RESTORE POINT WMOS_GOLD_COPY;
alter database flashback off;
alter database open resetlogs;
spool off
这篇关于FLASHBACK的一些设置经验的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
