What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?

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

Explanation:
CREATE DISKGROUP NORMAL REDUNDANCY
* For Oracle ASM to mirror files, specify the redundancy level as NORMAL REDUNDANCY (2-way
mirroring by default for most file types) or HIGH REDUNDANCY (3-way mirroring for all files).



Leave a Reply 4

Your email address will not be published. Required fields are marked *


cg

cg

Per JE:
Normal redundancy ASM provides two-way mirroring. By default all files are mirrored so that there are two copies of every data extent . A loss of one ASM disk is tolerated.

Thus, B would be correct

Diego

Diego

D
does not sense to mirror in the same filegroup