• OCP-1Z0-053-V12.02-543题


    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.


    V$ASM_DISKGROUP

    Describes a disk group (number, name, size related info, state, and redundancy type).

    This view performs disk discovery every time it is queried.

  • 相关阅读:
    主成分分析法(PCA)答疑
    搜索引擎的高级用法
    Makefile 编写实例
    GCC常用命令
    一个进程最多能开多少个线程?
    归并排序
    选择排序(数组、链表)
    求连续子数组的最大和
    生产者-消费者问题(1)
    基于cmake编译安装MySQL-5.5
  • 原文地址:https://www.cnblogs.com/hzcya1995/p/13316788.html
Copyright © 2020-2023  润新知