O'Reilly logo

OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide by Steve Ries

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

Understanding the categories of database failure

Although instance recovery does not require the intervention of a DBA, many other types of failure do. Not all of these failures are what we might consider true "recovery" scenarios, but the DBA may be called on to address such failures. We examine these categories here and end with those that do require database recovery.

Addressing statement failures

A statement failure occurs when a SQL statement, either DML or DDL, fails before its execution has completed. There are many situations that can cause a statement failure. One of the most basic is a DML statement that initiates a transaction, such as an UPDATE. If the UPDATE fails part of the way through execution, the transaction is automatically ...

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