OGG 연동 테이블 추가

 

0. 사전 체크(환경 체크)

• DB 서버 정보

	Source DB	Target DB
IP	172.168.122.111	172.168.122.122
OGG Port	7809	7810
SID	CHOKI	JULLY

 

• TABLE OWNER : TEST
• TABLE NAME : TEST
• PK/UK 확인

-- 테이블 PK/UK 확인
select * from dba_constraints where table_name in ('TEST') and CONSTRAINT_TYPE='P';
select * from dba_constraints where table_name in ('TEST') and CONSTRAINT_TYPE='U';

• 인덱스 확인

-- 인덱스 확인
select * from dba_indexes where table_name in ('TEST');
select * from dba_ind_columns where table_name in ('TEST');

 

 

 

1. Supplemental Logging 설정

$ su - ggs
$ ggsci

GGSCI> dblogin useid ggs, password ggs

GGSCI> info trandata test.test

GGSCI> ADD TRANDATA test.test

 

 

2. Extract 생성 & 기동

-- source
-- extract 생성

edit param ext01

extract ext01
Userid ggs, Password ggs
DiscardFile ./dirout/ext01.dec, append, megabytes 50
DisCardRollover at 00:01
ReportCount Every 1 Records, Rate
ReportRollover at 00:01
WARNLONGTRANS 1H, CHECKINTERVAL 10m
ExtTrail ./dirdat/ea
TABLE test.test;


-- extract 기동
add extract ext01, tranlog, begin now
add exttrail ./dirdat/ea, extract ext01, megabytes 50

 

 

3. Pump 생성 & 기동

-- pump 생성 

-- Source
edit param pmp01

extract pmp01
PassThru
RmtHost 192.168.122.122, MGRPORT 7810
RmtTrail ./dirdat/ea
ReportCount Every 1 Records, Rate
ReportRollover at 00:01
Table test.test;

-- Target 
ls -al ./dirdat/ea*


-- pump 기동
delete pmp01

add extract pmp01, exttrailsource ./dirdat/ea
add exttrail ./dirdat/ea, extract pmp01, megabytes 50
start pmp01


-- dirdat 파일 확인 
ls -al /ogg/oggs/dirdat/ea*

 

 

4. info 확인

• Extract, pump 프로세스가 정상적으로 기동되었는지 확인

GGSCI (choki) 2> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     STOPPED     EXTA01      00:00:00      00:07:35
EXTRACT     STOPPED     PMP01       00:00:00      00:05:24


GGSCI (choki) 3> info *

EXTRACT    EXTA01    Initialized   2024-12-10 01:47   Status STOPPED
Checkpoint Lag       00:00:00 (updated 00:07:37 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2024-12-10 01:47:08  Seqno 0, RBA 0
                     SCN 0.0 (0)

EXTRACT    PMP01     Initialized   2024-12-10 01:49   Status STOPPED
Checkpoint Lag       00:00:00 (updated 00:05:26 ago)
Log Read Checkpoint  File ./dirdat/ex000000000
                     First Record  RBA 0

 

 

5. replicate 생성 및 기동

-- Replicate

edit param rep01

Replicat rep01
Userid ogg, Password ogg
DiscardFile ./dirout/rep02.dec, append, megabytes 50
DiscardRollover at 00:01
ReportCount Every 1 Records, Rate
ReportRollover at 00:01
MAP test.test, Target test.test;


-- Replicate 기동 
add replicat rep01, exttrail ./dirdat/ea nodbcheckpoint
start rep01