June 2013
Beginner
404 pages
9h 40m
English
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.
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 ...