Flashback Logs保留删除规则

1  闪回区有足够空间,并且在 flashback retention target要求范围内,flashback log 将要被创建

2  一旦超过flashback retention target时间要求,flashback log将要被覆盖

3  闪回区已满或者磁盘空间不足时,flashback log将要被覆盖
4  闪回区已满,为了为其他文件腾出空间,归档日志会被删除,flashback log 也可能被删除

5.3.5.1 Rules for Retention and Deletion of Flashback Logs

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

  • 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.

  • 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.

    Note:

    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.

请使用浏览器的分享功能分享到微信等