Recovery Types

Recovery depends entirely upon how the backup methodology was employed. It also depends upon what the DBA has to recover.

Recoveries can consist of:

· REDO Log Recovery—Off-line or On-line log

· ROLLBACK Segment Recovery

· Tablespace Recovery

· Table Recovery

· Recovery of the entire database

· Recovery of executables

· Recovery of control files

Each recovery may consist of one or a combination of these, depending on file placement.

Recovery generally is required only after a physical insult to the database file system. Most internal errors are corrected automatically by Oracle using the REDO and rollback logs and data buffers.

Since each site will have differing file placement and each recovery will most likely be unique, it is suggested that the Oracle7, Oracle8 or Oracle8i Server Recovery or Backup and Recovery Manual (Oracle, Corporation, 1999) be consulted for the appropriate recovery methodology that applies to the situation(s) in which the DBA may find him- or herself. Another good resource is Oracle Backup and Recovery by Rama Velpuri (Oracle Press, 1996).

It can’t be stressed enough that backup and recovery operations should be fully proceduralized and these procedures tested frequently, especially after major database or equipment changes. An untested backup and recovery plan is no plan at all.

The above text is an excerpt from Mike Ault’s Oracle DBA Made Simple by Rampant TechPress.

Oracle9i RAC

Oracle9i RAC is the first-of-its-kind reference for Real Application Clusters (RAC) and TAF technology. Learn from the experts how to quickly optimize your Oracle clustered server environment for optimal performance and flexibility. Covering all areas of RAC continuous availability and transparent application failover, this book is indispensable for any Oracle DBA who is charged with configuring and implementing a RAC clusters database.

Get your copy of Oracle9i RAC today and receive 40% off plus immediate access to the Online Code Depot!

http://www.rampant-books.com/book_2003_1_rac.htm

Oracle Consulting