Database Recovery

  • Sam R. Alapati


Database recovery is the topic many DBAs dread most. A database could be unavailable for use for a number of reasons, including a system crash, a network failure, a media failure, or a natural disaster. If the downtime is due to something like a power failure, Oracle will recover itself—there’s no need for you to do anything special. You’ll see how you can set a bound on the time taken for crash recovery using Oracle9i’s new features. In cases where a disk becomes nonfunctional, for example, you have to perform media recovery. This involves two steps. First, you restore the database from backups, and second, you bring the database up-to-date with the help of archived redo logs. The keys to a successful recovery, of course, are solidly tested backups and regular recovery drills using those backups.


Data File Data Block Incomplete Recovery Data Dictionary Target Database 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Sam R. Alapati 2003

Authors and Affiliations

  • Sam R. Alapati

There are no affiliations available

Personalised recommendations