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:
If we're not using flashback, the steps to restore a table loss will be as follows:
drop
operation.until time
recovery.resetlogs
.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.