You lost an ASM disk group DAT

You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM
disk group DAT

You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM
disk group DAT

A.
You have RMAN backup of data as well as ASM metadata backup. You want to re-create
the missing disk group by using the ASMCMD md_restore command.
Which of these methods would you use to achieve this? (Choose all that apply.)
Restore the disk group with the exact configuration as the backed-up disk group, using
the same disk group name, same set of disks, failure group configurations, and data on the
disk group.

A.
You have RMAN backup of data as well as ASM metadata backup. You want to re-create
the missing disk group by using the ASMCMD md_restore command.
Which of these methods would you use to achieve this? (Choose all that apply.)
Restore the disk group with the exact configuration as the backed-up disk group, using
the same disk group name, same set of disks, failure group configurations, and data on the
disk group.

B.
Restore the disk group with the exact configuration as the backed-up disk group, using
the same disk group name, same set of disks, and failure group configurations.

C.
Restore the disk group with changed disk group specification, failure group specification,
disk group name, and other disk attributes.

D.
Restore metadata in an existing disk group by passing the existing disk group name as an
input parameter.

Explanation:
Purpose
The md_restore command restores disk groups from a metadata backup file.
Syntax and Description
md_restore backup_file [–silent]
[–full|–nodg|–newdg -o ‘old_diskgroup:new_diskgroup [,…]’]
[-S sql_script_file] [-G ‘diskgroup [,diskgroup…]’]
backup_file
Reads the metadata information from backup_file.
–silent
Ignore errors. Typically, if md_restore encounters an error, it stops. Specifying this flag
ignores any errors.
–full
Specifies to create a disk group and restore metadata.
–nodg
Specifies to restore metadata only.
–newdg -o old_diskgroup:new_diskgroup]
Specifies to create a disk group with a different name when restoring metadata. The -o
option is required with

–newdg.
-S sql_script_file
Write SQL commands to the specified SQL script file instead of executing the commands.
-G diskgroup
Select the disk groups to be restored. If no disk groups are defined, then all disk groups are
restored.



Leave a Reply 4

Your email address will not be published. Required fields are marked *


MJ

MJ

This question is completely hosed.

oracle

oracle

You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA.
You have RMAN backup of data as well as ASM metadata backup.
You want to re-create the missing disk group by using the ASMCMD md_restore command. Which of these
methods would you use to achieve this? (Choose all that apply.)
A. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk
group name, same set of disks, failure group configurations, and data on the disk group.
B. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk
group name, same set of disks, and failure group configurations.
C. Restore the disk group with changed disk group specification, failure group specification, disk group name,
and other disk attributes.
D. Restore metadata in an existing disk group by passing the existing disk group name as an input parameter.
Answer: BCD

Eamon

Eamon

@oracle
Thank you very much !!!!!!!

Eamon

Eamon

The best answer is D.
Answer B could also be used if you have the script (including all later modifications) to recreate the disk group.
Answer C I am sure is also possible if your disk setup has changed.