Oracle drop diskgroup

Siguiendo los siguientes pasos a continuación, podremos realizar la eliminacion de los diskgroup ASM de las bases de datos.

1. Verificar el diskgroup ASM.
2. Eliminar el diskgroup ASM.
3. Comprobar el diskgroup eliminado desde ASM.

Verificar el diskgroup ASM

Nos conectamos a SQL*Plus como sysasm

sqlplus / as sysasm

SQL> set lines 255 
col path for a40 
col Diskgroup for a15 
col DiskName for a20 
col disk# for 999 
col total_mb for 999,999,999 
col free_mb for 999,999,999 
compute sum of total_mb on DiskGroup 
compute sum of free_mb on DiskGroup 
break on DiskGroup skip 1 on report - 

set pages 255 

select a.name DiskGroup, b.disk_number Disk#, b.name DiskName, b.total_mb, b.free_mb, b.path, b.header_status 
from v$asm_disk b, v$asm_diskgroup a 
where a.group_number (+) =b.group_number 
order by b.group_number, b.disk_number, b.name;

Eliminar el diskgroup ASM

Ahora procedemos a realizar la eliminacion del diskgroup con todos los contenidos incluidos

SQL> DROP DISKGROUP DG_DATA INCLUDING CONTENTS;

Comprobar

Finalmente, realizamos la validación de los diskgroup, aquí podríamos evidenciar que no se encuentra y los discos los evidenciaríamos con estatus FORMER

SQL> set lines 255 
col path for a40 
col Diskgroup for a15 
col DiskName for a20 
col disk# for 999 
col total_mb for 999,999,999 
col free_mb for 999,999,999 
compute sum of total_mb on DiskGroup 
compute sum of free_mb on DiskGroup 
break on DiskGroup skip 1 on report - 

set pages 255 

select a.name DiskGroup, b.disk_number Disk#, b.name DiskName, b.total_mb, b.free_mb, b.path, b.header_status 
from v$asm_disk b, v$asm_diskgroup a 
where a.group_number (+) =b.group_number 
order by b.group_number, b.disk_number, b.name;