Datasheet

48 Chapter 1

Using Oracle ASM
In trying to determine the cause of the problem, you issue this query:
SQL> show parameter asm
NAME TYPE VALUE
------------------------------------ ----------- -------------------------_
asm_allow_only_raw_disks boolean FALSE
asm_diskgroups string DGROUP1, DGROUP2, DGROUP3
asm_diskstring string
asm_power_limit integer 1
asm_preferred_read_failure_groups string
What is the cause of the error?
A. The ASM_DISKGROUPS parameter is configured for three disk groups: DGROUP1,
DGROUP2, and DGROUP3. The underlying disks for these disk groups have apparently
been lost.
B The format of the ASM_DISKGROUPS parameter is incorrect. It should reference the disk
group numbers, not the names of the disk groups.
C. The ASM_POWER_LIMIT parameter is incorrectly set to 1. It should be set to the number
of disk groups being attached to the ASM instance.
D. The ASM_DISKSTRING parameter is not set; therefore disk discovery is not possible.
E. There is insufficient information to solve this problem.
9. As DBA for the Rebel Alliance you have decided that you need to facilitate some redun-
dancy 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;
95134c01.indd 48 1/28/09 9:43:47 AM