ocp-143

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实例打开之后。

---