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.
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 ...