Tag Archives: Flashback Database

Top 10 Useful Queries for Flashback Database

Introduction to Flashback DatabaseĀ .It is faster than traditional point-in-time recovery. The traditional recovery method uses backups and redo log files; Flashback Database uses a new type of log file called the Flashback Database log. The Oracle database server periodically logs before images of data blocks in the Flashback Database logs. The data block images are used to quickly back out changes to the database during … Continue reading Top 10 Useful Queries for Flashback Database »

Flashback Database explained and limitation

Last updated on November 23rd, 2015 at 08:03 am What is Flashback Database a)New feature from 10.1 onwards, Uses past block images to back out changes to a database b)During normal database operation, Oracle occasionally logs past block images in flashback logs c)Flashback logs areĀ  written sequentially not archived d) Oracle automatically creates, resizes and deletes flashback logs in the flash recovery area e) DBA … Continue reading Flashback Database explained and limitation »