Understanding Flashback Technology - OCP: Oracle Database 12c Administrator Certified Professional - page 389

OLDEST_FLASHBACK_SCN OLDEST_FLASHBACK_TIME
-------------------- ---------------------
979720 20-JUL-13
SQL>
2. Next, shut down and start the database in mount mode:
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup mount
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1334380 bytes
Variable Size 171967380 bytes
Database Buffers 356515840 bytes
Redo Buffers 5844992 bytes
Database mounted.
SQL>
3. Next, issue the Flashback Database recovery command to an SCN that is associated
with a restore point newer than the OLDEST_FLASHBACK_SCN discussed previously:
SQL> flashback database to scn 979721;
Flashback complete.
SQL>
4. Finally, open the database with the RESETLOGS option, because you recovered to a time
prior to the current database:
SQL> alter database open resetlogs;
Database altered.
SQL>
As you can see, the Flashback Database recovery is a fairly simple process. The
V$FLASHBACK_DATABASE_LOG dynamic view is useful for both TO SCN and TO TIME recover-
ies. The Flashback Database recovery is a quick and efficient method for recovering from
user errors or logical corruptions in the database. This is a great alternative to performing
a traditional incomplete recovery.