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;
This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply