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…

Question

Options

• ATransactions and queries accessing database objects contained in any tablespace stored in DGROUP1
• BMirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the
• CThe data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing
• DASM does not mirror any data until the controller failure group is brought back online, and newly allocated
• ETransactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but

• A
  11% (4)
• B
  78% (29)
• C
  3% (1)
• D
  3% (1)
• E
  5% (2)

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

No community discussion yet for this question.