O'Reilly logo

Oracle Data Guard 11gR2 Administration Beginner's Guide by Nassyam Basha, Emre Baransel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using flashback on a standby database

Flashback is a useful feature introduced in Oracle database version 9i and more properties were added on in the next versions, 10g and 11g. When enabled, the flashback feature helps us recover data loss, corrupted data, or logical errors easily. In the following scenarios, we can use flashback with PITR (Point-in-Time Recovery) to recover data:

  • Dropped tables
  • Truncated tables
  • Massive changes by inserts / updates / deletes
  • Logical errors

If we're not using flashback, the steps to restore a table loss will be as follows:

  1. Restore the full database on a separate server using a backup performed before the table's drop operation.
  2. After restoring the database, perform the until time recovery.
  3. Open the database with resetlogs ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required