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:
Restore the full database on a separate server using a backup performed before the table's
dropoperation.After restoring the database, perform the
until timerecovery.Open the database with
resetlogs.Export the table from the restored database and import it into the production database.
If you are using flashback, you can use it to recover the table. However, if there is no standby database, this will be a disadvantage because we'll need to...