随笔分类 - 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
阅读全文
摘要: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
阅读全文
摘要:Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)A. ALTER DISKGROUP misc MOUNT;B. ALTER DISKGROUP misc DR
阅读全文
摘要: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
阅读全文
摘要:Examine the CREATE DISKGROUP command used to create a disk group:SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCYDISK 'ORCL: FRA3' NAME misc1, 'ORCL: FR
阅读全文
摘要: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
阅读全文
摘要:A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:SQL> CREATE DISKGROUP
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:Which background process coordinates the rebalance activity for disk groups?A. ORBnB. OSMBC. RBALD. ASMn RBAL coordinates rebalance activity for a dis
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:Which initialization parameter in an ASM instance specifies the disk groups to be automaticallymounted at instance startup?A. ASM_DISKMOUNTB. ASM_DISK
阅读全文
浙公网安备 33010602011771号