Oracle GoldenGate for Oracle 11g to PostgreSQL 9.2.4 Configuration(六)
licat process running on the Postgres machine and it needs a parameter file
GGSCI (ggpgt) 6> view param rpos
REPLICAT rpos
SOURCEDEFS /data/pgsql/ggs/dirdef/GGTEST.def
SETENV ( PGCLIENTENCODING = "UTF8" )
SETENV (ODBCINI="/data/pgsql/ggs/odbc.ini" )
SETENV (NLS_LANG="AMERICAN_AMERICA.AL32UTF8")
TARGETDB GG_Postgres, USERID zwc, PASSWORD zwc
DISCARDFILE /data/pgsql/ggs/dirrpt/diskg.dsc, purge
MAP ZWC.GGTEST, TARGET public.ggtest, COLMAP (COL1=col1,COL2=col2);
Create the replicat process, start it and verify if it is running
GGSCI (ggpgt) 8> add replicat rpos, NODBCHECKPOINT, exttrail /data/pgsql/ggs/dirdat/ep
REPLICAT added.
GGSCI (ggpgt) 9> start rpos
Sending START request to MANAGER ...
REPLICAT RPOS starting
GGSCI (ggpgt) 10> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING RPOS 00:00:00 00:00:00
GGSCI (ggpgt) 11> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING RPOS 00:00:00 00:00:02
GGSCI (ggpgt) 12> view report rpos
***********************************************************************
Oracle GoldenGate Delivery
Version 11.2.1.0.2 OGGCORE_11.2.1.0.2T3_PLATFORMS_120724.2205
Linux, x64, 64bit (optimized), PostgreSQL on Jul 25 2012 01:37:05
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
Starting at 2013-09-04 14:34:27
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Fri Jul 22 04:43:29 EDT 2011, Release 2.6.18-274.el5
Node: ggpgt
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 22305
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2013-09-04 14:34:27 INFO OGG-03035 Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
REPLICAT rpos
SOURCEDEFS /data/pgsql/ggs/dirdef/GGTEST.def
SETENV ( PGCLIENTENCODING = "UTF8" )
Set environment variable (PGCLIENTENCODING=UTF8)
SETENV (ODBCINI="/data/pgsql/ggs/odbc.ini" )
Set environment variable (ODBCINI=/data/pgsql/ggs/odbc.ini)
SETENV (NLS_LANG="AMERICAN_AMERICA.AL32UTF8")
Set environment variable (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
TARGETDB GG_Postgres, USERID zwc, PASSWORD ***
2013-09-04 14:34:27 INFO OGG-03036 Database character set identified as UTF-8. Locale: en_US.
2013-09-04 14:34:27 INFO OGG-03037 Session character set identified as UTF-8.
DISCARDFILE /data/pgsql/ggs/dirrpt/diskg.dsc, purge
MAP ZWC.GGTEST, TARGET public.ggtest, COLMAP (COL1=col1,CO