As DBA for the Rebel Alliance you have decided that you need to facilitate some redundancy in
your database. Using ASM, you want to create a disk group that will provide for the greatest
amount of redundancy for your ASM data (you do not have advanced SAN mirroring technology
available to you, unfortunately). Which of the following commands would create a disk group that
would offer the maximum in data redundancy?
A.
CREATE DISKGROUP dg_alliance1 NORMAL REDUNDANCY failgroup diskcontrol1 DISK
�c:\oracle\asm_disk\_file_disk3� NAME file_ diska1 failgroup diskcontrol2 DISK
�c:\oracle\asm_disk\_file_disk4� NAME file_
diskb1;
B.
CREATE DISKGROUP dg_alliance1 EXTERNAL REDUNDANCY
failgroup diskcontrol1 DISK ‘c:\oracle\asm_disk\_file_disk3’ NAME file_
diska1;
C.
CREATE DISKGROUP dg_alliance1
HIGH REDUNDANCY
failgroup diskcontrol1 DISK ‘c:\oracle\asm_disk\_file_disk1’ NAME file_
disk1
failgroup diskcontrol2 DISK ‘c:\oracle\asm_disk\_file_disk2’ NAME file_
disk2
failgroup diskcontrol2 DISK ‘c:\oracle\asm_disk\_file_disk3’ NAME file_
disk3;
D.
CREATE DISKGROUP dg_alliance1
MAXIMUM REDUNDANCY
failgroup diskcontrol1 DISK ‘c:\oracle\asm_disk\_file_disk1’ NAME file_
disk1
failgroup diskcontrol2 DISK ‘c:\oracle\asm_disk\_file_disk2’ NAME file_
disk2
failgroup diskcontrol2 DISK ‘c:\oracle\asm_disk\_file_disk3’ NAME file_
disk3
failgroup diskcontrol2 DISK ‘c:\oracle\asm_disk\_file_disk4’ NAME file_
disk4;
E.
None of the above