Users complain that SQL statements using a particular index fail. Using DBVERIFY, you find
that two separate blocks in the index have become corrupt. The database data files for user
data and index are very large. What is the least disruptive recovery strategy available in
Oracle 10g?
A.
Without setting the individual data file offline, use RMAN with Block Media Recovery to
restore and recover only those blocks.
B.
Take the individual data file offline (not the wholetablespace), restore and recover the
data file from backup with RMAN, then set the data file online again.
C.
Take the individual data file (not the wholetablespace) offline, use RMAN with Block
Media Recovery to restore and recover only those blocks, then set the data file online again.
D.
Rebuild the index using the online option.
Explanation: