Understanding instance recovery
Not all types of recovery require the intervention of a DBA. Instance recovery occurs when some type of instance-terminating event occurs, such as a hard crash of the host server, a shutdown abort, or certain Oracle errors. When an instance terminates, the database is in an inconsistent state. The next time the database is started, the SMON process uses the contents of the redo logs to reconstruct the state of the database before the crash and rolls back uncommitted transactions. All database changes after the last recorded checkpoint are applied to datafiles. Instance recovery is completely automatic and doesn't require the intervention of a DBA. We can, however, monitor it when it occurs, from the alert log, as ...
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.
