III. Demo Replication
1. manager harus start
[oracle@orcl10 ~]$ export GGATE=/u01/app/oracle/product/gg
[oracle@orcl10 ~]$ cd $GGATE
[oracle@orcl10 gg]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 10.4.0.19 Build 002
Linux, x64, 64bit (optimized), Oracle 10 on Sep 22 2009 14:18:08
Copyright (C) 1995, 2009, Oracle and/or its affiliates. All rights reserved.
GGSCI (orcl10) 1> info all
Program Status Group Lag Time Since Chkpt
MANAGER STOPPED
GGSCI (orcl10) 2> info manager
Manager is DOWN!
GGSCI (orcl10) 3> start manager
Manager started.
GGSCI (orcl10) 4> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
2. Create scipt source
GGSCI (orcl10) 5> add extract ext1, tranlog, begin now
EXTRACT added.
GGSCI (orcl10) 6> add exttrail /u01/app/oracle/product/gg/dirdat/lt, extract ext1
EXTTRAIL added.
GGSCI (orcl10) 7> edit params ext1
–extract group–
EXTRACT ext1
–connection to database–
USERID ggate, PASSWORD 123456
–hostname and port for trail–
RMTHOST orcl10, MGRPORT 7809
–path and name for trail–
rmttrail /u01/app/oracle/product/gg/dirdat/lt
–DDL support
ddl include mapped objname sumber.*
–DML
TABLE sumber.*;
GGSCI (orcl10) 6> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT1 00:00:00 00:02:48
GGSCI (orcl10) 7> start EXTRACT EXT1
GGSCI (orcl10) 8> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:03:03
3. Create scipt untuk target
GGSCI (orcl10) 1> dblogin userid ggate
Password:
Successfully logged into database.
GGSCI (orcl10) 2> add checkpointtable ggate.checkpoint
Successfully created checkpoint table GGATE.CHECKPOINT.
GGSCI (orcl10) 3> edit params ./GLOBALS
GGSCHEMA tujuan
CHECKPOINTTABLE ggate.checkpoint
GGSCI (orcl3) 4> add replicat rep1, exttrail /u01/app/oracle/product/gg/dirdat/lt,checkpointtable ggate.checkpoint
REPLICAT added.
GGSCI (orcl3) 5> edit params rep1
–Replicat group —
replicat rep1
–source and target definitions
ASSUMETARGETDEFS
–target database login —
userid ggate, password 123456
–ddl support
DDL
–file for dicarded transaction —
discardfile /u01/app/oracle/product/gg/discard/rep1_discard.txt, append, megabytes 10
map sumber.*, target tujuan.*;
GGSCI (orcl10) 6> start REPLICAT REP1
Sending START request to MANAGER …
REPLICAT REP1 starting
GGSCI (orcl10) 7> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:00:03
REPLICAT RUNNING REP1 00:00:00 00:00:03
4. testttttttttt
a. source : create table, insert 2 record
target : ter-replikasi
###################################
### Source:
###################################
[oracle@orcl10 gg]$ sqlplus source/123456@orcl10
SQL> CREATE TABLE DEPT
( DEPTNO NUMBER(2),
DNAME VARCHAR2(14),
LOC VARCHAR2(13)
);
SQL> CREATE UNIQUE INDEX PK_DEPT ON DEPT(DEPTNO) LOGGING;
SQL> ALTER TABLE DEPT ADD (CONSTRAINT PK_DEPT PRIMARY KEY (DEPTNO));
SQL> insert into dept values (51,’IT’,’SBY’);
SQL> insert into dept values (52,’AU’,’SBY’);
SQL> commit;
SQL> select * from dept order by deptno;
DEPTNO DNAME LOC
———- ————– ————-
51 IT SBY
52 AU SBY
###################################
### Target:
###################################
SQL> conn tujuan/123456@orcl10
SQL> select * from dept order by deptno;
DEPTNO DNAME LOC
———- ————– ————-
51 IT SBY
52 AU SBY
DEPTNO DNAME LOC
———- ————– ————-
51 IT SBY
52 AU SBY
b. source : insert 2 record lagi
target : ter-replikasi
###################################
### Source:
###################################
SQL> insert into dept values (53,’MKT’,’JKT’);
SQL> insert into dept values (54,’ACC’,’JKT’);
SQL> commit;
SQL> select * from dept order by deptno;
DEPTNO DNAME LOC
———- ————– ————-
51 IT SBY
52 AU SBY
53 MKT JKT
54 ACC JKT
###################################
### Target:
###################################
SQL> select * from dept order by deptno;
DEPTNO DNAME LOC
———- ————– ————-
51 IT SBY
52 AU SBY
53 MKT JKT
54 ACC JKT
c. source : delete record
target : ter-replikasi
###################################
### Source:
###################################
SQL> delete dept where deptno > 52;
SQL> commit;
SQL> select * from dept order by deptno;
DEPTNO DNAME LOC
———- ————– ————-
51 IT SBY
52 AU SBY
###################################
### Target :
###################################
SQL> select * from dept order by deptno;
DEPTNO DNAME LOC
———- ————– ————-
51 IT SBY
52 AU SBY
1. install oracle goldengate in 1 instance database-1
Leave a comment