Oracle Database 12c: Installation and Administration — Question 224

You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.
In which three ways can you re-create the lost disk group and restore the data? (Choose three.)

Answer options

• A. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.
• B. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
• C. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
• D. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.
• E. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
• F. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore

Correct answer: A, C, F

Explanation

The correct options A, C, and F provide valid methods for restoring the lost disk group DG1 and its data. Option A allows restoring metadata for an existing configuration, while option C permits restoring with modified specifications, and option F enables creating a new disk group with possibly different attributes. Options B, D, and E are incorrect as they either suggest incorrect commands for restoration or do not align with the requirements for recreating the disk group.