소스 보기

네트워크 정보 수정

hosts 파일 수정

[primary 1번 DG 전용 IP]  [primary 1번 DG 전용 호스트명]
[primary 2번 DG 전용 IP]  [primary 2번 DG 전용 호스트명]
[primary 1번 DG 전용 VIP] [primary 1번 DG 전용 VIP명]
[primary 2번 DG 전용 VIP] [primary 2번 DG 전용 VIP명]
[standby DG 전용 IP]      [standby DG 전용 호스트명]

### Public
10.0.1.101      seoul1        seoul1.localdomain
10.0.1.102      seoul2        seoul2.localdomain
### Private
10.0.5.101      seoul1-priv   seoul1-priv.localdomain
10.0.5.102      seoul2-priv   seoul2-priv.localdomain
### Virtual
10.0.1.201      seoul1-vip    seoul1-vip.localdomain
10.0.1.202      seoul2-vip    seoul2-vip.localdomain
### SCAN
10.0.1.180      seoul-scan    seoul-scan.localdomain
### STANDBY
10.0.1.105      busan
### DG
10.0.7.101      seoul1-dg     seoul1-dg.localdomain
10.0.7.102      seoul2-dg     seoul2-dg.localdomain
10.0.7.105      busan-dg
### DG Virtual
10.0.7.201      seoul1-dgv    seoul1-dgv.localdomain
10.0.7.202      seoul2-dgv    seoul2-dgv.localdomain

클러스터 리소스 추가

RAC(Primary)에 Data Guard 전용 network 객체 추가

srvctl add network -k [네트워크 번호] -S [DG 전용 IP C클래스 정보]/255.255.255.0/[DG 전용 NIC명]
srvctl config network -netnum [네트워크 번호]

[root@seoul1 ~]# srvctl add network -k 2 -S 10.0.7.0/255.255.255.0/ens38

[root@seoul1 ~]# srvctl config network -netnum 2
2 네트워크가 존재합니다.
서브넷 IPv4: 10.0.7.0/255.255.255.0/ens38, static
서브넷 IPv6:
핑 대상:
네트워크가 사용으로 설정되었습니다.
네트워크가 노드에서 개별적으로 사용으로 설정됨:
네트워크가 노드에서 개별적으로 사용 안함으로 설정됨:

