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?
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.
Explanation:
A: ASM_POWER_LIMIT specifies the maximum power on an Automatic Storage Management instance for disk
rebalancing. The higher the limit, the faster rebalancing will complete. Lower values will take longer, but
consume fewer processing and I/O resources.
D:
* Normally a separate process is fired up to do that rebalance. This will take a certain amount of time. If you
want it to happen faster, fire up more processes. You tell ASM it can add more processes by increasing the
rebalance power.
* ASMB
ASM Background Process
Communicates with the ASM instance, managing storage and providing statistics
Incorrect:
Not B: A higher, not a lower, value of DISK_REPAIR_TIME would be helpful here.
Not E: If you implement database writer I/O slaves by setting the DBWR_IO_SLAVES parameter, you configure
a single (master) DBWR process that has slave processes that are subservient to it. In addition, I/O slaves can
be used to “simulate” asynchronous I/O on platforms that do not support asynchronous I/O or implement it
inefficiently. Database I/O slaves provide non-blocking, asynchronous requests to simulate asynchronous I/O.
The correct answers should be A and C.
A – TRUE
The higher the power limit, the more quickly a rebalance operation can complete. Rebalancing takes longer with lower power values, but consumes fewer processing and I/O resources which are shared by other applications, such as the database.
C – TRUE
Grouping operations in a single ALTER DISKGROUP statement can reduce rebalancing operations.
http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG10070