QUESTION NO: 143
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: A,E
作为一个DBA,你运行以下的ASM实例查询。查询结果的含义是什么?
SQL> select group_number, name, state from v$ASM_DISKGROUP;
GROUP_NUMBER NAME STATE
0 DGROUP1 DISMOUNTED
2 DGROUP2 MOUNTED
3 DGROUP3 MOUNTED
SQL>从ASM磁盘组选择组号,姓名,状态
0 磁盘组1卸载
2 磁盘组2挂载
3 磁盘组3挂载
A.由另一DBA卸载DGROUP1磁盘组
E.ASM实例最初打开后发现一个关联磁盘组的磁盘。
显然,出于某种原因, 当ASM实例
启动时磁盘组1未挂载或者在 ASM实例启动后磁盘丢失然后又出现了(也许是硬件故障)。 ASM会发现新
的磁盘,即使在ASM实例打开之后。