2021. 9. 16. 20:05 오라클
19c ASM Resource 제거 테스트
* 19c ASM Resource 제거 테스트
- 확인
[root@ocfs1:/root]# crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE ocfs1 STABLE
ONLINE ONLINE ocfs2 STABLE
ora.chad
ONLINE ONLINE ocfs1 STABLE
ONLINE ONLINE ocfs2 STABLE
ora.net1.network
ONLINE ONLINE ocfs1 STABLE
ONLINE ONLINE ocfs2 STABLE
ora.ons
ONLINE ONLINE ocfs1 STABLE
ONLINE ONLINE ocfs2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 OFFLINE OFFLINE STABLE
2 OFFLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE ocfs1 STABLE
ora.asm(ora.asmgroup)
1 OFFLINE OFFLINE STABLE
2 OFFLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 OFFLINE OFFLINE STABLE
2 OFFLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE ocfs2 STABLE
ora.ocfs.db
1 ONLINE ONLINE ocfs1 Open,HOME=/u01/app/o
racle/product/19.3.0
.0/dbhome_1,STABLE
2 ONLINE ONLINE ocfs2 Open,HOME=/u01/app/o
racle/product/19.3.0
.0/dbhome_1,STABLE
ora.ocfs1.vip
1 ONLINE ONLINE ocfs1 STABLE
ora.ocfs2.vip
1 ONLINE ONLINE ocfs2 STABLE
ora.qosmserver
1 ONLINE ONLINE ocfs2 STABLE
ora.scan1.vip
1 ONLINE ONLINE ocfs1 STABLE
(oracle)
[OCFS1]oracle@ocfs1:/home/oracle# srvctl config asmnetwork
ASM network 1 exists
Subnet IPv4: 10.10.10.0//
Subnet IPv6:
Network is enabled
Network is individually enabled on nodes:
Network is individually disabled on nodes:
[OCFS1]oracle@ocfs1:/home/oracle# srvctl config listener -listener ASMNET1LSNR_ASM
Name: ASMNET1LSNR_ASM
Type: ASM Listener
Owner: oracle
Subnet: 10.10.10.0
Home: <CRS home>
End points: TCP:1525
Listener is enabled.
Listener is individually enabled on nodes:
Listener is individually disabled on nodes:
- 제거
(oracle)
srvctl remove listener -listener ASMNET1LSNR_ASM
(root)
srvctl stop asmnetwork
srvctl remove asmnetwork -all
(oracle)
srvctl remove asm
- 추가
(oracle)
srvctl remove asm
(root)
srvctl add asmnetwork -netnum 1 -subnet 10.10.10.0
(oracle)
srvctl add listener -listener ASMNET1LSNR_ASM -endpoints "TCP:1525" (포트지정없으면 1522로 추가됨)
srvctl config listener -listener ASMNET1LSNR_ASM
만일 ASM 으로 구성된 Database 및 Diskgroup 도 삭제한다면
srvctl stop database -d TEST
srvctl stop diskgroup -g DATA
srvctl stop asm -n ocfs1
srvctl stop asm -n ocfs2
srvctl remove diskgroup -g DATA -f
srvctl remove asm -f
srvctl modify database -d TEST -z
srvctl start database -d TEST
