First page Back Continue Last page Graphics
...Flashback Database
Versus traditional PIT recovery
- Easy to use
- Faster
- Restoring files unnecessary
- Can easily re-flashback more than once
FLASHBACK DATABASE statement uses
- Flashback logs
- Archived redo logs
Notes:
The benefits (versus traditional point-in-time recovery) include:
As I will demonstrate later in this lesson, it is easy to use.
Restoring datafiles from backup sets or image copies is unnecessary. Therefore, recovery is faster than traditional point-in-time recovery.
After you have flashed back the database you can query the database, confirm you like what you see, then use OPEN RESETLOGS to make the database generally available. If you do not like the point in time you have flashed back to, simply flash back again.
The flashback database operation uses a combination of flashback logs and archived redo logs to restore the database to the point requested. Next, we’ll learn more about flashback logs.