What happens if the CONTROLLER1 failure group becomes u…

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 1

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