GoldenGateのClassic Replicat(非統合Replicat)の作成手順

. /home/oracle/.oraenv_db18s --環境変数の読み込み
cd /gg/gg2
./ggsci

#パラメータ作成
edit param r21

下記パラメータを設定する
----
REPLICAT R21
USERID c##ggs@db18p1,  PASSWORD oracle
DISCARDFILE ./dirrpt/r21.dsc, APPEND, MEGABYTES 500
DISCARDROLLOVER AT 2:00 ON SUNDAY
REPORTROLLOVER AT 2:00 ON SUNDAY

BATCHSQL
MAP ggtest.* ,TARGET db18p1.ggtest.*;
----

view param r21

#DBログイン
dblogin userid c##ggs@db18p1,password oracle

#Replicatプロセスの作成
add replicat r21, exttrail ./dirdat/d11/rt, CHECKPOINTTABLE c##ggs.ggs_ckpt

#チェックポイントファイルの作成
ADD CHECKPOINTTABLE c##ggs.ggs_ckpt
INFO CHECKPOINTTABLE c##ggs.ggs_ckpt

#実行結果
GSCI (dbvgg.jp.oracle.com as c##ggs@db18s/DB18P1) 4> add replicat r11, exttrail ./dirdat/d11/rt, CHECKPOINTTABLE c##ggs.ggs_ckpt
REPLICAT added.

GGSCI (dbvgg.jp.oracle.com as c##ggs@db18s/DB18P1) 5> add checkpointtable
ERROR: Missing checkpoint table specification.

GGSCI (dbvgg.jp.oracle.com as c##ggs@db18s/DB18P1) 6>

GGSCI (dbvgg.jp.oracle.com as c##ggs@db18s/DB18P1) 6> ADD CHECKPOINTTABLE c##ggs.ggs_ckpt
Logon catalog name DB18P1 will be used for table specification DB18P1.c##ggs.ggs_ckpt.

Successfully created checkpoint table DB18P1.c##ggs.ggs_ckpt.

GGSCI (dbvgg.jp.oracle.com as c##ggs@db18s/DB18P1) 7> info checkpointtable c##ggs.ggs_ckpt
Logon catalog name DB18P1 will be used for table specification DB18P1.c##ggs.ggs_ckpt.

Checkpoint table DB18P1.c##ggs.ggs_ckpt created 2019-04-03 10:33:15.