Database Reference
In-Depth Information
Step 4:
The following statement will enable the Flashback database
feature.
SQL> ALTER DATABASE FLASHBACK ON;
Step 5:
Now the database is ready to make available to end users i.e. to
open.
SQL> ALTER DATABASE OPEN;
How Flashback Database can help?
We can use RMAN to perform recoveries on the Flashback
Database (or database having Flashback feature on). The
database has to be in the MOUNT state to perform such type of
recovery. Moreover, you need to get either the
OLDEST_FLASHBACK_SCN or
OLDEST_FLASHBACK_TIME from a
V$FLASHBACK_DATABASE_LOG dynamic performance
view. Following example will take you the step by step process
of taking the whole database to previous point in time using
RMAN.
Step 1:
Run SQL*Plus and connect as SYSDBA.
C:\Documents and Settings\Administrator> SQLPLUS /NOLOG
SQL> CONNECT / AS SYSDBA
Step 2:
The following command will start the Oracle Instance and mount
the database.
SQL> STARTUP MOUNT
Search WWH ::
Custom Search