How to Check the Required Data is Present in Flashback Database or not for Recovery?

advertisements

_____________________________________________________________________________________________________________________

Here is the query to find out whether you can recover the lost data using the flashback database option.

SQL>select to_char(OLDEST_FLASHBACK_TIME,'dd-mm-yyyy hh:mi'), to_char(sysdate,'dd-mm-yyyy hh:mi') FROM V$FLASHBACK_DATABASE_LOG;

TO_CHAR(OLDEST_F TO_CHAR(SYSDATE,

---------------- ----------------
28-06-2014 01:34 28-08-2014 02:19

Here in above result we have the data from 28th of June as the transaction is very less with the database. Almost 2 months data can be flashback.

If the results of above query regularly indicate that the flashback database window does not satisfy the flashback retention target, you may need to increase your flash recovery area to accommodate more flashback logs. Again it would be as per your requirement.

The above view refers how much flashback log data is present for the database. However, the operations like shrinking or dropping of datafile, which can prevent the flashback database from succeeding against your entire database, even if flashback log data is available. The above query result will not reflect such cases.

_____________________________________________________________________________________________________________________

Live Traffic Feed

A visitor from Meise viewed 'How to Enable or Disable the Supplemental Logging ' 11 mins ago

A visitor from Washington viewed 'ORA-00059: maximum number of DB_FILES exceeded - F' 48 mins ago

A visitor from Vladimir viewed 'How to Delete / Drop All the Tables in One / Multi' 52 mins ago

A visitor from Singapore viewed 'Oracle SQL Script to Check Index Fragmentation and' 1 hr 42 mins ago

A visitor from Mumbai viewed 'Oracle Sequence Cycle vs Nocycle Difference and Co' 2 hrs 6 mins ago

Real-time | Get Script | More Info