随笔分类 -  disk group

摘要:You are managing an ASM instance. You previously issued the following statements:ALTER DISKGROUP dg1 DROP DISK disk2;ALTER DISKGROUP dg1 DROP DISK dis 阅读全文
posted @ 2017-11-16 15:02 巴啦啦大魔王 阅读(159) 评论(0) 推荐(0)
摘要:The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration.You executed the following command to startup the Automati 阅读全文
posted @ 2017-11-16 14:09 巴啦啦大魔王 阅读(228) 评论(0) 推荐(0)
摘要:Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)A. ALTER DISKGROUP misc MOUNT;B. ALTER DISKGROUP misc DR 阅读全文
posted @ 2017-11-16 13:32 巴啦啦大魔王 阅读(192) 评论(0) 推荐(0)
摘要:Examine the following ALTER command:SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;What is the purpose of the command?A. It cancels all pending disk drops 阅读全文
posted @ 2017-11-16 13:25 巴啦啦大魔王 阅读(116) 评论(0) 推荐(0)
摘要:Examine the CREATE DISKGROUP command used to create a disk group:SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCYDISK 'ORCL: FRA3' NAME misc1, 'ORCL: FR 阅读全文
posted @ 2017-11-16 11:41 巴啦啦大魔王 阅读(113) 评论(0) 推荐(0)
摘要:View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management (ASM).Why does the 阅读全文
posted @ 2017-11-16 11:26 巴啦啦大魔王 阅读(139) 评论(0) 推荐(0)
摘要:A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:SQL> CREATE DISKGROUP 阅读全文
posted @ 2017-11-15 17:03 巴啦啦大魔王 阅读(116) 评论(0) 推荐(0)
摘要:View the exhibit and examine the output. Which statement can be an inference from the output?Exhibit: A. The FRA disk group has an asynchronous I/O bo 阅读全文
posted @ 2017-11-15 15:10 巴啦啦大魔王 阅读(214) 评论(0) 推荐(0)
摘要:View Exhibit1 to examine the DATA disk group when all the disks are online. Why is the rebalancing not performed and the content of the disk group not 阅读全文
posted @ 2017-11-15 14:07 巴啦啦大魔王 阅读(131) 评论(0) 推荐(0)
摘要: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_numbe 阅读全文
posted @ 2017-11-08 13:49 巴啦啦大魔王 阅读(138) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-08 13:41 巴啦啦大魔王 阅读(85) 评论(0) 推荐(0)
摘要:If you use ALTER DISKGROUP ... ADD DISK and specify a wildcard for the discovery string, whathappens to disks that are already a part of the same or a 阅读全文
posted @ 2017-11-08 13:35 巴啦啦大魔王 阅读(131) 评论(0) 推荐(0)
摘要:Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation?A. ADD DIRECTORYB. DROP DISKC. RESI 阅读全文
posted @ 2017-11-08 13:31 巴啦啦大魔王 阅读(193) 评论(0) 推荐(0)
摘要:How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it hasalready completed?A. Issue the ALTER DISKGROUP ... ADD DISK comma 阅读全文
posted @ 2017-11-08 13:24 巴啦啦大魔王 阅读(135) 评论(0) 推荐(0)
摘要: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. Datafile 阅读全文
posted @ 2017-11-08 13:15 巴啦啦大魔王 阅读(94) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-07 18:06 巴啦啦大魔王 阅读(141) 评论(0) 推荐(0)
摘要:Which background process coordinates the rebalance activity for disk groups?A. ORBnB. OSMBC. RBALD. ASMn RBAL coordinates rebalance activity for a dis 阅读全文
posted @ 2017-11-07 17:41 巴啦啦大魔王 阅读(147) 评论(0) 推荐(0)
摘要: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 comm 阅读全文
posted @ 2017-11-07 17:26 巴啦啦大魔王 阅读(116) 评论(0) 推荐(0)
摘要:As DBA for the Rebel Alliance you have decided that you need to facilitate some redundancy in yourdatabase. Using ASM, you want to create a disk group 阅读全文
posted @ 2017-11-07 13:33 巴啦啦大魔王 阅读(126) 评论(0) 推荐(0)
摘要:Which initialization parameter in an ASM instance specifies the disk groups to be automaticallymounted at instance startup?A. ASM_DISKMOUNTB. ASM_DISK 阅读全文
posted @ 2017-11-07 12:23 巴啦啦大魔王 阅读(116) 评论(0) 推荐(0)