Install Oracle GoldenGate in 1 instance database [3]

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

2. install oracle goldengate in 1 instance database-2

3. install oracle goldengate in 1 instance database-3

Advertisement

Tags: goldengate, oracle goldengate