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.
KeywordsEurope Expense Lost
Unable to display preview. Download preview PDF.