As&ensp;the&ensp;DBA，&ensp;you&ensp;ru...

多项选择题 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.

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题 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.

点击查看答案

2.单项选择题If you use ALTER DISKGROUP ... ADD DISK and specify a wildcard for the discovery string， what happens to disks that are already a part of the same or another disk group？（）

A. The command fails unless you specify the FORCE option.
B. The command fails unless you specify the REUSE option.
C. The command must be reissued with a more specific discovery string.
D. The other disks， already part of the disk group，are ignored.

点击查看答案

3.单项选择题Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation？（）

A. ADD DIRECTORY
B. DROP DISK
C. RESIZE DISK
D. REBALANCE
E. ADD FAILGROUP

点击查看答案

4.单项选择题How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has already completed？（）

A. Issue the ALTER DISKGROUP ... ADD DISK command.
B. Issue the ALTER DISKGROUP ... UNDROP DISKS command.P.... DROP DISK CANCEL command.
C. Issue the ALTER DISKGROU
D. Retrieve the disk from the Recycle Bin after the operation completes.

点击查看答案

5.单项选择题Which type of database file is spread across all disks in a disk group？（）

A. All types of files are spread across all disks in the disk group.
B. Datafiles
C. Redo log files
D. Archived redo log files
E. Control files

点击查看答案

6.单项选择题 On the development database rac0， there are six raw devices： /dev/raw/raw1 through /dev/raw/raw6. /dev/raw/raw1 and /dev/raw/raw2 are 8GB each， and the rest are 6GB each. An existing disk group +DATA1， of NORMAL REDUNDANCY， uses /dev/raw/raw1 and /dev/raw/raw2.
Which series of the following commands will drop one of the failure groups for +DATA1， create a new disk group +DATA2 using two of the remaining four raw devices， and then cancel the drop operation from +DATA1？（）

A.A
B.B
C.C
D.D

点击查看答案

7.单项选择题Which background process coordinates the rebalance activity for disk groups？（）

A. ORBn
B. OSMB
C. RBAL
D. ASMn

点击查看答案

8.单项选择题 To reference existing ASM files， you need to use a fully qualified ASM filename. Your development database has a disk group named DG2A， the database name is DEV19， and the ASM file that you want to reference is a datafile for the USERS02 tablespace.
Which of the following is a valid ASM filename for this ASM file？（）

A. dev19/+DG2A/datafile/users02.701.2
B. +DG2A/dev19/datafile/users02.701.2
C. +DG2A/dev19/users02/datafile.701.2
D. +DG2A·701.2
E. +DG2A/datafile/dev19.users.02.701.2

点击查看答案

9.单项选择题How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yet completed？（）

A. Issue the ALTER DISKGROUP ... ADD DISK command.
B. Issue the ALTER DISKGROUP ... UNDROP DISKS command.
C. Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.
D. Retrieve the disk from the Recycle Bin after the operation completes.

点击查看答案

10.单项选择题 You want to migrate your database to ASM， so you have done a clean shutdown， made a closed backup of the entire You wa database， noted the location of your control files and online redo log files， and changed your spfile to use OMF. The last step is to run an RMAN script to do the conversion.
Using the following steps，what is the correct order in which the following RMAN commands should be executed？（）
1. STARTUP NOMOUNT
2. ALTER DATABASE OPEN RESETLOGS
3. SQL "ALTER DATABASE RENAME ，，logfile1 path TO ，，+dgrp4 ，，" # plus all other logfiles
4. SWITCH DATABASE TO COPY
5. BACKUP AS COPY DATABASE FORMAT ，，+dgrp4
6. ALTER DATABASE MOUNT
7. RESTORE CONTROLFILE FROM ，，controlfile_location

A. 2， 5， 3， 1， 7， 6， 4
B. 1， 7， 6， 5， 4， 3， 2
C. 5， 1， 2， 7， 4， 6， 3
D. 7， 3， 1， 5， 6， 2， 4

点击查看答案