多項選擇題

As the DBA， you run the following query on your ASM instance. What is the implication of the results of the query？（）
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.

題目列表

你可能感興趣的試題

單項選擇題

You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don’t want to have to rebuild the disks from scratch. 
What do you do？（）  

A. Take the whole disk group offline and wait for the controller card to be installed. Once it’s installed，bring the disk group online again.
B. Change the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that you want to read from the non-failed disk. Once the disk controller is replaced，reset the parameter to  its original value.
C. You have no choice but to rebuild the disk. Drop the disk from the disk group and wait for the controller to be replaced. Once the controller is replaced， add the disk back into the disk group and allow ASM to rebuild it.
D. If you are using any setting other than REDUNDANCY EXTERNAL for your disk group，you will have to recover any data on that disk from a backup. The database will be unavailable until you can  correct the problem and perform recovery.
E. Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.
微信掃碼免費搜題