which three ways can you re-create the lost disk group and restore the data?

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?

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?

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 backedup 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 backedup 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 the data.

Explanation:

Note:
* The md_restore command allows you to restore a disk group from the metadata created by the
md_backup command.
/md_restore Command
Purpose
This command restores a disk group backup using various options that are described in this
section.
/ In the restore mode md_restore, it re-create the disk group based on the backup file with all userdefined templates with the exact configuration as the backuped disk group. There are several
options when restore the disk group
full – re-create the disk group with the exact configuration
nodg – Restores metadata in an existing disk group provided as an input parameter
newdg – Change the configuration like failure group, disk group name, etc..
* The MD_BACKUP command creates a backup file containing metadata for one or more disk
groups. By default all the mounted disk groups are included in the backup file which is saved in the
current working directory. If the name of the backup file is not specified, ASM names the file
AMBR_BACKUP_INTERMEDIATE_FILE.



Leave a Reply 11

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


ibro

ibro

The answer is CEF

Amar

Amar

ACF.

E is not right since md_restore will never restore the data, data has to be restored via RMAN only.

Dzianis

Dzianis

C D F
A has no sense, IMHO: why restore metadata for another (not lost) disk group?
D looks better, if to interpret “to restore” as “to re-create”.

charles

charles

I agree with that. Correct answer is CDF and A is wrong. Because the question is asking the way you re-create the lost disk group and A is the way to restore not the disk group but metadata for an existing disk group. If you choose A then you can get the metadata only.
———————————————————————————
The following example takes an existing disk group asmdsk1 and restores its metadata.
ASMCMD> md_restore –t nodg –g asmdsk1 –i backup_file

djeday84

djeday84

-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.
md_restore metadata do not create diskgroup

-B.Use the MKDG command to restore the disk group with the same configuration as the backedup disk group and data on the disk group.

mkdg do not recover data

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

we can change only dg name not failure group specs or attributes like compatible level

+D.Use the MKDG command to restore the disk group with the same configuration as the backedup 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.

MD RESTORE do not recover data

+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 the data.

liu

liu

C D F
A is wrong because restore metadata of ‘an existing disk group’ does not make sense