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
Explanation:
Check out the answer options, it is tricky. The NOT OFFLINE disks equals ONLINE disks.
Refer to Set the DISK_REPAIR_TIME Disk Group Attribute Appropriately.
The DISK_REPAIR_TIME disk group attribute specifies how long a disk remains offline
before Oracle ASM drops the disk. If a disk is made available before the
DISK_REPAIR_TIME parameter has expired, the storage administrator can issue the
ONLINE DISK command and Oracle ASM resynchronizes the stale data from the mirror
side. In Oracle Database 11g, the online disk operation does not restart if there is a failure of
the instance on which the disk is running. You must reissue the command manually to bring
the disk online.
Correct me if I am wrong but as far as I can see in …
https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG10047
(Please note the version of oracle being tested for IZO-053 is 11.2.0.1)
it says and I quote …
If the attribute (he is talking about DISK_REPAIR_TIME here) is not set explicitly, then the default value (3.6h) applies to disks that have been set to OFFLINE mode without an explicit DROP AFTER clause. Disks taken offline due to I/O errors do not have a DROP AFTER clause.
A few paragraphs later it says …
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.
I ask …
Who writes these “Explanations”?
What oracle database version are they based on?
Where do they get their information?
Correct me if I am wrong but
The documentation for version 11.2.0.1 says and I quote …
If the attribute is not set explicitly, then the default value (3.6h) applies to disks that have been set to OFFLINE mode without an explicit DROP AFTER clause. Disks taken offline due to I/O errors do not have a DROP AFTER clause.
A few paragraphs later it says …
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 that is specified for the DISK_REPAIR_TIME attribute for the disk group is used. If this attribute value is changed with the ALTER DISKGROUP… SET ATTRIBUTE ‘disk_repair_time’ statement before this offlined disk is dropped, then the new (current) value of the attribute is used by the Oracle ASM disk offline functionality but the elapsed time is not reset. You can confirm this behavior by viewing the Oracle ASM alert log.
(Please note the version of oracle being tested for IZO-053 is 11.2.0.1 see
https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-053&p_org_id=&lang=
However this version of the documentation is a little hard to come by. I have it on my PC.
Oracle documentation version 11.2.0.4 can be found at …
https://docs.oracle.com/cd/E11882_01, but it is different also with reference to this question)
is different again. Check out what the 11.2.0.4 documentation says on …
https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG10044
Confusing is right.
Correct answer is B (sort of)
I ask …
Who writes these “Explanations”?
What oracle database version are they based on?
Where do they get their information?
I stand corrected. (I was wrong above)
Answer C is correct.
Here is the updated version.
Please note that the version of oracle exam-ed in IZO-053 is 11.2.0.1 as stated here
https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-053&p_org_id=&lang=
Therefore please refer to the 11.2.0.1 documentation found in
http://oracle.su/docs/11g/nav/portal_booklist.htm
For the answer see …
http://oracle.su/docs/11g/server.112/e10500/asmdiskgrps.htm#CHDBCBGF
There is text that says ….
Altering the DISK_REPAIR_TIME attribute has no effect on offline disks.
So the “explanation” stands.