Get the App
SLTechnology News&Howtos  ›  Database  › 

Oracle RAC deletes an ASM disk group

Shulou Source: shulou.com Published: 2022-06-01 22:40:25 11月07日 Update

1. Check to confirm that the disk group to be deleted is in use

Select * from dba_data_files;select * from dba_temp_files;select * from v$logfile

two。 Dismount disk groups on each node first

Alter diskgroup REDO01 dismount;alter diskgroup REDO02 dismount;alter diskgroup REDODG1 dismount

Delete a disk group in 3.ASM

Drop diskgroup REDO01 force including contents;drop diskgroup REDO02 force including contents;drop diskgroup REDODG1 force including contents

4.crs delete disk group

Crsctl stat res-t-View disk group srvctl remove diskgroup-g REDO01-fsrvctl remove diskgroup-g REDO02-fsrvctl remove diskgroup-g REDODG1-f

5. Update crs information

View the disk groups that crs depends on:

Crsctl status res ora.veraa.db-fSTART_DEPENDENCIES=hard (ora.testDG1.dg,ora.testDG2.dg,ora.REDODG1.dg,ora.testDG3.dg,ora.REDO01.dg,ora.REDO02.dg,ora.REDODG01.dg) weak (type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns) pullup (ora.testDG1.dg,ora.testDG2.dg,ora.REDODG1.dg,ora.testDG3.dg,ora.REDO01.dg,ora.REDO02.dg Ora.REDODG01.dg) START_TIMEOUT=600STATE_CHANGE_TEMPLATE=STOP_DEPENDENCIES=hard (intermediate:ora.asm,shutdown:ora.testDG1.dg,shutdown:ora.testDG2.dg,shutdown:ora.REDODG1.dg,shutdown:ora.testDG3.dg,shutdown:ora.REDO01.dg,shutdown:ora.REDO02.dg,shutdown:ora.REDODG01.dg)

Modify the correct disk group:

Srvctl modify database-d veraa-a "testDG1,testDG2,testDG3,REDODG01"

Tags: Disk information node update check Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno OPPO Reno Linux Shulou Technology Huawei Docker