Database Recovery

  • Sam R. Alapati

Abstract

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.

Keywords

Europe Expense Lost 

Preview

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