Oracle Database 12c: RAC Administration — Question 61

Examine this command:
SQL> CREATE DISKROUP data NORMAL REDANDUNCY:

FAILGROUP fgrpl DISK -
/dev/disk1 NAME disk1,
/dev/disk2 NAME disk2,
/dev/disk3 NAME disk3,

FAILGROUP fgrpl2 DISK -
/dev/disk4 NAME disk4,
/dev/disk5 NAME disk5,
/dev/disk6 NAME disk6,

FAILGROUP fgrpl3 DISK -
/dev/disk7 NAME disk7,
/dev/disk8 NAME disk8,
/dev/disk9 NAME disk9,
ATTRIBUTE au_size=4M,
compatible.asm = 11.2,
compatible.rdbms = 11.2,
compatible.advm = 11.2,
content_type = recovery;
Which two statements a true about this disk group, created using Grid Infrastructure 12.1?

Answer options

• A. Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.
• B. File created in this disk group always has two copies for each allocation unit: one primary and one secondary.
• C. It can contain ASM Dynamic Volume Manager (ADVM) volumes.
• D. Any database instance with the COMPATIBLE parameter set to 11.2 or higher can access it.
• E. The ASM compatible attributes can be changed to 11.1 for this disk group.

Correct answer: C, D

Explanation

Option C is correct because the disk group is compatible with ASM Dynamic Volume Manager (ADVM) volumes, as indicated by the compatible.advm attribute. Option D is also correct since the COMPATIBLE parameter set to 11.2 or higher allows database instances to access this disk group. The other options are incorrect; A is false as the disks are not mirrors, B is inaccurate as the redundancy type does not imply two copies for each allocation unit, and E is incorrect because the compatible attributes should not be downgraded.