CHAPTER 13Surviving 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. They are the kinds of errors that 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, ...

Get Oracle Database 10g RMAN Backup & 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.