In This Chapter
Visiting the flashback database
Flashing back to the data archive
Replaying the database
This chapter details features that you don't see on most Oracle enterprises day to day. (Of course, someone out there will disagree and we apologize.) Regardless, most DBAs who are new to the sport probably won't start here; these features are for more advanced administration.
You might assume these things are related:
Flashback data archive
Each of these features is used to a different end. This chapter explains how these features can add value to your Oracle environment.
Have you ever wanted a time machine? No such thing exists. Or does it? The Oracle time machine known as flashback database lets you rewind, fast forward, and recover from situations with ease. Flashback database can sound intimidating, but the feature is simple.
You could argue that moving the database forward and back with Oracle Recovery Manager with good backups is possible. However, restoring a large database to a previous point is time consuming and tedious. Also, if you don't go back far enough, you have to start all over from the beginning.
Flashback database works by recording extra information that allows you to roll back transactions without doing a full database recovery. Not only that, but it works very quickly. The flashback database has these quick features, among others: