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.
Rebuild the index using the online option
B.
Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again
C.
Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks.
D.
Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again
Explanation:
If a small number of blocks within one or more datafiles are corrupt, you can perform bl ock media recovery instead of restoring the datafiles from backup and performing complete media recovery of those files. The Recovery Manager BLOCKRECOVER command can be used to restore and recover specified data blocks while the database is open and the corrupted datafile is online.
REF.: Oracle(r) 10g Backup and Recovery Guide, 2-5