[root@seoul1 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       seoul1                   STABLE
               ONLINE  ONLINE       seoul2                   STABLE
ora.chad
               ONLINE  ONLINE       seoul1                   STABLE
               ONLINE  ONLINE       seoul2                   STABLE
ora.net1.network
               ONLINE  ONLINE       seoul1                   STABLE
               ONLINE  ONLINE       seoul2                   STABLE
ora.net2.network
               OFFLINE OFFLINE      seoul1                   STABLE
               OFFLINE OFFLINE      seoul2                   STABLE
ora.ons
               ONLINE  ONLINE       seoul1                   STABLE
               ONLINE  ONLINE       seoul2                   STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       seoul1                   STABLE
      2        ONLINE  ONLINE       seoul2                   STABLE
ora.CRS.dg(ora.asmgroup)
      1        ONLINE  ONLINE       seoul1                   STABLE
      2        ONLINE  ONLINE       seoul2                   STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       seoul1                   STABLE
      2        ONLINE  ONLINE       seoul2                   STABLE
ora.FRA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       seoul1                   STABLE
      2        ONLINE  ONLINE       seoul2                   STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       seoul1                   STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       seoul1                   Started,STABLE
      2        ONLINE  ONLINE       seoul2                   Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       seoul1                   STABLE
      2        ONLINE  ONLINE       seoul2                   STABLE
ora.cvu
      1        ONLINE  ONLINE       seoul1                   STABLE
ora.qosmserver
      1        ONLINE  ONLINE       seoul1                   STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       seoul1                   STABLE
ora.seoul1.vip
      1        ONLINE  ONLINE       seoul1                   STABLE
ora.seoul2.vip
      1        ONLINE  ONLINE       seoul2                   STABLE
ora.testdb.db
      1        ONLINE  ONLINE       seoul1                   Open,HOME=/u01/app/o
                                                             racle/db/19c,STABLE
      2        ONLINE  ONLINE       seoul2                   Open,HOME=/u01/app/o
                                                             racle/db/19c,STABLE
--------------------------------------------------------------------------------

RAC(Primary)에 Data Guard 전용 VIP 추가

srvctl add vip -n [1번 호스트명] -k [네트워크 번호] -A [primary 1번 DG VIP명]/255.255.255.0/[DG 전용 NIC명]
srvctl add vip -n [2번 호스트명] -k [네트워크 번호] -A [primary 2번 DG VIP명]/255.255.255.0/[DG 전용 NIC명]
srvctl start vip -vip [1번 노드 DG 전용 VIP명]
srvctl start vip -vip [2번 노드 DG 전용 VIP명]
crsctl stat res -t | grep -E 'net|vip'

[root@seoul1 ~]# srvctl add vip -n seoul1 -k 2 -A seoul1-dgv/255.255.255.0/ens38

[root@seoul1 ~]# srvctl add vip -n seoul2 -k 2 -A seoul2-dgv/255.255.255.0/ens38

[root@seoul1 ~]# srvctl start vip -vip seoul1_2

[root@seoul1 ~]# srvctl start vip -vip seoul2_2

[root@seoul1 ~]# crsctl stat res -t | grep -E 'net|vip'
ora.net1.network
ora.net2.network
ora.asmnet1.asmnetwork(ora.asmgroup)
ora.scan1.vip
ora.seoul1.vip
ora.seoul1_2.vip
ora.seoul2.vip
ora.seoul2_2.vip

[root@seoul1 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       seoul1                   STABLE
               ONLINE  ONLINE       seoul2                   STABLE
ora.chad
               ONLINE  ONLINE       seoul1                   STABLE
               ONLINE  ONLINE       seoul2                   STABLE
ora.net1.network
               ONLINE  ONLINE       seoul1                   STABLE
               ONLINE  ONLINE       seoul2                   STABLE
ora.net2.network
               ONLINE  ONLINE       seoul1                   STABLE
               ONLINE  ONLINE       seoul2                   STABLE
ora.ons
               ONLINE  ONLINE       seoul1                   STABLE
               ONLINE  ONLINE       seoul2                   STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       seoul1                   STABLE
      2        ONLINE  ONLINE       seoul2                   STABLE
ora.CRS.dg(ora.asmgroup)
      1        ONLINE  ONLINE       seoul1                   STABLE
      2        ONLINE  ONLINE       seoul2                   STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       seoul1                   STABLE
      2        ONLINE  ONLINE       seoul2                   STABLE
ora.FRA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       seoul1                   STABLE
      2        ONLINE  ONLINE       seoul2                   STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       seoul1                   STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       seoul1                   Started,STABLE
      2        ONLINE  ONLINE       seoul2                   Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       seoul1                   STABLE
      2        ONLINE  ONLINE       seoul2                   STABLE
ora.cvu
      1        ONLINE  ONLINE       seoul1                   STABLE
ora.qosmserver
      1        ONLINE  ONLINE       seoul1                   STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       seoul1                   STABLE
ora.seoul1.vip
      1        ONLINE  ONLINE       seoul1                   STABLE
ora.seoul1_2.vip
      1        ONLINE  ONLINE       seoul1                   STABLE
ora.seoul2.vip
      1        ONLINE  ONLINE       seoul2                   STABLE
ora.seoul2_2.vip
      1        ONLINE  ONLINE       seoul2                   STABLE
ora.testdb.db
      1        ONLINE  ONLINE       seoul1                   Open,HOME=/u01/app/o
                                                             racle/db/19c,STABLE
      2        ONLINE  ONLINE       seoul2                   Open,HOME=/u01/app/o
                                                             racle/db/19c,STABLE
--------------------------------------------------------------------------------

RAC(Primary)에 Data Guard 전용 listener 추가

srvctl add listener -listener LISTENER_DG -netnum [네트워크 번호] -endpoints "TCP:[DG 전용 리스너 포트 번호]" -oraclehome $GI_HOME
srvctl start listener -listener LISTENER_DG
lsnrctl stat LISTENER_DG

[+ASM1@seoul1:~]$ srvctl add listener -listener LISTENER_DG -netnum 2 -endpoints "TCP:1625" -oraclehome $GI_HOME

[+ASM1@seoul1:~]$ srvctl start listener -listener LISTENER_DG

[+ASM1@seoul1:~]$ lsnrctl stat LISTENER_DG

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 04-APR-2024 13:43:02

Copyright (c) 1991, 2023, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_DG)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_DG
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                04-APR-2024 13:42:54
Uptime                    0 days 0 hr. 0 min. 7 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/gi/19c/network/admin/listener.ora
Listener Log File         /u01/app/oracle/db/diag/tnslsnr/seoul1/listener_dg/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_DG)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.7.201)(PORT=1625)))
The listener supports no services
The command completed successfully

[+ASM2@seoul2:~]$ lsnrctl stat LISTENER_DG

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 04-APR-2024 13:43:45

