Tuesday, September 2, 2008

Taking ASM disk groups offline.

# first shutdown the databases on the relevant disk groups.

# on ASM
ALTER DISKGROUP ASM_ORADATA31 DISMOUNT;
ALTER DISKGROUP ASM_ORADATA32 DISMOUNT;

SQL> select name, state from v$asm_diskgroup;

NAME STATE
------------------------------ -----------
ASM_ORADATA11 MOUNTED
ASM_ORADATA12 MOUNTED
ASM_ORADATA13 MOUNTED
ASM_ORADATA32 DISMOUNTED
ASM_ORADATA31 DISMOUNTED
ASM_ORADATA41 MOUNTED
ASM_ORADATA42 MOUNTED

ALTER DISKGROUP ASM_ORADATA31 MOUNT;
ALTER DISKGROUP ASM_ORADATA32 MOUNT;