Oracle Database 12c: RAC Administration — Question 48

Disk group DGRP1 has these attributes:
1. Normal redundancy
2. Two failure groups FG1 and FG2 with two disks each
3. Compatibility settings set to 12.1
The FG1 failure group goes offline due to hardware failure.
Which two statements are true? (Choose two.)

Answer options

• A. The redundancy is lowered until the FG1 failgroup is restored and the disk group resynchronized.
• B. New allocation units are mirrored in the FG2 failure group until FG1 is restored and the disk group resynchronized.
• C. Transactions on database objects stored in tablespaces in the DGRP1 disk group fail.
• D. New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.

Correct answer: B, C

Explanation

The correct answer B is true because new allocation units will be mirrored in FG2 to maintain redundancy until FG1 is restored. Option C is also accurate as transactions on database objects in DGRP1 will fail due to the unavailability of FG1. Options A and D are incorrect; redundancy is not lowered in this scenario, and new allocation units are mirrored, not just tracked.