Exam 1z0-062 topic 1 question 146 discussion

Actual exam question from Oracle's 1z0-062

Question #: 146
Topic #: 1

A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:

There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?

A. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
B. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
C. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
D. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
E. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.

Show Suggested Answer

Suggested Answer: D 🗳️

by Ray520 at April 14, 2022, 6:26 a.m.

Comments

Submit Cancel

Ray520

3 years, 2 months ago

A. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall. ---Not true as NORMAL REDUNDANCY allows 2 way mirroring and diskgroup stays available even if one diskgroup fails. C. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.---Data mirrored is already available, rebalancing only evenly distributes file extents and space usage across all disks in the diskgroup. E. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed. ----Not true (refer A)

upvoted 1 times

...

Ray520

3 years, 2 months ago

Disk loss in ASM can result from a number of reasons. To allow for sufﬁcient time to recover from disk failures that do not involve the actual failure of a disk, ASM provides the ASM fast disk resync feature. By default, when a disk in an ASM disk group fails the disk will be taken ofﬂine automatically. The disk will be dropped some 3.6 hours later. As a result, you have only 3.6 hours by default to respond to a disk outage. If you correct the problem and the physical disk media is not corrupted, then ASM fast disk resync will quickly re-synchronize the disk when it comes back online, correcting the problem very quickly. We an change the amount of time that Oracle will wait to automatically drop the disk by setting the disk_repair_time attribute.

upvoted 1 times

...