Redo / Undo / Archive logs from Source database for Oracle Flashback

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Does the the Delphix dSource include the redo & undo logs from Source database? We would like to utilize the Oracles Flashback functionality on top of the virtualized database - like rolling back a specific transaction & its dependents without impacting other transactions in the VDB.

If the dSource includes redo & undo logs from Source (physical) database, can we maintain them with Delphix specific retention or they run on the Source Oracle retention policy for redo + undo?
Photo of RanjeethRao Kashetty

Posted 3 years ago

  • 0
  • 1
Photo of Ganesh Sundaresan

Ganesh Sundaresan, Employee

  • 588 Points 500 badge 2x thumb
Official Response
Hi RanjeethRao -

Using a dSource, when you spin off a VDB in archivelog, you should be able to use Flashback Transaction Query making sure appropriate UNDO* (UNDO_MANAGEMENT, UNDO_TABLESPACE & UNDO_RETENTION) parameters are set right on that VDB.

VDB Snapshot Policy itself will take care of maintaining appropriate retentions of both Snapshots and Archivelogs of the VDB's. You don't have separate VDB retention policy.

Hope this helps.