Testing for Availability - Expert Oracle RAC Performance Diagnostics and Tuning - page 83

Step 3
After the backup operations are tested, the next step to test the recovery operation. Similar to the backup operation,
the recovery of each of the components will have to be completed and recorded. In addition to the recovery of these
components, other recovery scenarios—for example, datafile corruption, OCR corruption, and so forth—should also
be tested. Table 3-9 lists the various recovery components and other recovery scenarios.

Table 3-9. RAP Phase IV Recovery Components

Recovery Components Operation Recovery Time

Software

Grid Infrastructure Binaries
RDBMS Binaries

ASM

ASM SPFile
Metadata Recovery

OCR OCR Corruption recovery

OLR OLR Corruption recovery

Database

Complete Recovery
Incomplete Recovery—Tablespace
Incomplete Recovery—Block Corruption
Incomplete Recovery—Datafile
Database SPFile Recovery
Control File Recovery

Note: RDBMS = relational database management system; ASM = automatic storage management;
SPFile = server parameter file; OCR = Oracle Cluster Registry; OLR = Oracle Local Registry.

In addition to the time taken to restore of the various components, it's also important to record the scalability
of these restore operations. How many parallel slaves were used for the restore operation? How many RAC instances
participated in the recovery operation? These and others should be tested and results recorded.

■ Note tuning the backup and recovery operations are discussed in Chapter 10.