O'Reilly logo

Oracle® 11g For Dummies® by Michael Wessler, Chris Ruel, Chris Zeis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 14. Flashing Back and Replaying: Advanced Features

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 database

  • Flashback data archive

  • Database replay

Each of these features is used to a different end. This chapter explains how these features can add value to your Oracle environment.

Rolling Back with Flashback Database

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.

Note

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:

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required