These questions are based on 1Z0-050 – Oracle Database 11g New Features
Oracle Self Test Software Practice Test.
Objective: Storage enhancements.
Sub-objective: Set up ASM fast mirror resynch.
Single answer, multiple choice
You are managing an ASM instance with Oracle Database 11g. The ASM redundancy level is set to high. You have three disks in failure group fg1 of disk group dg5, namely d1, d2 and d3.
Disk d2 fails due to a hardware error. You want to bring all disks in failure group fg1 of disk group dg5 offline and drop them after one hour. Which statement should you execute?
- ALTER DISKGROUP dg5 OFFLINE DISKS DROP AFTER 1h.
- ALTER DISKGROUP DISKS IN FAILGROUP fg1 DROP AFTER 1h.
- ALTER DISKGROUP dg5 OFFLINE DISKS IN FAILGROUP fg1.
- ALTER DISKGROUP dg5 OFFLINE DISKS IN FAILGROUP fg1 DROP AFTER 1h.
D. ALTER DISKGROUP dg5 OFFLINE DISKS IN FAILGROUP fg1 DROP AFTER 1h.
You should execute the following statement:
ALTER DISKGROUP dg5 OFFLINE DISKS IN FAILGROUP fg1 DROP AFTER 1h.
With the ALTER DISKGROUP statement, you can bring all disks in a disk group or disks in a particular failure group offline using the OFFLINE DISKS clause. In this scenario, you include the IN FAILGROUP clause because you only want to offline disks in a specific failure group, fg1. The DROP AFTER clause specifies the time that should elapse before ASM drops the disks. In this scenario, you want ASM to drop the disks after an hour has elapsed, so you would specify DROP AFTER 1h. If you specify a DROP AFTER value, it overrides the value set for the DISK_REPAIR_TIME attribute. You also can use the ALTER DISKGROUP…OFFLINE DISK statement to bring individual disks offline.
You should not execute the statement that does not include the IN FAILGROUP clause because this would bring all the disks in the disk group offline and drop them after one hour, not just the ones in fg1.
You should not execute the statement that does not include the OFFLINE keyword because this is invalid syntax. You must specify the DISKGROUP keyword, the disk group name and the OFFLINE keyword.
You should not execute the statement that does not include the DROP AFTER clause because this would take the correct disks offline, but would not drop them after one hour had elapsed. Instead, it would drop them after the time period specified by the DBMS_REPAIR_TIME attribute elapsed. To override this and drop disks after a specified time, you must use the DROP AFTER clause.
Oracle University – Oracle Database 11g: New Features For Administrators – Chapter 2: Storage Enhancements – Setting Up ASM Fast Mirror Resync
Oracle Database Storage Administrator’s Guide 11g Release 1 (11.1)
Part Number B31107-02
Administering ASM Disk Groups – ASM Disk Group Redundancy – ASM Fast Mirror Resync
Oracle Database New Features Guide 11g Release 1 (11.1)
Part Number B28279-02
Oracle 11g Database New Features – Manageability – ASM Fast Mirror Resync
Oracle Database SQL Language Reference 11g Release 1 (11.1)
Part Number B28286-02