Here in this post, we will be checking useful Flashback Database queries . Before moving into that, let’s check first what is Oracle flashback technology 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 […]
Flashback Database
Oracle Flashback Database explained and limitation
What is Flashback Databasea)New feature from 10.1 onwards, Uses past block images to back out changes to a oracle databaseb)During normal database operation, Oracle occasionally logs past block images in flashback logsc)Flashback logs are written sequentially not archivedd) Oracle automatically creates, resizes and deletes flashback logs in the flash recovery areae) DBA should be aware […]