How does Flashback work in Oracle?
How does Flashback work in Oracle? Flashback Features Oracle Flashback Database enables point-in-time-recovery of the entire database without requiring a traditional restore and recovery operation. It rewinds the entire database to a specified point in time in the past by undoing all the changes that were made since that time. How do I restore a flashback database? To restore your database to a guaranteed restore point, follow the steps below: $> $> sqlplus / as sysdba;SQL> select current_scn from v$database;SQL> shutdown immediate;SQL> startup mount;SQL> select * from v$restore_point;SQL> flashback database to restore point CLEAN_DB;SQL> alter database open resetlogs; What is...