O'Reilly logo

OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required