Oracle Database Administration 2019 Certified Professional — Question 39

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 19.0
The FG1 failure group goes offline due to hardware failure.
Which two statements are true? (Choose two.)

Answer options

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

Correct answer: A, C

Explanation

Option A is correct because new allocation units are mirrored in FG2 while FG1 is offline, maintaining data integrity. Option C is also correct since changes to allocation units in FG2 can still be tracked despite FG1 being down. Options B and D are incorrect as the redundancy remains as normal until FG1 is restored, and transactions do not fail simply due to FG1 going offline.