Get the App
SLTechnology News&Howtos  ›  Database  › 

ORACLE11GR2 RAC uninstall ASM instance steps

Shulou Source: shulou.com Published: 2022-06-01 06:55:31 10月01日 Update

1. Stop all node ASM instances

$srvctl stop asm-n testdb1-f

$srvctl stop asm-n testdb2-f

$srvctl stop asm-n testdb3-f

$srvctl stop asm-n testdb4-f

Check the status of CRS resources, and the ASM instance is already shutdown

$crsctl stat res-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.LISTENER.lsnr

ONLINE ONLINE testdb1

ONLINE ONLINE testdb2

ONLINE ONLINE testdb3

ONLINE ONLINE testdb4

Ora.OCRVOTE.dg

OFFLINE OFFLINE testdb1

OFFLINE OFFLINE testdb2

OFFLINE OFFLINE testdb3

OFFLINE OFFLINE testdb4

Ora.asm

OFFLINE OFFLINE testdb1 Instance Shutdown

OFFLINE OFFLINE testdb2 Instance Shutdown

OFFLINE OFFLINE testdb3 Instance Shutdown

OFFLINE OFFLINE testdb4 Instance Shutdown

Ora.gsd

OFFLINE OFFLINE testdb1

OFFLINE OFFLINE testdb2

OFFLINE OFFLINE testdb3

OFFLINE OFFLINE testdb4

Ora.net1.network

ONLINE ONLINE testdb1

ONLINE ONLINE testdb2

ONLINE ONLINE testdb3

ONLINE ONLINE testdb4

Ora.ons

ONLINE ONLINE testdb1

ONLINE ONLINE testdb2

ONLINE ONLINE testdb3

ONLINE ONLINE testdb4

Ora.registry.acfs

OFFLINE OFFLINE testdb1

OFFLINE OFFLINE testdb2

OFFLINE OFFLINE testdb3

OFFLINE OFFLINE testdb4

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE testdb4

Ora.cvu

1 ONLINE ONLINE testdb3

Ora.oc4j

1 ONLINE ONLINE testdb3

Ora.scan1.vip

1 ONLINE ONLINE testdb4

Ora.testdb1.vip

1 ONLINE ONLINE testdb1

Ora.testdb2.vip

1 ONLINE ONLINE testdb2

Ora.testdb3.vip

1 ONLINE ONLINE testdb3

Ora.testdb4.vip

1 ONLINE ONLINE testdb4

2. Remove ASM resources

$srvctl remove asm-f

$crsctl stat res-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.LISTENER.lsnr

ONLINE ONLINE testdb1

ONLINE ONLINE testdb2

ONLINE ONLINE testdb3

ONLINE ONLINE testdb4

Ora.OCRVOTE.dg

OFFLINE OFFLINE testdb1

OFFLINE OFFLINE testdb2

OFFLINE OFFLINE testdb3

OFFLINE OFFLINE testdb4

Ora.gsd

OFFLINE OFFLINE testdb1

OFFLINE OFFLINE testdb2

OFFLINE OFFLINE testdb3

OFFLINE OFFLINE testdb4

Ora.net1.network

ONLINE ONLINE testdb1

ONLINE ONLINE testdb2

ONLINE ONLINE testdb3

ONLINE ONLINE testdb4

Ora.ons

ONLINE ONLINE testdb1

ONLINE ONLINE testdb2

ONLINE ONLINE testdb3

ONLINE ONLINE testdb4

Ora.registry.acfs

OFFLINE OFFLINE testdb1

OFFLINE OFFLINE testdb2

OFFLINE OFFLINE testdb3

OFFLINE OFFLINE testdb4

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE testdb4

Ora.cvu

1 ONLINE ONLINE testdb3

Ora.oc4j

1 ONLINE ONLINE testdb3

Ora.scan1.vip

1 ONLINE ONLINE testdb4

Ora.testdb1.vip

1 ONLINE ONLINE testdb1

Ora.testdb2.vip

1 ONLINE ONLINE testdb2

Ora.testdb3.vip

1 ONLINE ONLINE testdb3

Ora.testdb4.vip

1 ONLINE ONLINE testdb4

3. Remove OCRVOTE diskgroup resources

$srvctl remove diskgroup-g OCRVOTE-f

$crsctl stat res-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.LISTENER.lsnr

ONLINE ONLINE testdb1

ONLINE ONLINE testdb2

ONLINE ONLINE testdb3

ONLINE ONLINE testdb4

Ora.gsd

OFFLINE OFFLINE testdb1

OFFLINE OFFLINE testdb2

OFFLINE OFFLINE testdb3

OFFLINE OFFLINE testdb4

Ora.net1.network

ONLINE ONLINE testdb1

ONLINE ONLINE testdb2

ONLINE ONLINE testdb3

ONLINE ONLINE testdb4

Ora.ons

ONLINE ONLINE testdb1

ONLINE ONLINE testdb2

ONLINE ONLINE testdb3

ONLINE ONLINE testdb4

Ora.registry.acfs

OFFLINE OFFLINE testdb1

OFFLINE OFFLINE testdb2

OFFLINE OFFLINE testdb3

OFFLINE OFFLINE testdb4

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE testdb4

Ora.cvu

1 ONLINE ONLINE testdb3

Ora.oc4j

1 ONLINE ONLINE testdb3

Ora.scan1.vip

1 ONLINE ONLINE testdb4

Ora.testdb1.vip

1 ONLINE ONLINE testdb1

Ora.testdb2.vip

1 ONLINE ONLINE testdb2

Ora.testdb3.vip

1 ONLINE ONLINE testdb3

Ora.testdb4.vip

1 ONLINE ONLINE testdb4

4. Delete ASM information in / etc/oratab (all nodes)

Root@testdb1:/#cp / etc/oratab / etc/oratab_bak

Root@testdb1:/#vi / etc/oratab

+ ASM1:/oracle/app/11.2.0/grid:N # line added by Agent "" = = delete the line

5. Delete the disk head in the disk group OCRVOTE

Su-root

Dd if=/dev/zero of=/dev/vx/rdmp/emc0_04a1 bs=1024k count=50

Dd if=/dev/zero of=/dev/vx/rdmp/emc0_04ad bs=1024k count=50

Dd if=/dev/zero of=/dev/vx/rdmp/hitachi_vsp0_11cc bs=1024k count=50

Uninstall the ASM instance at this point is complete.

Tags: Instance resource disk node information status step Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno vpn MySQL MariaDB macOS Linux