which disks in the disk group will the new value be applicable?

You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:

ALTER DISKGROUP dg01 SET ATTRIBUTE ‘disk_repair_time’ = ‘5h’; to which disks in the disk group will the new value be applicable?

You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:

ALTER DISKGROUP dg01 SET ATTRIBUTE ‘disk_repair_time’ = ‘5h’; to which disks in the disk group will the new value be applicable?

A.
all disks in the disk group

B.
all disks that are currently in OFFLINE mode

C.
all disks that are not currently in OFFLINE mode

D.
all disks in the disk group only if all of them are ONLINE

Show Hint

Leave a Reply 3

Your email address will not be published. Required fields are marked *

Harsha

Harsha

I suspect A is the correct answer.

Reply

Ivan M.

Ivan M.

No, the correct is option C.

http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG10044
[…]
Note:
If a disk is offlined by Oracle ASM because of an I/O (write) error or is explicitly offlined using the ALTER DISKGROUP… OFFLINE statement without the DROP AFTER clause, then the value specified for the DISK_REPAIR_TIME attribute for the disk group is used.
Altering the DISK_REPAIR_TIME attribute has no effect on offline disks. The new value is used for any disks that go offline after the attribute is updated. You can confirm this behavior by viewing the Oracle ASM alert log.
[…]

Reply