Storage Enhancements.

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?



  1. ALTER DISKGROUP dg5 OFFLINE DISKS DROP AFTER 1h.
  2. ALTER DISKGROUP DISKS IN FAILGROUP fg1 DROP AFTER 1h.
  3. ALTER DISKGROUP dg5 OFFLINE DISKS IN FAILGROUP fg1.
  4. ALTER DISKGROUP dg5 OFFLINE DISKS IN FAILGROUP fg1 DROP AFTER 1h.

Answer:
D. ALTER DISKGROUP dg5 OFFLINE DISKS IN FAILGROUP fg1 DROP AFTER 1h.


Tutorial:
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…


cmadmin

ABOUT THE AUTHOR

Posted in Uncategorized|

Comment:

Powered by WebDesk