Datasheet

Working with the ASM Instance

determine if the operation has completed, you will need to review the V$ASM_DISK view.

When the disk drop is complete the column

HEADER_STATUS will take on the value of FORMER,

as shown in this example:

SQL> select disk_number, header_status from v$asm_disk;

DISK_NUMBER HEADER_STATU

----------- ------------

0 FORMER

1 FORMER

1 MEMBER

2 MEMBER

If the drop is not complete (the V$ASM_DISK column STATE will read dropping), you can

check the

V$ASM_OPERATION view and it will give you an idea of how long the operation is

expected to take before it is complete. Here is an example query that will provide you with

this information:

select group_number, operation, state, power, est_minutes

from v$asm_operation;

Adding and Dropping Disks from an ASM Disk Group

The alter diskgroup command will allow you to add and drop a disk from a disk group at

the same time. Assuming you want to add a disk

/dev/raw/raw6 and drop a disk called d2c,

you could issue this command:

alter diskgroup mydisk group

add failgroup fg4 disk ‘/dev/raw/raw6/ name d2d

drop disk d2c;

Undropping Disks from an ASM Disk Group

You know you are having a bad day when you accidentally drop a disk from a disk group and

you realize your mistake only after the drop operation has completed. Fortunately, this is not

one of those mistakes that you cannot recover from. If you have accidentally dropped a disk,

simply use the

alter diskgroup command with the undrop disks parameter, as shown here:

alter diskgroup sp_dgroup2 undrop disks;

This will cancel the pending drop of disks from that disk group. You can not use this

command to restore disks dropped if you dropped the entire disk group with the

drop

diskgroup

command.

95134c01.indd 23 1/28/09 9:43:43 AM