Skip to Main Content
  • Questions

  • Understanding Oracle Flashback Logs and Point-in-Time Recovery Limitations

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Robin.

Asked: September 25, 2025 - 11:21 pm UTC

Last updated: September 30, 2025 - 3:10 am UTC

Version: Oracle Database Version: 21c (based on Expert Oracle Database Architecture, 4th Edition)

You Asked

How does Oracle's flashback technology utilize flashback logs to enable point-in-time recovery, and what limitations should DBAs be aware of?

and Connor said...

Here's a (very old, so sorry about the quality) video of mine which describes how flashback logs work, and how they also need archived redo to function




more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.