내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
다운로드
trending_flat
OS환경 : Oracle Linux 6.8 (64bit)
DB 환경 : Oracle Database 11.2.0.4 RAC
방법 : grid Infrastructure의 ocr, asm 제거하기
crs 상태 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 | $ crsctl stat res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.OCR.dg ONLINE OFFLINE prfandb1 ONLINE OFFLINE prfandb2 ora.asm ONLINE OFFLINE prfandb1 Instance Shutdown ONLINE OFFLINE prfandb2 ora.gsd OFFLINE OFFLINE prfandb1 OFFLINE OFFLINE prfandb2 ora.net1.network ONLINE ONLINE prfandb1 ONLINE ONLINE prfandb2 ora.ons ONLINE ONLINE prfandb1 ONLINE ONLINE prfandb2 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE prfandb2 ora.cvu 1 ONLINE ONLINE prfandb2 ora.oc4j 1 ONLINE ONLINE prfandb2 ora.prfan.db 1 ONLINE ONLINE prfandb1 Open 2 ONLINE ONLINE prfandb2 Open ora.prfandb1.vip 1 ONLINE ONLINE prfandb1 ora.prfandb2.vip 1 ONLINE ONLINE prfandb2 ora.scan1.vip 1 ONLINE ONLINE prfandb2 |
ocr과 asm이 존재함
하지만 현재 db는 raw device로 구성되어 있어서 ocr과 asm이 필요없음
1 2 3 4 5 6 7 8 9 | SQL> select file_name, tablespace_name, bytes, status from dba_data_files; FILE_NAME TABLESPACE_NAME BYTES STATUS -------------------- ------------------------------ ---------- --------- /dev/raw/raw7 SYSTEM 732954624 AVAILABLE /dev/raw/raw8 SYSAUX 732954624 AVAILABLE /dev/raw/raw10 UNDOTBS1 208666624 AVAILABLE /dev/raw/raw11 UNDOTBS2 732954624 AVAILABLE /dev/raw/raw9 USERS 732954624 AVAILABLE |
ocr 삭제 진행
1 | $ srvctl remove diskgroup -g OCR |
asm 삭제 진행
1 | $ srvctl remove asm |
crs 상태 재확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 | $ crsctl stat res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.gsd OFFLINE OFFLINE prfandb1 OFFLINE OFFLINE prfandb2 ora.net1.network ONLINE ONLINE prfandb1 ONLINE ONLINE prfandb2 ora.ons ONLINE ONLINE prfandb1 ONLINE ONLINE prfandb2 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE prfandb2 ora.cvu 1 ONLINE ONLINE prfandb2 ora.oc4j 1 ONLINE ONLINE prfandb2 ora.prfan.db 1 ONLINE ONLINE prfandb1 Open 2 ONLINE ONLINE prfandb2 Open ora.prfandb1.vip 1 ONLINE ONLINE prfandb1 ora.prfandb2.vip 1 ONLINE ONLINE prfandb2 ora.scan1.vip 1 ONLINE ONLINE prfandb2 |
ocr과 asm이 없어진걸 확인 가능함
참조 :
'ORACLE > Admin' 카테고리의 다른 글
DB 관련 사이트 리스트 (0) | 2019.02.25 |
---|---|
오라클 db name 변경 방법 nid, controlfile 재생성 (1) | 2019.02.25 |
grid 설치 시 사전 점검 스크립트 ./runcluvfy.sh (0) | 2019.02.15 |
diagnostic 경로 변경 (0) | 2019.02.15 |
로그마이너 log miner 사용법 12cR2 이상 (2) | 2019.02.15 |