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 flash back the whole database to that particular time. So there will be loss of transactions.
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.