Using the following query one can see the flashback data available. SELECT to_char(sysdate,'YYYY-MM-DD HH24:MI') current_time, to_char(f.oldest_flashback_time, 'YYYY-MM-DD HH24:MI') OLDEST_FLASHBACK_TIME, (sysdate - f.oldest_flashback_time)*24*60 HIST_MIN FROM v$database d, V$FLASHBACK_DATABASE_LOG f; CURRENT_TIME OLDEST_FLASHBACK HIST_MIN ---------------- ---------------- ---------- 2012-04-25 07:34 2012-04-25 05:48 106.066667
Tag: flashback
Information on flashback feature in 10g
One of the features in 10g is flashback which allows to restores tables that were dropped. Note: If an index is dropped but not a table it can't be restored from flashback but if a table is dropped that has an index you can restore the table and the index from flashback. The example below … Continue reading Information on flashback feature in 10g
Enabling Flashback Database
The following are the requirements for enabling Flashback Database: - Your database must be running in ARCHIVELOG mode, because archived logs are used in the Flashback Database operation. - You must have a flash recovery area enabled, because flashback logs can only be stored in the flash recovery area. - For Real Application Clusters databases, … Continue reading Enabling Flashback Database
alexlima.com 