Upgrade to Oracle Database 12c — Question 17

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 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 MD_RESTORE command to restore both the metadata and data for the failed disk group.
• E. 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: B, C, E

Explanation

The correct options B, C, and E outline valid methods to recreate the lost ASM disk group and restore its data. Option B allows for restoring the disk group with the same configuration, while option C allows for customization of disk group specifications during restoration. Option E permits the creation of a new disk group with potentially different specifications, which is also a feasible recovery option. Options A and D are incorrect because they either do not provide a method to recreate the disk group itself or do not align with the requirements for restoring data effectively.