GoldenGate INITIAL LOAD setup
On Source: Unzip the GG Software and Perform the installation & Configuration
[oracle@sourcehost]/data # unzip ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip
Archive: ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip
inflating: fbo_ggs_Linux_x64_ora11g_64bit.tar
inflating: OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdf
inflating: Oracle GoldenGate 11.2.1.0.1 README.txt
inflating: Oracle GoldenGate 11.2.1.0.1 README.doc
[oracle@sourcehost]/data # tar -xvf ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip
[oracle@sourcehost]/data/ggate # ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI (sourcehost) 1> create subdirs
Creating subdirectories under current directory /data/ggate
Parameter files /data/ggate/dirprm: already exists
Report files /data/ggate/dirrpt: created
Checkpoint files /data/ggate/dirchk: created
Process status files /data/ggate/dirpcs: created
SQL script files /data/ggate/dirsql: created
Database definitions files /data/ggate/dirdef: created
Extract data files /data/ggate/dirdat: created
Temporary files /data/ggate/dirtmp: created
Stdout files /data/ggate/dirout: created
On Target: Unzip the GG Software and Perform the installation & Configuration
[oracle@targethost]/data # unzip ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip
Archive: ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip
inflating: fbo_ggs_Linux_x64_ora11g_64bit.tar
inflating: OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdf
inflating: Oracle GoldenGate 11.2.1.0.1 README.txt
inflating: Oracle GoldenGate 11.2.1.0.1 README.doc
[oracle@targethost]/data # tar -xvf ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip
[oracle@targethost]/data/ggate # ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI (targethost) 1> create subdirs
Creating subdirectories under current directory /data/ggate
Parameter files /data/ggate/dirprm: already exists
Report files /data/ggate/dirrpt: created
Checkpoint files /data/ggate/dirchk: created
Process status files /data/ggate/dirpcs: created
SQL script files /data/ggate/dirsql: created
Database definitions files /data/ggate/dirdef: created
Extract data files /data/ggate/dirdat: created
Temporary files /data/ggate/dirtmp: created
Stdout files /data/ggate/dirout: created
On Source: Prepare Source Database for GG Replication
Note : Ensure The database is in archive log mode
create tablespace ggs_data datafile '/data/GGS/Base/ggs_data01.dbf' size 200m;
create user ggsowner identified by ggsowner default tablespace ggs_data temporary tablespace temp;
grant connect,resource to ggs_owner;
grant select any dictionary, select any table to ggsowner;
grant create table to ggsowner;
grant flashback any table to ggsowner;
grant execute on dbms_flashback to ggsowner;
grant execute on utl_file to ggsowner;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
alter session set recyclebin=OFF;
On Source: Configure DDL Replication on Source
@marker_setup
@ddl_setup
@role_setup
grant ggs_ggsuser_role to ggsowner;
@ddl_enable
@ddl_pin ggsowner
On Target: Prepare Source Database for GG Replication
Ensure The database is in archive log mode
create tablespace ggs_data datafile '/data/GGT/Base/ggs_data01.dbf' size 200m;
create user ggsowner identified by ggsowner default tablespace ggs_data temporary tablespace temp;
grant connect,resource,dba to ggsowner;
grant select any dictionary, select any table to ggsowner;
grant create table to ggsowner;
grant flashback any table to ggsowner;
grant execute on dbms_flashback to ggsowner;
grant execute on utl_file to ggsowner;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
alter session set recyclebin=OFF;
grant create any view to ggsowner;
grant create any procedure to ggsowner;
grant create any sequence to ggsowner;
grant create any index to ggsowner;
grant create any trigger to ggsowner;
grant create any view to ggsowner;
grant create any sequence to ggsowner;
grant create any table to ggsowner;
On Target: Configure DDL Replication on Target Database
@marker_setup
@ddl_setup
@role_setup
grant ggs_ggsuser_role to ggsowner;
@ddl_enable
@ddl_pin ggsowner
Host Information
GGSCI (testdb1.sample.com) 21> sh cat /etc/hosts
# Public
192.168.1.141 testdb1.sample.com testdb1 --- source
192.168.1.108 testdb2.sample.com testdb2 -- target
On Source: Configure Manager Process
cd /data/ggate
./ggsci
info all
EDIT PARAMS MGR
Copy the below to mgr param file
######## Copy following to the extract param file ########
PORT 7809
USERID ggsowner, PASSWORD ggsowner
PURGEOLDEXTRACTS /u01/app/oracle/goldengate/dirdat/ex, USECHECKPOINTS
ACCESSRULE, PROG *, IPADDR 192.168.1.108, ALLOW
note : for security purpose below line added with target ipaddress
ACCESSRULE, PROG *, IPADDR 192.168.1.108, ALLOW
On Source: start the manager process
start manager
info all
On Target : Configure Manager Process & start the mgr
cd /data/ggate
./ggsci
info all
EDIT PARAMS MGR
PORT 7809
USERID ggs_owner, PASSWORD ggs_owner
PURGEOLDEXTRACTS /u01/app/oracle/goldengate/dirdat/rt, USECHECKPOINTS
ACCESSRULE, PROG *, IPADDR 192.168.1.141, ALLOW
note : ACCESSRULE, PROG *, IPADDR 192.168.1.141, ALLOW
used to accept the connection from source
On Target: start the manager process
start manager
info all
On Source: & On Target: create a user and dummy table: but used corect table here
create user ggsowner identified by ggsowner default tablespace users;
alter user ggsowner quota unlimited on users;
create table ggsowner.first as select * from dba_objects;
Table created.
Example 1: Configure the Extract / Replicat for Initial Load
Initial load is something that data is initiall loaded when the target is not having data
On Source: Configure Extract Process
cd /data/ggate
./ggsci
ADD EXTRACT firstext, SOURCEISTABLE
EDIT PARAMS firstext
note: SOURCEISTABLE :: used for intial run
Copy following to the extract param file
EXTRACT firstext
USERID ggsowner, PASSWORD ggsowner
RMTHOST 192.168.1.108, MGRPORT 7809
RMTTASK replicat, GROUP firstrep
TABLE GGS_OWNER.first;
On Target: Configure Replicat Process
cd /data/ggate
./ggsci
ADD REPLICAT firstrep, SPECIALRUN
note : specialrun : used for first for the table initial load
EDIT PARAMS firstrep
######## Copy following to the extract param file ########
REPLICAT firstrep
USERID ggsowner, PASSWORD ggsowner
ASSUMETARGETDEFS
MAP GGS_OWNER.first, TARGET GGS_OWNER.first;
On Source: Start Extract./ggsci
start extract firstext
info all
On Target: Start Replicat./ggsci
start extract firstrep
info all
Peform the check on data
On Source: select count(*) from ggsowner.first;
On Target: select count(*) from ggsowner.first;
On Source: View Report of Replicat./ggsci
GGSCI (sourcedb) 27> info extract firstext, detail
EXTRACT FIRSTEXT Last Started 2016-06-23 15:39 Status STOPPED
Checkpoint Lag Not Available
Log Read Checkpoint Table GGS_OWNER.FIRST
2016-06-23 15:39:37 Record 71530
Task SOURCEISTABLE
Extract Source Begin End
Database 2016-06-23 15:39 2016-06-23 15:39
Database * Initialized * First Record
Current directory /u01/app/oracle/goldengate
Report file /u01/app/oracle/goldengate/dirrpt/FIRSTEXT.rpt
Parameter file /u01/app/oracle/goldengate/dirprm/firstext.prm
Checkpoint file /u01/app/oracle/goldengate/dirchk/FIRSTEXT.cpe
Process file /u01/app/oracle/goldengate/dirpcs/FIRSTEXT.pce
Error log /u01/app/oracle/goldengate/ggserr.log
On Target: View Report of Extract ./ggsci
GGSCI (testdb2.sample.com) 1> info replicat firstrep, detail
REPLICAT FIRSTREP Initialized 2016-06-23 04:48 Status STOPPED
Checkpoint Lag 00:00:00 (updated 12:25:10 ago)
Log Read Checkpoint Not Available
Task SPECIALRUN
Current Log BSN value: (requires database login)
Last Committed Transaction CSN value: (requires database login)
Extract Source Begin End
Not Available * Initialized * First Record
Current directory /u01/app/oracle/goldengate
Report file /u01/app/oracle/goldengate/dirrpt/FIRSTREP.rpt
Parameter file /u01/app/oracle/goldengate/dirprm/firstrep.prm
Checkpoint file /u01/app/oracle/goldengate/dirchk/FIRSTREP.cpr
Process file /u01/app/oracle/goldengate/dirpcs/FIRSTREP.pcr
Error log /u01/app/oracle/goldengate/ggserr.log
Compare the count on table from On Source & On Target
target
SQL> select count(1) from ggs_owner.first;
COUNT(1)
----------
71530
target
SQL> select count(1) from ggs_owner.first;
COUNT(1)
----------
71530
END OF EXAMPLE1 INITIAL LOAD
sample code file
GGSCI (sourcedb) 1> info extract firstext, detail
EXTRACT FIRSTEXT Last Started 2016-06-23 17:11 Status STOPPED
Checkpoint Lag Not Available
Log Read Checkpoint Table GGS_OWNER.FIRST
2016-06-23 17:11:23 Record 71530
Task SOURCEISTABLE
Extract Source Begin End
Database 2016-06-23 17:11 2016-06-23 17:11
Database 2016-06-23 15:39 2016-06-23 15:39
Database * Initialized * First Record
Current directory /u01/app/oracle/goldengate
Report file /u01/app/oracle/goldengate/dirrpt/FIRSTEXT.rpt
Parameter file /u01/app/oracle/goldengate/dirprm/firstext.prm
Checkpoint file /u01/app/oracle/goldengate/dirchk/FIRSTEXT.cpe
Process file /u01/app/oracle/goldengate/dirpcs/FIRSTEXT.pce
Error log /u01/app/oracle/goldengate/ggserr.log
ggsci>view report firstext -- only few lines taken
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Thu May 12 11:03:55 UTC 2016, Release 3.10.0-327.18.2.el7.x86_64
Node: testdb1.sample.com
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: 16853
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2016-06-23 15:39:10 INFO OGG-03059 Operating system character set identified as UTF-8.
2016-06-23 15:39:10 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
EXTRACT firstext
USERID ggs_owner, PASSWORD ***
2016-06-23 15:39:10 INFO OGG-03522 Setting session time zone to source database time zone 'GMT'.
RMTHOST 192.168.1.108, MGRPORT 7809
RMTTASK replicat, GROUP firstrep
TABLE GGS_OWNER.first;
2016-06-23 15:39:10 WARNING OGG-06439 No unique key is defined for table FIRST. All viable columns will be used to represent the key, but may
not guarantee uniqueness. KEYCOLS may be used to define the key.
2016-06-23 15:39:10 INFO OGG-06509 Using the following key columns for source table GGS_OWNER.FIRST: OWNER, OBJECT_NAME, SUBOBJECT_NAME, O
BJECT_ID, DATA_OBJECT_ID, OBJECT_TYPE, CREATED, LAST_DDL_TIME, TIMESTAMP, STATUS, TEMPORARY, GENERATED, SECONDARY, NAMESPACE, EDITION_NAME.
2016-06-23 15:39:10 INFO OGG-01851 filecaching started: thread ID: 140580923373312.
2016-06-23 15:39:10 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/app/oracle/goldengate/dirtmp.
CACHEMGR virtual memory values (may have been adjusted)
CACHEPAGEOUTSIZE (default): 8M
PROCESS VM AVAIL FROM OS (min): 128G
CACHESIZEMAX (strict force to disk): 96G
Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "WE8MSWIN1252"
2016-06-23 15:39:16 INFO OGG-02911 Processing table GGS_OWNER.FIRST.
2016-06-23 15:39:16 INFO OGG-02911 Processing table GGS_OWNER.FIRST.
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Report at 2016-06-23 15:39:37 (activity since 2016-06-23 15:39:10)
Output to firstrep:
From Table GGS_OWNER.FIRST:
# inserts: 71530
# updates: 0
# deletes: 0
# discards: 0
REDO Log Statistics
Bytes parsed 0
Bytes output 19708173
On taret
========
ggsci>view report firstrep --- take required line
***********************************************************************
** Run Time Messages **
***********************************************************************
2016-06-23 15:39:16 INFO OGG-03522 Setting session time zone to source database time zone 'GMT'.
2016-06-23 15:39:16 WARNING OGG-02760 ASSUMETARGETDEFS is ignored because trail file contains table definitions.
2016-06-23 15:39:16 INFO OGG-06505 MAP resolved (entry GGS_OWNER.first): MAP "GGS_OWNER"."FIRST", TARGET GGS_O
WNER.first.
2016-06-23 15:39:23 WARNING OGG-06439 No unique key is defined for table FIRST. All viable columns will be used t
o represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2016-06-23 15:39:23 INFO OGG-02756 The definition for table GGS_OWNER.FIRST is obtained from the trail file.
2016-06-23 15:39:23 INFO OGG-06511 Using following columns in default map by name: OWNER, OBJECT_NAME, SUBOBJE
CT_NAME, OBJECT_ID, DATA_OBJECT_ID, OBJECT_TYPE, CREATED, LAST_DDL_TIME, TIMESTAMP, STATUS, TEMPORARY, GENERATED, S
ECONDARY, NAMESPACE, EDITION_NAME.
2016-06-23 15:39:23 INFO OGG-06510 Using the following key columns for target table GGS_OWNER.FIRST: OWNER, OB
JECT_NAME, SUBOBJECT_NAME, OBJECT_ID, DATA_OBJECT_ID, OBJECT_TYPE, CREATED, LAST_DDL_TIME, TIMESTAMP, STATUS, TEMPO
RARY, GENERATED, SECONDARY, NAMESPACE, EDITION_NAME.
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Report at 2016-06-23 15:39:42 (activity since 2016-06-23 15:39:23)
From Table GGS_OWNER.FIRST to GGS_OWNER.FIRST:
# inserts: 71530
# updates: 0
# deletes: 0
# discards: 0
CACHE OBJECT MANAGER statistics
CACHE MANAGER VM USAGE
vm current = 0 vm anon queues = 0
vm anon in use = 0 vm file = 0
vm used max = 0 ==> CACHE BALANCED
CACHE CONFIGURATION
cache size = 2G cache force paging = 3.41G
buffer min = 64K buffer max (soft) = 4M
pageout eligible size = 4M
================================================================================
RUNTIME STATS FOR SUPERPOOL
CACHE Transaction Stats
trans active = 0 max concurrent = 0
non-zero total = 0 trans total = 0
CACHE File Caching
filecache rqsts = 0 bytes to disk = 0
file retrieves = 0 objs filecached = 0
queue entries = 0 queue processed = 0
queue entry not needed = 0 queue not signaled = 0
fc requesting obj = 0
CACHE MANAGEMENT
buffer links = 0 anon gets = 0
forced unmaps = 0 cnnbl try = 0
cached out = 0
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0
Cached Transaction Size Distribution
0: 0
< 4K: 0
4K: 0 0 | 16K: 0 0
64K: 0 0 | 256K: 0 0
1M: 0 0 | 4M: 0 0
16M: 0 0 | 64M: 0 0
256M: 0 0 | 1G: 0 0
4G: 0 0 | 16G: 0 0
64G: 0 0 | 256G: 0 0
1T: 0 0 | 4T: 0 0
16T: 0 0 | 64T: 0 0
256T: 0 0 |1024T: 0 0
================================================================================
CUMULATIVE STATS FOR SUPERPOOL (PREVIOUS RUNS ONLY)
CACHE Transaction Stats
trans active = 0 max concurrent = 0
non-zero total = 0 trans total = 0
CACHE File Caching
filecache rqsts = 0 bytes to disk = 0
file retrieves = 0 objs filecached = 0
queue entries = 0 queue processed = 0
queue entry not needed = 0 queue not signaled = 0
fc requesting obj = 0
CACHE MANAGEMENT
buffer links = 0 anon gets = 0
forced unmaps = 0 cnnbl try = 0
cached out = 0
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0
Cached Transaction Size Distribution
0: 0
< 4K: 0
4K: 0 0 | 16K: 0 0
64K: 0 0 | 256K: 0 0
1M: 0 0 | 4M: 0 0
16M: 0 0 | 64M: 0 0
256M: 0 0 | 1G: 0 0
4G: 0 0 | 16G: 0 0
64G: 0 0 | 256G: 0 0
1T: 0 0 | 4T: 0 0
16T: 0 0 | 64T: 0 0
256T: 0 0 |1024T: 0 0
QUEUE Statistics
num queues = 11 q hits = 0 q misses = 0
queue size q hits curlen maxlen cannibalized
0 64K 0 0 0 0
1 128K 0 0 0 0
2 256K 0 0 0 0
3 512K 0 0 0 0
4 1M 0 0 0 0
5 2M 0 0 0 0
6 4M 0 0 0 0
7 8M 0 0 0 0
8 16M 0 0 0 0
9 32M 0 0 0 0
10 64M 0 0 0 0
================================================================================
RUNTIME STATS FOR CACHE POOL #0
POOL INFO group: firstrep id: p12372_BLOB
trans active = 0 trans concurrent (max) = 0
trans total = 0 (0 )
flag = 0x00000030
last error = (0=<none>)
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0
================================================================================
CUMULATIVE STATS FOR CACHE POOL #0 (PREVIOUS RUNS ONLY)
POOL INFO group: firstrep id: p12372_BLOB
trans active = 0 trans concurrent (max) = 0
trans total = 0 (0 )
flag = 0x00000030
last error = (0=<none>)
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0
on source ggserr.log
=================
2016-06-23 15:39:10 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT FIRSTEXT starting.
2016-06-23 15:39:10 INFO OGG-01017 Oracle GoldenGate Capture for Oracle, firstext.prm: Wildcard resolution set to IMMEDIATE bec ause SOURCEISTABLE is used.
2016-06-23 15:39:10 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, firstext.prm: EXTRACT FIRSTEXT starting.
2016-06-23 15:39:10 INFO OGG-03059 Oracle GoldenGate Capture for Oracle, firstext.prm: Operating system character set identifie d as UTF-8.
2016-06-23 15:39:10 INFO OGG-02695 Oracle GoldenGate Capture for Oracle, firstext.prm: ANSI SQL parameter syntax is used for pa rameter parsing.
2016-06-23 15:39:10 INFO OGG-03522 Oracle GoldenGate Capture for Oracle, firstext.prm: Setting session time zone to source data base time zone 'GMT'.
2016-06-23 15:39:10 WARNING OGG-06439 Oracle GoldenGate Capture for Oracle, firstext.prm: No unique key is defined for table FIRST . All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2016-06-23 15:39:10 INFO OGG-06509 Oracle GoldenGate Capture for Oracle, firstext.prm: Using the following key columns for sour ce table GGS_OWNER.FIRST: OWNER, OBJECT_NAME, SUBOBJECT_NAME, OBJECT_ID, DATA_OBJECT_ID, OBJECT_TYPE, CREATED, LAST_DDL_TIME, TIMESTA MP, STATUS, TEMPORARY, GENERATED, SECONDARY, NAMESPACE, EDITION_NAME.
2016-06-23 15:39:10 INFO OGG-01851 Oracle GoldenGate Capture for Oracle, firstext.prm: filecaching started: thread ID: 14058092 3373312.
2016-06-23 15:39:10 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, firstext.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/app/oracle/goldengate/dirtmp.
2016-06-23 15:39:10 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, firstext.prm: EXTRACT FIRSTEXT started.
2016-06-23 15:39:16 INFO OGG-02911 Oracle GoldenGate Capture for Oracle, firstext.prm: Processing table GGS_OWNER.FIRST.
2016-06-23 15:39:37 INFO OGG-00991 Oracle GoldenGate Capture for Oracle, firstext.prm: EXTRACT FIRSTEXT stopped normally.
2016-06-23 15:41:43 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
On target ggserr.log
================
2016-06-23 15:34:10 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start replicat firstrep.
2016-06-23 15:34:10 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168.1.108]:53932 (START REPLICAT FIRSTREP ).
2016-06-23 15:34:10 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #7).
2016-06-23 15:34:10 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT FIRSTREP starting.
2016-06-23 15:34:10 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, firstrep.prm: REPLICAT FIRSTREP starting.
2016-06-23 15:34:10 WARNING OGG-02904 Oracle GoldenGate Delivery for Oracle, firstrep.prm: Replication of PARTIAL XML containing NCHAR/NVARCHAR/NCLOB data may cause divergence.
2016-06-23 15:34:10 INFO OGG-03059 Oracle GoldenGate Delivery for Oracle, firstrep.prm: Operating system character set identified as UTF-8.
2016-06-23 15:34:10 INFO OGG-02695 Oracle GoldenGate Delivery for Oracle, firstrep.prm: ANSI SQL parameter syntax is used for parameter parsing.
2016-06-23 15:34:10 WARNING OGG-06453 Oracle GoldenGate Delivery for Oracle, firstrep.prm: DBOPTIONS SUPPRESSTRIGGERS is not supported for the RDBMS version you are using.
2016-06-23 15:34:10 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, firstrep.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/app/oracle/goldengate/dirtmp.
2016-06-23 15:34:10 WARNING OGG-05673 Oracle GoldenGate Delivery for Oracle, firstrep.prm: CSN-based duplicate suppression is disabled because there is no checkpoint table for this Replicat.
2016-06-23 15:34:10 ERROR OGG-00446 Oracle GoldenGate Delivery for Oracle, firstrep.prm: .
2016-06-23 15:34:10 ERROR OGG-02161 Oracle GoldenGate Delivery for Oracle, firstrep.prm: Failed to retrieve the trail file begin checkpoint position.
2016-06-23 15:34:10 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, firstrep.prm: PROCESS ABENDING.
2016-06-23 15:39:10 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host [192.168.1.141]:30961 (START REPLICAT FIRSTREP CPU -1 PRI -1 PARAMS ).
2016-06-23 15:39:10 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #1).
2016-06-23 15:39:10 INFO OGG-01025 Oracle GoldenGate Delivery for Oracle: REPLICAT task started by manager (port 7819).
2016-06-23 15:39:10 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from RMTTASK on host [::1]:20445 (REPORT 12372 7819).
2016-06-23 15:39:10 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #1).
2016-06-23 15:39:10 INFO OGG-00973 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started replicat task process (Port 7819).
2016-06-23 15:39:15 INFO OGG-01229 Oracle GoldenGate Delivery for Oracle: Connected to testdb1.sample.com:33326.
2016-06-23 15:39:15 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, firstrep.prm: REPLICAT FIRSTREP starting.
2016-06-23 15:39:15 WARNING OGG-02904 Oracle GoldenGate Delivery for Oracle, firstrep.prm: Replication of PARTIAL XML containing NCHAR/NVARCHAR/NCLOB data may cause divergence.
2016-06-23 15:39:15 INFO OGG-03059 Oracle GoldenGate Delivery for Oracle, firstrep.prm: Operating system character set identified as UTF-8.
2016-06-23 15:39:15 INFO OGG-02695 Oracle GoldenGate Delivery for Oracle, firstrep.prm: ANSI SQL parameter syntax is used for parameter parsing.
2016-06-23 15:39:16 WARNING OGG-06453 Oracle GoldenGate Delivery for Oracle, firstrep.prm: DBOPTIONS SUPPRESSTRIGGERS is not supported for the RDBMS version you are using.
2016-06-23 15:39:16 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, firstrep.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/app/oracle/goldengate/dirtmp.
2016-06-23 15:39:16 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, firstrep.prm: REPLICAT FIRSTREP started.
2016-06-23 15:39:16 INFO OGG-03522 Oracle GoldenGate Delivery for Oracle, firstrep.prm: Setting session time zone to source database time zone 'GMT'.
2016-06-23 15:39:16 WARNING OGG-02760 Oracle GoldenGate Delivery for Oracle, firstrep.prm: ASSUMETARGETDEFS is ignored because trail file contains table definitions.
2016-06-23 15:39:16 INFO OGG-06505 Oracle GoldenGate Delivery for Oracle, firstrep.prm: MAP resolved (entry GGS_OWNER.first): MAP "GGS_OWNER"."FIRST", TARGET GGS_OWNER.first.
2016-06-23 15:39:23 WARNING OGG-06439 Oracle GoldenGate Delivery for Oracle, firstrep.prm: No unique key is defined for table FIRST. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2016-06-23 15:39:23 INFO OGG-02756 Oracle GoldenGate Delivery for Oracle, firstrep.prm: The definition for table GGS_OWNER.FIRST is obtained from the trail file.
2016-06-23 15:39:23 INFO OGG-06511 Oracle GoldenGate Delivery for Oracle, firstrep.prm: Using following columns in default map by name: OWNER, OBJECT_NAME, SUBOBJECT_NAME, OBJECT_ID, DATA_OBJECT_ID, OBJECT_TYPE, CREATED, LAST_DDL_TIME, TIMESTAMP, STATUS, TEMPORARY, GENERATED, SECONDARY, NAMESPACE, EDITION_NAME.
2016-06-23 15:39:23 INFO OGG-06510 Oracle GoldenGate Delivery for Oracle, firstrep.prm: Using the following key columns for target table GGS_OWNER.FIRST: OWNER, OBJECT_NAME, SUBOBJECT_NAME, OBJECT_ID, DATA_OBJECT_ID, OBJECT_TYPE, CREATED, LAST_DDL_TIME, TIMESTAMP, STATUS, TEMPORARY, GENERATED, SECONDARY, NAMESPACE, EDITION_NAME.
2016-06-23 15:39:42 INFO OGG-00994 Oracle GoldenGate Delivery for Oracle, firstrep.prm: REPLICAT FIRSTREP stopped normally.
2016-06-23 15:41:31 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
on target db
==========
GGSCI (targetdb) 3> info replicat firstrep, detail
REPLICAT FIRSTREP Initialized 2016-06-23 04:48 Status STOPPED
Checkpoint Lag 00:00:00 (updated 12:33:49 ago)
Log Read Checkpoint Not Available
Task SPECIALRUN
Current Log BSN value: (requires database login)
Last Committed Transaction CSN value: (requires database login)
Extract Source Begin End
Not Available * Initialized * First Record
Current directory /u01/app/oracle/goldengate
Report file /u01/app/oracle/goldengate/dirrpt/FIRSTREP.rpt
Parameter file /u01/app/oracle/goldengate/dirprm/firstrep.prm
Checkpoint file /u01/app/oracle/goldengate/dirchk/FIRSTREP.cpr
Process file /u01/app/oracle/goldengate/dirpcs/FIRSTREP.pcr
Error log /u01/app/oracle/goldengate/ggserr.log
