Check how older you can flashback in Oracle

Check how older can we flashback To time.

select to_char(oldest_flashback_time,'dd-mon-yyyy hh24:mi:ss') "Oldest Flashback Time" from v$flashback_database_log;

Check how far back can we flashback To SCN.

select oldest_flashback_scn from v$flashback_database_log;

Check the flashback area usage.

SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.