Siguiendo los siguientes pasos a continuación, podremos realizar la eliminacion de los diskgroup ASM de las bases de datos.
- Verificar el diskgroup ASM.
- Eliminar el diskgroup ASM.
- 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;