Copyright (c) 1991, 2023, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_DG)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_DG
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                04-APR-2024 13:42:54
Uptime                    0 days 0 hr. 0 min. 50 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/gi/19c/network/admin/listener.ora
Listener Log File         /u01/app/oracle/db/diag/tnslsnr/seoul2/listener_dg/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_DG)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.7.202)(PORT=1625)))
The listener supports no services
The command completed successfully

Local Listener 추가

alter system set LOCAL_LISTENER="(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=[인스턴스별 기존 VIP명 또는 IP])(PORT=[기존 리스너 포트]))(ADDRESS=(PROTOCOL=TCP)(HOST=[인스턴스별 DG 전용 VIP 명 또는 IP])(PORT=[DG 전용 리스너 포트 번호])))" sid='[인스턴스명]';

SQL> alter system set LOCAL_LISTENER="(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=seoul1-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=seoul1-dgv)(PORT=1625)))" sid='TESTDB1';

System altered.

SQL> alter system register;

System altered.

SQL> alter system set LOCAL_LISTENER="(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=seoul2-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=seoul2-dgv)(PORT=1625)))" sid='TESTDB2';

System altered.

SQL> alter system register;

System altered.

복제용 임시 리스너 생성

Standby에 임시 listener 생성

LISTENER_TEMP =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = [standby DG 전용 호스트명 또는 IP])(PORT = [리스너 포트 번호]))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC[리스너 포트 번호]))
    )
  )

SID_LIST_LISTENER_TEMP =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = [standby 글로벌 DB명])
      (ORACLE_HOME = [DB 홈 경로])
      (SID_NAME = [standby 인스턴스명])
    )
  )

[TESTDB@busan:~]$ cat >> $DB_HOME/network/admin/listener.ora
LISTENER_TEMP =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = busan-dg)(PORT = 1625))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1625))
    )
  )

SID_LIST_LISTENER_TEMP =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = TESTDB_STBY)
      (ORACLE_HOME = /u01/app/oracle/db/19c)
      (SID_NAME = TESTDB)
    )
  )
^C

임시 listener 기동

lsnrctl start LISTENER_TEMP

[TESTDB@busan:~]$ lsnrctl start LISTENER_TEMP

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 04-APR-2024 14:01:53

Copyright (c) 1991, 2023, Oracle.  All rights reserved.

Starting /u01/app/oracle/db/19c/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/db/19c/network/admin/listener.ora
Log messages written to /u01/app/oracle/db/diag/tnslsnr/busan/listener_temp/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.7.105)(PORT=1625)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1625)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=busan-dg)(PORT=1625)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_TEMP
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                04-APR-2024 14:01:53
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/db/19c/network/admin/listener.ora
Listener Log File         /u01/app/oracle/db/diag/tnslsnr/busan/listener_temp/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.7.105)(PORT=1625)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1625)))
Services Summary...
Service "TESTDB_STBY" has 1 instance(s).
  Instance "TESTDB", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

접속 정보 설정

Primary와 Standby에 tnsnames.ora 설정

### primary site ###
[primary 호스트명]_SYN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = [primary 1번 DG 전용 VIP명])(PORT = [리스너 포트]))
    (ADDRESS = (PROTOCOL = TCP)(HOST = [primary 2번 DG 전용 VIP명])(PORT = [리스너 포트]))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = [primary 글로벌 DB명]))
  )

[primary 1번 인스턴스명]_SYN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = [primary 1번 DG 전용 VIP명])(PORT = [리스너 포트]))
    (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = [primary 글로벌 DB명])(INSTANCE_NAME = [primary 1번 인스턴스명]))
  )

[primary 2번 인스턴스명]_SYN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = [primary 1번 DG 전용 VIP명])(PORT = [리스너 포트]))
    (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = [primary 글로벌 DB명])(INSTANCE_NAME = [primary 2번 인스턴스명]))
  )

### standby site ###
[standby 호스트명]_SYN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = [standby DG 전용 호스트명])(PORT = [리스너 포트]))
    (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = [standby 글로벌 DB명]))
  )

### primary site ###
SEOUL_SYN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = seoul1-dgv)(PORT = 1625))
    (ADDRESS = (PROTOCOL = TCP)(HOST = seoul2-dgv)(PORT = 1625))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = TESTDB))
  )

TESTDB1_SYN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = seoul1-dgv)(PORT = 1625))
    (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = TESTDB)(INSTANCE_NAME = TESTDB1))
  )

TESTDB2_SYN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = seoul2-dgv)(PORT = 1625))
    (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = TESTDB)(INSTANCE_NAME = TESTDB2))
  )

### standby site ###
BUSAN_SYN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = busan-dg)(PORT = 1625))
    (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = TESTDB_STBY))
  )