How Far Back Can I Flashback My Database To?

by Seth Miller

Flashback Database
Here is a useful query to find out the current limit of flashback database. Change the ‘US/Central’ to your local time zone to convert the time zone your database is in to your local time zone.

The first column is the earliest point in time you can flashback the database to. The second column is the number of hours between now and the earliest point in time you can flashback your database to truncated to one decimal point.

select cast(
            from_tz(
                    cast( oldest_flashback_time as timestamp )
                   ,dbtimezone )
            at time zone 'US/Central' as date ) oldest_db_fb
       ,round((sysdate - oldest_flashback_time) * 24, 1) oldest_db_fb_hours
  from v$flashback_database_log;