Oracle清理闪回日志

本文主要是介绍Oracle清理闪回日志，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

关于闪回日志的说明：
一旦关闭闪回，flashback recovery area中的闪回日志将自动全部删除
闪回日志在出现空间压力的情况下，oracle会自动删除闪回日志，否则有可能导致无法闪回到指定的时间点

参考文档：

NOTE:305817.1 - FAQ - Flash Recovery Area feature
NOTE:305812.1 - Flash Recovery area - Space management Warning & Alerts
NOTE:397269.1 - Relation between RMAN retention period and control_file_record_keep_time
NOTE:305648.1 - What is a Flash / Fast Recovery Area and how to configure it ?Flash Recovery area - Space management Warning & Alerts (Doc ID 305812.1)
Oracle does not delete eligible files from the Flash Recovery Area until the space must be reclaimed for some other purpose. The effect is that files recently moved to tape are often still available on disk for use in recovery. The recovery area can thus serve as a kind of cache for tape. Once the Flash Recovery Area is full, Oracle automatically deletes eligible files to reclaim space in the Flash Recovery Area as needed.

关库：

shutdown immediate;

关闭闪回：

alter database flashback off;

到闪回目录确认闪回日志是否删除

开启闪回

alter database flashback on;

查看闪回保留时间

show parameter db_flashback_retention_target

酌情重设

alter system set db_flashback_retention_target=1440 scope=spfile;   （单位是minutes）1440minutes=24h

关库：

shutdown immediate;

起库

startup mount

这篇关于Oracle清理闪回日志的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---