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.
KeywordsData File Data Block Incomplete Recovery Data Dictionary Target Database
Unable to display preview. Download preview PDF.