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

相关推荐

  1. Oracle清理

    2024-03-29 13:40:04       35 阅读
  2. oracle 清理归档

    2024-03-29 13:40:04       59 阅读
  3. clickhouse清理

    2024-03-29 13:40:04       56 阅读
  4. Android-实现记录“异常退“

    2024-03-29 13:40:04       27 阅读
  5. Mysql、Oracle 审计的开启

    2024-03-29 13:40:04       28 阅读
  6. [运维|shell] 编写shell脚本定期清理

    2024-03-29 13:40:04       56 阅读

最近更新

  1. docker php8.1+nginx base 镜像 dockerfile 配置

    2024-03-29 13:40:04       94 阅读
  2. Could not load dynamic library ‘cudart64_100.dll‘

    2024-03-29 13:40:04       100 阅读
  3. 在Django里面运行非项目文件

    2024-03-29 13:40:04       82 阅读
  4. Python语言-面向对象

    2024-03-29 13:40:04       91 阅读

热门阅读

  1. 【前端基础】使用 typeof 进行类型判断注意点

    2024-03-29 13:40:04       37 阅读
  2. 【计算机网络】计算机网络体系结构简要说明

    2024-03-29 13:40:04       35 阅读
  3. 使用VSCode搭建Vue 3开发环境

    2024-03-29 13:40:04       47 阅读
  4. 一.音视频编辑 - 功能概述

    2024-03-29 13:40:04       44 阅读
  5. LVS(Layout versus schematic)比的是什么?

    2024-03-29 13:40:04       40 阅读
  6. 网络安全的攻防战争

    2024-03-29 13:40:04       34 阅读
  7. Mysql中不同库的两个表怎么做数据同步

    2024-03-29 13:40:04       39 阅读