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 rolled back. Statements that cause constraint violations, such as the violation of a primary key to foreign key relationship, are types of statement failures. Datatype mismatch errors fall into this category as well. Another type of statement failure...