Oracle - 11G - 题库337 - 图文(17)

database is using that ASM instance. Use the shutdown abort command to force the ASM

instance to shut down. This will cause all other Oracle databases attached to the ASM instance to be shut down with the equivalent of a shutdown abort command. 如果你做一个正 常关闭ASM实例，如果任何Oracle数据库使用该ASM实例，将返回一个错误。使用shutdown abort命令强制关闭ASM实例。这将导致所有其他Oracle数据库连接到ASM实例被关闭，相当 于关机中止命令。

QUESTION NO: 131

它传递什么命令给依赖于ASM实例的磁盘组的所有数据库实例？ A. TRANSACTIONAL B. IMMEDIATE C. ABORT D. NORMAL

E．None of the above

Answer: E

SQL> shutdown normal;

ORA-15097: cannot SHUTDOWN ASM instance with connected client (process 18597) SQL> shutdown immediate;

ORA-15097: cannot SHUTDOWN ASM instance with connected client (process 18597) If you do a normal shutdown of the ASM instance, an error will be returned if any Oracle database is using that ASM instance. Use the shutdown abort command to force the ASM instance to shut down. This will cause all other Oracle databases attached to the ASM

instance to be shut down with the equivalent of a shutdown abort command. 如果你做一个正 常关闭ASM实例，如果任何Oracle数据库使用该ASM实例，将返回一个错误。使用shutdown abort命令强制关闭ASM实例。这将导致所有其他Oracle数据库连接到ASM实例被关闭，相当 于关机中止命令。

QUESTION NO: 131

When starting up your ASM instance, you receive the following error: ASM实例启动时，您会收到以下错 误：

SQL> startup pfile=?/dbs/init+ASM.ora ASM instance started+

Total System Global Area 104611840 bytes Fixed Size 1298220 bytes Variable Size 78147796 bytes ASM Cache 25165824 bytes

ORA-15032: not all alterations performed

ORA-15063: ASM discovered an insufficient number of disks for disk group“DGROUP3” ORA-15063: ASM discovered an insufficient number of disks for disk group“DGROUP2” ORA-15063: ASM discovered an insufficient number of disks for disk group“DGROUP1” In trying to determine the cause of the problem, you issue this query: SQL> show parameter asm NAME TYPE VALUE

------------------------------------ ----------- -------------------------_ asm_allow_only_raw_disks boolean FALSE asm_diskgroups string DGROUP1, DGROUP2, DGROUP3 asm_diskstring string asm_power_limit integer 1

asm_preferred_read_failure_groups string

What is the cause of the error? 错误的原因是什么？

A. The ASM_DISKGROUPS parameter is configured for three disk groups: DGROUP1, DGROUP2, and

DGROUP3. The underlying disks for these disk groups have apparently been lost.

B. The format of the ASM_DISKGROUPS parameter is incorrect. It should reference the disk group numbers, not the names of the disk groups

C. The ASM_POWER_LIMIT parameter is incorrectly set to 1. It should be set to the number of disk groups being attached to the ASM instance.

D. The ASM_DISKSTRING parameter is not set; therefore disk discovery is not possible. ASM磁盘串参数没有设置，因此磁盘是不可能被发现的。 E. There is insufficient information to solve this problem.

D. The ASM_DISKSTRING parameter is not set correctly. When the ASM instance is started,it will use the ASM_DISKSTRING to do ASM disk discovery. Correct the ASM_DISKSTRING parameter, and restart the instance to correct the problem.

Answer: D

QUESTION NO: 132

As DBA for the Rebel Alliance you have decided that you need to facilitate some redundancy in your database. Using ASM, you want to create a disk group that will provide for the greatest amount of redundancy for your ASM data (you do not have advanced SAN mirroring technology available to you, unfortunately). Which of the following commands would create a disk group that would offer the maximum

in data redundancy? 作为反叛联盟的DBA，你已经决定需要在你的数据库中提供一些冗余便利。使用

ASM，您想创建一个磁盘组，将提供最大的冗余量ASM数据（不幸的是，你没有先进的SAN镜像技术提供 给你）。以下哪一个命令将创建一个磁盘组，将提供最大的数据冗余？ A. CREATE DISKGROUP dg_alliance1 NORMAL REDUNDANCY

failgroup diskcontrol1 DISK ?c:\\oracle\\asm_disk\\_file_disk3‘ NAME file_ diska1 failgroup diskcontrol2 DISK

?c:\\oracle\\asm_disk\\_file_disk4‘ NAME file_diskb1;

B. CREATE DISKGROUP dg_alliance1 EXTERNAL REDUNDANCY failgroup diskcontrol1 DISK 'c:\\oracle\\asm_disk\\_file_disk3' NAME file_ diska1;

C. CREATE DISKGROUP dg_alliance1 HIGH REDUNDANCY

failgroup diskcontrol1 DISK 'c:\\oracle\\asm_disk\\_file_disk1' NAME file_disk1 failgroup diskcontrol2 DISK 'c:\\oracle\\asm_disk\\_file_disk2' NAME file_disk2 failgroup diskcontrol2 DISK 'c:\\oracle\\asm_disk\\_file_disk3' NAME file_disk3; C.创建DG联盟1磁盘组高冗余

故障组的磁盘控制1磁盘“C：\\ ORACLE \\ ASM_DISK\\_file_disk1”命名文件_磁盘1 故障组的磁盘控制2磁盘“C：\\ ORACLE \\ ASM_DISK\\_file_disk2”命名文件_磁盘2 故障组的磁盘控制2磁盘“C：\\ ORACLE \\ ASM_DISK\\_file_disk3”命名文件_磁盘3; D. CREATE DISKGROUP dg_alliance1 MAXIMUM REDUNDANCY failgroup diskcontrol1 DISK 'c:\\oracle\\asm_disk\\_file_disk1' NAME file_ disk1

failgroup diskcontrol2 DISK 'c:\\oracle\\asm_disk\\_file_disk2' NAME file_ disk2

failgroup diskcontrol2 DISK 'c:\\oracle\\asm_disk\\_file_disk3' NAME file_ disk3

failgroup diskcontrol2 DISK 'c:\\oracle\\asm_disk\\_file_disk4' NAME file_ disk4;

E. None of the above Answer: C

QUESTION NO: 133

You want to migrate your database to ASM, so you‘ve done a clean shutdown, made a closed backup of the entire 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? 你想将数据库迁

移到ASM，所以你做了一个干净关机，一个完全数据库的封闭的备份，指出控制文件 …… 此处隐藏：7155字，全部文档内容请下载后查看。喜欢就下载吧 ……