Oracle GoldenGate for Oracle 11g to PostgreSQL 9.2.4 Configuration(八)
L2=col2);
2013-09-04 14:34:27 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:
/data/pgsql/ggs/dirtmp.
CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE: 2G
CACHEPAGEOUTSIZE (normal): 8M
PROCESS VM AVAIL FROM OS (min): 4G
CACHESIZEMAX (strict force to disk): 3.41G
Database Version:
PostgreSQL
Version 09.02.0004
ODBC Version 03.52.0000
Driver Information:
GGpsql25.so
Version 06.10.0068 (B0059, U0030)
ODBC Version 03.52
***********************************************************************
** Run Time Messages **
***********************************************************************
Opened trail file /data/pgsql/ggs/dirdat/ep000000 at 2013-09-04 14:34:27
Testing the configuration
Finally we can now test the whole set up and insert a record into the Oracle database
[oracle@ggos ~]$ sqlplus zwc
SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 4 22:38:16 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> insert into ggtest values(1,'Hi Zhong Weicheng');
1 row created.
SQL> commit;
Commit complete.
SQL> select * from ggtest;
COL1 COL2
---------- --------------------------------------------------
1 Hi Zhong Weicheng
Check with a PostgreSQL tool if our newly inserted record is replicated
[postgres@ggpgt ggs]$ psql -U zwc -d repdb
psql (9.2.4)
Type "help" for help.
repdb=> select * from ggtest;
col1 | col2
------+-------------------
1 | Hi Zhong Weicheng
(1 row)
repdb=>
Check with GoldenGate tool logdump
[postgres@ggpgt ggs]$ ./logdump
Oracle GoldenGate Log File Dump Utility
Version 11.2.1.0.2 OGGCORE_11.2.1.0.2T3_PLATFORMS_120724.2205
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
Logdump 1 >open /data/pgsql/ggs/dirdat/ep000000
Current LogTrail is /data/pgsql/ggs/dirdat/ep000000
Logdump 2 >ghdr ON
Logdump 3 >headertoken on
Logdump 4 >usertoken on
Logdump 5 >detail on
Logdump 6 >detail data
Logdump 7 >n
TokenID x46 'F' Record Header Info xff80 Length 1050
TokenID x30 '0' TrailInfo Info x00 Length 429
TokenID x31 '1' MachineInfo Info x00 Length 102
TokenID x32 '2' DatabaseInfo Info x00 Length 357
TokenID x33 '3' ProducerInfo Info x00 Length 126
TokenID x34 '4' ContinunityInfo Info x00 Length 8
TokenID x5a 'Z' Record Trailer Info xff80 Length 1050
2013/09/04 22:07:34.254.624 FileHeader Len 1042 RBA 0
Name: *FileHeader*
3000 01ad 3000 0008 4747 0d0a 544c 0a0d 3100 0002 | 0...0...GG..TL..1...
0003 3200 0004 2000 0000 3300 0008 02f2 0bc2 c871 | ..2... ...3........q
2820 3400 0023 0021 7572 693a 6767 6f73 3a3a 7530 | ( 4..