OracleDB/Concept
srvctl을 이용하여 다양한 엔티티(database,instance,listener 등) 관리
대끄블
2025. 4. 21. 12:30
srvctl(Server Control Utility)이란?
Oracle RAC 구성 정보를 관리할 수 있는 유틸리티.
srvctl 명령어를 사용하여 database, instance, listener, scan listener, service, ASM 등 다양한 엔티티를 추가, 제거, 시작, 중지, 수정, 활성화 및 비활성화를 할 수 있습니다.
즉, crsctl stat res -t 명령어로 보여지는 다양한 리소스를 이 명령어를 통해 관리할 수 있다는 의미입니다.
[test19c2:/home/oracle]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.VOL1.advm
ONLINE ONLINE test19c1 STABLE
ONLINE ONLINE test19c2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE test19c1 STABLE
ONLINE ONLINE test19c2 STABLE
ora.chad
ONLINE ONLINE test19c1 STABLE
ONLINE ONLINE test19c2 STABLE
ora.net1.network
ONLINE ONLINE test19c1 STABLE
ONLINE ONLINE test19c2 STABLE
ora.ons
ONLINE ONLINE test19c1 STABLE
ONLINE ONLINE test19c2 STABLE
ora.proxy_advm
ONLINE ONLINE test19c1 STABLE
ONLINE ONLINE test19c2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE test19c1 STABLE
2 ONLINE ONLINE test19c2 STABLE
3 ONLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE test19c1 STABLE
2 ONLINE ONLINE test19c2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE test19c1 STABLE
ora.OCR.dg(ora.asmgroup)
1 ONLINE ONLINE test19c1 STABLE
2 ONLINE ONLINE test19c2 STABLE
3 OFFLINE OFFLINE STABLE
ora.RECO.dg(ora.asmgroup)
1 ONLINE ONLINE test19c1 STABLE
2 ONLINE ONLINE test19c2 STABLE
3 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE test19c1 Started,STABLE
2 ONLINE ONLINE test19c2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE test19c1 STABLE
2 ONLINE ONLINE test19c2 STABLE
3 ONLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE test19c1 STABLE
ora.qosmserver
1 ONLINE ONLINE test19c1 STABLE
ora.test19.db
1 ONLINE ONLINE test19c1 Open,HOME=/oracle/ap
p/oracle/product/19c,
STABLE
2 ONLINE ONLINE test19c2 Open,HOME=/oracle/ap
p/oracle/product/19c,
STABLE
ora.scan1.vip
1 ONLINE ONLINE test19c1 STABLE
ora.test19c1.vip
1 ONLINE ONLINE test19c1 STABLE
ora.test19c2.vip
1 ONLINE ONLINE test19c2 STABLE
--------------------------------------------------------------------------------
대표적으로 많이 사용되는 명령어는
--database 및 instance 정보 추가
srvctl add database -db <dbname> -oraclehome <ORACLE_HOME> -instance <inst_name>
--특정노드의 database 기동중지
srvctl start/stop database -db <dbname> -node <node>
--리소스 제거
srvctl remove listener -l <listenername>
...