First page Back Continue Last page Graphics
Flashback Database...
New RMAN command and SQL statement
Recover database to some:
- SCN
- Time
- Redo Log sequence number
- Restore point
Alternative to point-in-time recovery
- Only can undo transactions
- Not for lost or corrupt datafiles
- Not for media failures
Notes:
Oracle 10g Release 1 (Enterprise Edition only) provides a new and easy alternative to using RMAN (or other methods) to perform a point-in-time (incomplete) recovery: Flashback Database. The FLASHBACK DATABASE statement is implemented as an SQL statement and an RMAN command. (The RMAN command provides more functionality, such as the ability to flashback database to a log sequence number.)
Flashback database is an alternative to point-in-time (incomplete) recovery. However, it cannot be used in cases of corrupt datafiles or media failure. The database must be in good working order for the FLASHBACK DATABASE statement to work.