Upgrade to Oracle Database 12c — Question 8

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?

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: C, D, F

Explanation

The correct answers C, D, and F outline valid methods to recreate the disk group and restore data. Option C allows for modifications in specifications while restoring, which can be necessary in certain situations. Option D retains the original configuration, ensuring a straightforward recovery. Option F offers flexibility in setting up a new disk group if the original specifications need adjustment. Options A, B, and E are incorrect as they either do not address the recreation of the disk group correctly or do not comply with the necessary procedures.