CHAPTER 11Flashback Recovery

Media recovery, as outlined in Chapter 10, provides us with safeguards against all kinds of unforeseeable problems—block corruption, hardware failure, even complete database loss. But you may have noticed that Chapter 10 didn’t cover the largest cause of media recovery operations: user error.

We know. We know that user-induced outages are the most frustrating, because we expect humans to catch their own mistakes, whereas hard drives and motherboards all fail. They just do. But user errors happen, too. For this reason, the MAA DBA must be prepared to handle user errors efficiently.

User errors can be roughly defined as errors caused by a human mistake, rather than a software or hardware malfunction: tables updated ...

Get Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, RAC and Data Guard, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.