Databases Reference
In-Depth Information
Disabling Flashback on a Database
Problem
You want to disable flashback mode for a database.
Solution
Disable flashback mode by issuing the following SQL statement:
SQL> alter database flashback off;
Database altered.
Now the database is running in nonflashback mode.
How It Works
When the database is taken out of flashback mode, the flashback logs are not generated anymore. You can check that
the database has indeed been taken off flashback mode by issuing the following query:
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------
NO
The result shows NO, confirming that the database is not running in flashback mode now.
Flashing Back a Database from RMAN
Problem
You want to flash a database back to a point in time in the past through RMAN.
Solution
When you want to flash the database back to a time in the past, you have a few choices in deciding when to flash back
to. You can flash back to the following:
•
A specific point in time, specified by date and time
•
A specific SCN number
resetlogs
operation
•
The last
•
A named restore point
We describe each of these scenarios in the following sections. Each of the solutions, however, has some common
tasks before and after the actual flashback.
