Time for action – using flashback on a standby database
Now we are going to see how to recover a dropped/truncated table if a standby database exists, and using the flashback feature. We won't make any changes to the primary database and even the flashback feature may be off on the primary database.
- Enabling flashback: To perform recovery of an object, flashback must be enabled on the standby database. Ensure MRP is cancelled before enabling flashback.
SQL> alter database recover managed standby database cancel; Database altered. SQL> alter database flashback on; Database altered. SQL> select db_unique_name,flashback_on from v$database; DB_UNIQUE_NAME FLASHBACK_ON --------------- ------------------ INDIA_UN YES
On the alert log, you will get the ...