프린트 하기

내맘대로긍정이 알려주는

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이 없어진걸 확인 가능함



참조 :