11.3. Summary
Understanding the types of failures that can occur in the database is critical to deciding the type of action required to recover from the failure. We reviewed the six types of failures in a database: statement, user process, network, user errors, instance, and media.
In addition to knowing how an instance fails, you also need to know what is required to keep a database up and running: all control files, at least one member of each redo log group, and all datafiles for the SYSTEM and UNDO tablespaces. For instance failures, you want to know how long the database will take to recover. Starting with Oracle9i, you can use the initialization parameter FAST_START_MTTR_TARGET to specify the target recovery time, making it easier to meet ...
Get OCA: Oracle 10g™ Administration I: Study 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.
