Admin

Oracle asm proxy 삭제

Qhtlr 2020. 8. 28. 16:48

asmca 로 Volume Group를 생성하니 asm proxy 가 기동되었다.

 

리소스 부족으로  삭제/원복함

 

As soon as the volume is created, an ASM proxy instance is automatically started on both nodes.

 

--VG 생성후 상태

[grid@oradb1 ~]$ ps -ef|grep pmon
grid 4782 1 0 16:14 ? 00:00:00 asm_pmon_+ASM1
grid 5744 1 0 16:18 ? 00:00:00 apx_pmon_+APX1
oracle 11878 1 0 16:27 ? 00:00:00 ora_pmon_orcl1

 

[grid@oradb1 ~]$ crsctl stat res -t

--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.DATA_VG.advm
ONLINE ONLINE oradb1 STABLE

..

ora.proxy_advm
ONLINE ONLINE oradb1 STABLE

 

--이하 원복작업

--Volume 삭제

asmcmd> voldelete -G DATA DATA_VG

 

[grid@oradb1 ~]$ srvctl remove asm -proxy
PRCR-1025 : ora.proxy_advm 리소스가 이미 실행 중입니다.
[grid@oradb1 ~]$ srvctl stop asm -proxy
[grid@oradb1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.proxy_advm
OFFLINE OFFLINE oradb1 STABLE

 

[grid@oradb1 ~]$ srvctl remove asm -proxy

 

 

--삭제/원복후

[grid@oradb1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE oradb1 STABLE
ora.DATA.dg
ONLINE ONLINE oradb1 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE oradb1 STABLE
ora.LISTENER_DG4DB2.lsnr
ONLINE ONLINE oradb1 STABLE
ora.net1.network
ONLINE ONLINE oradb1 STABLE
ora.ons
ONLINE ONLINE oradb1 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE oradb1 STABLE
ora.MGMTLSNR
1 OFFLINE OFFLINE STABLE
ora.asm
1 ONLINE ONLINE oradb1 Started,STABLE
2 OFFLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE oradb1 STABLE
ora.oradb1.vip
1 ONLINE ONLINE oradb1 STABLE
ora.orcl.db
1 ONLINE INTERMEDIATE oradb1 Instance Starting,ST
ABLE
ora.qosmserver
1 ONLINE INTERMEDIATE oradb1 STABLE
ora.scan1.vip
1 ONLINE ONLINE oradb1 STABLE
--------------------------------------------------------------------------------

 

 

[grid@oradb1 ~]$ ps -ef|grep pmon
grid 4782 1 0 16:14 ? 00:00:00 asm_pmon_+ASM1
oracle 11878 1 0 16:27 ? 00:00:00 ora_pmon_orcl1
grid 13103 11204 0 16:32 pts/1 00:00:00 grep pmon

 

 

참고

docs.oracle.com/database/121/OSTMG/GUID-545C311D-24C6-421A-ACBE-CA29E1FDA0A6.htm

https://www.red-gate.com/simple-talk/sql/oracle/asm-proxy-new-instance-type-in-oracle-12c/