签到成功

知道了

CNDBA社区CNDBA社区

Flashback Logs保留删除规则

2022-09-08 21:19 983 0 原创 oracle
作者: hbhe0316

1 闪回区有足够空间,并且在 flashback retention target要求范围内,flashback log 将要被创建
2 一旦超过flashback retention target时间要求,flashback log将要被覆盖
3 闪回区已满或者磁盘空间不足时, flashback log将要被覆盖
4 闪回区已满,为了为其他文件腾出空间,归档日志会被删除,flashback log 也可能被删除http://www.cndba.cn/hbhe0316/article/108662

The following rules govern the flash recovery area’s creation, retention, overwriting and deletion of flashback logs:

http://www.cndba.cn/hbhe0316/article/108662
http://www.cndba.cn/hbhe0316/article/108662
http://www.cndba.cn/hbhe0316/article/108662

A flashback log is created whenever necessary to satisfy the flashback retention target, as long as there is enough space in the flash recovery area.http://www.cndba.cn/hbhe0316/article/108662http://www.cndba.cn/hbhe0316/article/108662

A flashback log can be reused, once it is old enough that it is no longer needed to satisfy the flashback retention target.

If the database needs to create a new flashback log and the flash recovery area is full or there is no disk space, then the oldest flashback log is reused instead.

http://www.cndba.cn/hbhe0316/article/108662

Note:http://www.cndba.cn/hbhe0316/article/108662http://www.cndba.cn/hbhe0316/article/108662

Re-using the oldest flashback log shortens the flashback database window. If enough flashback logs are reused due to a lack of disk space, the flashback retention target may not be satisfied.
If the flash recovery area is full, then an archived redo log may be automatically deleted by the flash recovery area to make space for other files. In such a case, any flashback logs that would require the use of that redo log file for the use of FLASHBACK DATABASE are also deleted.

http://www.cndba.cn/hbhe0316/article/108662

版权声明:本文为博主原创文章,未经博主允许不得转载。

oracle

用户评论
* 以下用户言论只代表其个人观点,不代表CNDBA社区的观点或立场
hbhe0316

hbhe0316

关注

1.只有承认无知,才能装下新的东西; 2.进步来自一点点滴滴的积累; 3.广博让你更优秀,而专业让你无法替代; 4.挫折和失败能够转换为一种财富。

  • 889
    原创
  • 1
    翻译
  • 13
    转载
  • 24
    评论
  • 访问:1040596次
  • 积分:1523
  • 等级:核心会员
  • 排名:第6名
精华文章
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        Copyright © 2016 All Rights Reserved. Powered by CNDBA · 皖ICP备2022006297号-1·

        QQ交流群

        注册联系QQ