In the SQL Reference manual, there is a description of the attributes
belonging to disk groups, in the description of CREATE DISKGROUP:
http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_5008.htm#SQLRF01114
For disk_repair_time one can read:
Note: If a disk is taken offline using the current value of
disk_repair_time, and the value of this attribute is subsequently changed,
then the changed value is used by Oracle ASM in the disk offline logic.
The way I understand this, is that if I change the value for
disk_repair_time after I have issued an ALTER DISKGROUP OFFLINE DISK
command, it will use the new value to decide when to drop the disk.
But, in the ASM Admin Guide, chapter 4 in the section on Oracle ASM Fast Mirror
Resync:
http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG10044
it says:
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.
I have by experiments verified that the last one (from ASM Admin Guide) is
true. Is this a documentation bug, and what would be the correct answer on
a certification exam ? The reason I have doubts about this is that a book
by Matthew Morris pretty much restates what is in the SQL Reference manual.
--
Øyvind Isene
+47 90864882
