hi everyone - hoping someone can lead or point me in the direction to get Extract working again.
I installed OGG on a Windows 2008 Server, 11g Oracle db. the initial setup was a simple one table test to see if I could get the process to work.
below are the specs.
Source db:
EXTRACT:
ADD EXTRACT EX1, TRANLOG, BEGIN NOW
ADD EXTTRAIL g:/Oracle_gg/gg_src/dirdat/tr, EXTRACT EX1
EDIT PARAMS ex1:
EXTRACT ex1
userid ggs_owner, password ********
EXTTRAIL g:/oracle_gg/gg_src/dirdat/tr
ddl include mapped objname gui.*;
TABLE gui.usertable1;
PUMP:
ADD EXTRACT pump1, exttrailsource g:/Oracle_gg/gg_src/dirdat/tr, begin now
ADD RMTTRAIL g:/Oracle_gg/gg_src/dirdat/tr, extract pump1
EDIT PARAMS pump1:
EXTRACT pump1
USERID ggs_owner, PASSWORD ********
RMTHOST TargetHost, MGRPORT 7809
RMTTRAIL g:/Oracle_gg/gg_src/dirdat/tr
PASSTHRU
table gui.usertable1;
Target db:
add replicat rep1, exttrail g:/oracle_gg/gg_src/dirdat/tr, begin now
EDIT PARAMS rep1:
REPLICAT rep1
ASSUMETARGETDEFS
USERID ggs_owner, PASSWORD ********
discardfile g:/oracle_gg/gg_src/discard/rep1_discard.txt, append
DDL
map gui.*, target gui.*;
=====================================================================
with the above setup I inserted a new record into gui.usertable1 on source and then check the Target db, record was replicated correctly.
then I deleted record from source and delete replicated as well on Target. now I wanted to expand the testing to multiple tables so I changed the EXTRACT files as follows:
ggsci> ADD TRANDATA gui.* (supplemental logging enabled scrolled through all tables)
EXTRACT ex1
userid ggs_owner, password **********
EXTTRAIL g:/oracle_gg/gg_src/dirdat/tr
ddl include mapped objname gui.*;
TABLE gui.*;
EXTRACT pump1
USERID ggs_owner, PASSWORD **********
RMTHOST TargetHost, MGRPORT 7809
RMTTRAIL g:/Oracle_gg/gg_src/dirdat/tr
PASSTHRU
table gui.*;
Target db: Rep1 not changed
after these changes the EXTRACT/REPLICAT is not working. I attempted the same insert to the same table that worked in the initial setup and now that doesn't work, the message I get in the ggserror.log is:
2015-05-21 15:04:17 WARNING OGG-01842 Oracle GoldenGate Capture for Oracle, PUMP1.prm: CACHESIZE PER DYNAMIC DETERMINATION (32G) LESS THAN RECOMMENDED: 64G (64bit system)vm found: 48.47G
Check swap space. Recommended swap/extract: 128G (64bit system).
2015-05-21 15:04:17 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, PUMP1.prm: EXTRACT PUMP1 started.
2015-05-21 15:04:23 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, PUMP1.prm: Socket buffer size set to 27985 (flush size 27985).
2015-05-21 15:04:23 INFO OGG-01056 Oracle GoldenGate Capture for Oracle, PUMP1.prm: Recovery initialization completed for target file g:/Oracle_gg/gg_src/dirdat/tr000008, at RBA 1381, CSN 3143616053.
2015-05-21 15:04:23 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, PUMP1.prm: Output file g:/Oracle_gg/gg_src/dirdat/tr is using format RELEASE 11.2.
2015-05-21 15:04:23 INFO OGG-01026 Oracle GoldenGate Capture for Oracle, PUMP1.prm: Rolling over remote file g:/Oracle_gg/gg_src/dirdat/tr000009.
2015-05-21 16:38:25 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (Administrator): edit params ex1.
2015-05-21 16:39:10 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (Administrator): edit params pump1.
2015-05-22 09:09:16 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (Administrator): edit params ex1.
2015-05-22 09:09:47 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (Administrator): edit params pump1.
I also checked the SCN's on both databases and they do not match:
Source db: 3142791678
Target db: 3143756991
do the SCN's need to match in order to work. I would need to do another export/import if that is the case. when changes are made to params files do I need to stop the processes first , Stop EXTRACT EX1 or can they be changed while still RUNNING.
thanks in advance for any insight, tips and help.