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 ...
Get OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide 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.
