CHAPTER 15Surviving User Errors: Flashback Technologies

Media recovery with RMAN provides critical safeguards against all kinds of unforeseeable problems—block corruption, hardware failure, even complete database loss. But so far, this book has ignored the largest cause of media recovery operations: user error.

User errors can be roughly defined as errors caused by a human mistake (rather than a software or hardware malfunction), such as a table updated with wrong values, a table dropped, or a table truncated. Such errors are far more common than hardware failures (although, let’s face it, human errors get called hardware errors all the time). In general, user errors are classified as logical errors—the error is logical, within the data itself, ...

Get Oracle RMAN 11g Backup and Recovery 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.