543.As the DBA, you run the following query on your ASM instance.
What is the implication of the results of the query? (Choose two.)
SQL> select group_number, name, state from v$ASM_DISKGROUP;
GROUP_NUMBER NAME STATE
0 DGROUP1 DISMOUNTED
2 DGROUP2 MOUNTED
3 DGROUP3 MOUNTED
A. The DGROUP1 disk group was unmounted by another DBA.
B. A datafile has been lost, causing the ASM disk group DGROUP1 to go into the DISMOUNTED state
C. One of the redundant disks (DGROUP1) has been lost in a disk group.
D. This query has no meaning in an ASM instance.
E. A disk associated with a disk group was discovered after the ASM instance initially opened.
Answer: AE
答案解析：
参考：http://blog.csdn.net/rlhua/article/details/12972983
sys@TEST0924> select group_number, name, state from v$ASM_DISKGROUP;
GROUP_NUMBER NAME STATE
------------ ------------------------------ -----------
1 DATA MOUNTED
2 RECOVERY MOUNTED
V$ASM_DISKGROUP displays one row for every ASM disk group discovered by the ASM instance on the node.
|
|
Describes a disk group (number, name, size related info, state, and redundancy type). This view performs disk discovery every time it is queried. |