Oracle Database 12c: Installation and Administration — Question 125

You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy.
One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed.
When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.
Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again? (Choose two.)

Answer options

• A. Increase the value of the ASM_POWER_LIMIT parameter.
• B. Set the DISK_REPAIR_TIME disk attribute to a lower value.
• C. Specify the statement that adds the disk back to the disk group.
• D. Increase the number of ASMB processes.
• E. Increase the number of DBWR_IO_SLAVES in the ASM instance.

Correct answer: A, D

Explanation

Increasing the ASM_POWER_LIMIT parameter allows for a more aggressive rebalance operation, which can significantly speed up the process. Additionally, having more ASMB processes can improve the performance of the rebalance by distributing the workload more efficiently. The other options do not directly enhance the rebalance speed or may not be relevant to the specific scenario of disk replacement.