Flashback log Files Older Than OLDEST_FLASHBACK_TIME Not Deleted .What is TYPE Reserved in v$flashback_database_logfile

(Doc ID 2369101.1)

Last updated on MARCH 12, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.2.0.1 [Release 11.2 to 12.2]
Information in this document applies to any platform.

Goal

This document explains what is Type RESERVED in V$FLASHBACK_DATABASE_LOG and when you might see Old Flashback logs .

SELECT OLDEST_FLASHBACK_SCN, OLDEST_FLASHBACK_TIME FROM V$FLASHBACK_DATABASE_LOG;

OLDEST_FLASHBACK_SCN OLDEST_FLASHBACK_TIM
-------------------- --------------------
4843455 06-FEB-2018 10:09:16


but in file system, there is one Flashback log file which has not got purged.

-rw-r----- 1 oracle dbalinux 209723392 Feb 5 16:33 o1_mf_fabcde_.flb


 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms