nerdexam
Oracle

1Z0-060 · Question #170

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…

The correct answer is B. Use the MKDG command to restore the disk group with the same configuration as the backed-up C. Use the MD_RESTORE command to restore the disk group with the changed disk group E. Use the MKDG command to add a new disk group DG1 with the same or different specifications. When an ASM disk group is lost, it can be re-created using ASMCMD MKDG and MD_RESTORE commands, but MD_RESTORE only restores metadata and cannot restore the actual data files.

New Features for Storage

Question

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.)

Options

  • AUse the MD_RESTORE command to restore metadata for an existing disk group by passing the
  • BUse the MKDG command to restore the disk group with the same configuration as the backed-up
  • CUse the MD_RESTORE command to restore the disk group with the changed disk group
  • DUse the MD_RESTORE command to restore both the metadata and data for the failed disk
  • EUse the MKDG command to add a new disk group DG1 with the same or different specifications

How the community answered

(46 responses)
  • A
    11% (5)
  • B
    65% (30)
  • D
    24% (11)

Why each option

When an ASM disk group is lost, it can be re-created using ASMCMD MKDG and MD_RESTORE commands, but MD_RESTORE only restores metadata and cannot restore the actual data files.

AUse the MD_RESTORE command to restore metadata for an existing disk group by passing the

MD_RESTORE cannot restore metadata for an existing disk group in this context because the disk group was completely lost - there is no existing disk group to pass metadata into.

BUse the MKDG command to restore the disk group with the same configuration as the backed-upCorrect

The ASMCMD MKDG command can re-create a disk group using the exact configuration captured by a prior MD_BACKUP, reconstructing the disk group structure before data is restored via RMAN.

CUse the MD_RESTORE command to restore the disk group with the changed disk groupCorrect

MD_RESTORE supports a mode that restores a disk group with a modified configuration, which is useful when hardware changes prevent restoring with the original disk group specifications.

DUse the MD_RESTORE command to restore both the metadata and data for the failed disk

MD_RESTORE only restores ASM metadata such as disk group structure and file mappings; it does not restore actual data files, which must be recovered separately using RMAN.

EUse the MKDG command to add a new disk group DG1 with the same or different specificationsCorrect

MKDG can create a new disk group named DG1 with the same or different specifications than the original, providing flexibility in the re-creation process before RMAN data recovery begins.

Concept tested: ASM disk group recovery using MD_RESTORE and MKDG

Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/ostmg/asmcmd-commands-for-asm-metadata.html

Topics

#ASM disk group recovery#MD_RESTORE#MD_BACKUP#MKDG command

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-060 Practice