Skip to Main Content
  • Questions
  • Flashback Database and nologging operations

Breadcrumb

May 4th

Question and Answer

Thanks for the question.

Asked: June 12, 2019 - 6:44 pm UTC

Last updated: June 12, 2019 - 6:44 pm UTC

Version:

Viewed 10K+ times! This question is

You Asked

Does Flashback Database work with nologging operations?

and we said...

Flashback DB works with no logging operations. However, anytime media recovery applies nologging redo to a block, it will mark the block corrupt. So if one flashback a database to the middle of a nologging operation, the database may have blocks marked as logically corrupt. 

One way to fix such corrupt blocks is to drop the table containing corrupt blocks and reload the table.

One way to avoid such corrupt blocks is to always flashback the database to either before a nologging operation or at least 30 minutes after the completion of a nologging operation.


Is this answer out of date? If it is, please let us know via a Comment