Show Menu

General Steps for Database Object Recovery Cheat Sheet (DRAFT) by [deleted]

This is a draft cheat sheet. It is a work in progress and is not finished yet.


At the very basic level, every database recovery will involve most of these seven steps. However, depending on the situation and the type of recovery requested, certain steps might be eliminated or changed signif­ica­ntly.

At a high level, the following steps are common to most database recove­ries.

1. Identify the failure

The detection of an outage is usually simple: either the database is not responding to the applic­ation or the DBMS has displayed some type of error message. Some problems are more insidious, though, such as a corrupt control file. This type of problem take more skill to identify.

2. Analyze the situation

The DBA must analyze the error to determine the cause, type, and scope of the failure. Based on the results of this analysis, the DBA will choose a recovery method. This is usually the most time-c­ons­uming recovery task.

4. Determine what needs to be recovered.

The DBA must determine which database objects (and perhaps other components such as logs) are failing and prepare a recovery script that is approp­riate for each component. This task can also consume a signif­icant amount of time, especially for larger systems.

4. Identify depend­encies between Database Objects

Identify depend­encies between the database objects to be recovered. The failure of one database object can impact other database objects (e.g., indexes and refere­ntially related tables). Loss of data or recovery to a prior point-­in-time will most likely affect related database objects.

5.Locate the required image copy backup(s)

The closer the image copy backup is to the recovery point in time, the shorter amount of time it will take to recover. Keep in mind other factors such as the time it takes to find tapes in the library and the possib­ility of the tape being located at an off-site location.

Database Recovery

6. Restore the image copy backup(s)

Restor­ation is accomp­lished using the database recovery utility or file system recovery command of choice

7. Roll forward through the database log(s)

To recover to current or to a point in time after the image copy backup was taken, the database logs will need to be processed.