Exam 1z0-062 topic 1 question 155 discussion

Actual exam question from Oracle's 1z0-062

Question #: 155
Topic #: 1

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

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

Show Suggested Answer

Suggested Answer: ACF 🗳️
AC (not E):
The md_restore command allows you to restore a disk group from the metadata created by the md_backup command. md_restore cant restore data, only metadata.

by Ray520 at April 18, 2022, 6:59 a.m.

Comments

Submit Cancel

Ray520

3 years, 2 months ago

MKDG command Creates a disk group based on an XML configuration file hat specifies the name of the disk group, redundancy, attributes, and paths of the disks that form the disk group. none of the given MGDG options are correct.

upvoted 1 times

...

Ray520

3 years, 2 months ago

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/ostmg/asmcmd-diskgroup-commands.html#GUID-241C6676-FA7C-4505-ABA0-BD45657CF4AA md_restore restores Oracle ACFS metadata information. To run the metadata restore for Oracle ACFS file systems, a script is created. This script must be run as root to format file systems. Metadata for the contained Oracle ADVM volumes, such as stripe size and redundancy, is restored. Oracle ACFS file system configuration metadata, such as compression and resize attributes, block size, and created snapshots, is also restored. Oracle ACFS file System data and ACFS CRS Resource information is not restored. When restoring Oracle ACFS encryption or security, file system extended attributes (xattrs) must be restored with the user data. If using the --silent option while specifying a single disk group, and there is a dependency due to Oracle ADVM metadata or Oracle ACFS accelerators on another disk group, that dependency is dropped, and you must manually recreate that dependency later.

upvoted 1 times

...