oracle10g提供了一个叫做闪回恢复区(Flashback recovery area)的新特性,可以将所有恢复相关的文件,比如flashback log,archive log,backup set等,放到这个区域集中管理。
查看闪回区内容及使用情况:
select * from v$flash_recovery_area_usage;
由oracle估计flashback的大小:
SELECT ESTIMATED_FLASHBACK_SIZE FROM V$FLASHBACK_DATABASE_LOG;
修改flashback的大小:
alter system set db_recovery_file_dest_size=8G;
修改时间限制:
SQL> alter system set db_flashback_retention_target = 2880;
具体介绍请看:
http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14192/rpfbdb003.htm#BABJJCHF
查看闪回区内容及使用情况:
select * from v$flash_recovery_area_usage;
由oracle估计flashback的大小:
SELECT ESTIMATED_FLASHBACK_SIZE FROM V$FLASHBACK_DATABASE_LOG;
修改flashback的大小:
alter system set db_recovery_file_dest_size=8G;
修改时间限制:
SQL> alter system set db_flashback_retention_target = 2880;
具体介绍请看:
http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14192/rpfbdb003.htm#BABJJCHF