Forum Stats

  • 3,855,199 Users
  • 2,264,473 Discussions
  • 7,905,928 Comments

Discussions

Setting up a dedicated application server for golden gate

MtJulietDBA
MtJulietDBA Member Posts: 3 Blue Ribbon
edited Dec 6, 2010 3:18AM in GoldenGate
Has anyone setup a dedicated server for Golden Gate replication?

I started configuring my GG-replication server and have a couple questions that I have not figured out how to work around. Hopefully someone he has done this and can assist.

Here is what I am doing:

I have my application server - APPSRV1
I have DatabaseA (11.1.0.7) which runs on DBSERVER1
And DatabaseB (10.2.0.4) which runs on DBSERVER2

I have created my extract and replicat on APPSRV1 and have the manager for each both running on different ports.

Extract:
PORT 7809
USERID [email protected], PASSWORD manager
PURGEOLDEXTRACTS /export/apps/oracle/ggate/dev/11.1/DataA/dirdat, USECHECKPOINTS
Replicat:
PORT 7810
USERID [email protected], PASSWORD manager
PURGEOLDEXTRACTS /export/apps/ggate/dev/11.1/DataB/dirdat, USECHECKPOINTS

And My PARAMS for My extract and replicat

DBLOGIN USERID [email protected], PASSWORD manager

DELETE EXTRACT SATMP
ADD EXTRACT SATMP, SOURCEISTABLE
EDIT PARAMS SATMP

EXTRACT SATMP
SOURCEISTABLE
SETENV (ORACLE_HOME=/app001/oracle/11107/software)
USERID [email protected], PASSWORD manager
RMTHOST APPSRV1, MGRPORT 7810
RMTFILE ./dirdat/in, MAXFILES 999999, megabytes 500
TABLE SCOTT.EMP;

start ext SATMP

#################

DBLOGIN USERID [email protected], PASSWORD manager
DELETE REP AWTMP
ADD REPLICAT AWTMP, EXTTRAIL ./dirdat/in, nodbcheckpoint

EDIT PARAMS AWTMP

REPLICAT AWTMP
SETENV (ORACLE_HOME=/app001/oracle/10204/software)
USERID [email protected], PASSWORD manager
ASSUMETARGETDEFS
MAP SCOTT.EMP, TARGET BRENDA.EMP;

START REP AWTMP

All of this worked fine...and the data was loaded. However, when I go to start the real-time replication, it is not working so favorably for me.

DBLOGIN USERID [email protected], PASSWORD manager
ADD TRANDATA SCOTT.EMP

ADD EXTRACT SAREAL TRANLOG, BEGIN NOW
ADD RMTTRAIL /export/apps/ggate/dev/11.1/DataB/dirdat/sa, EXTRACT SAREAL, MEGABYTES 20

alter ext SAREAL, begin now

edit params SAREAL

EXTRACT SAREAL
SETENV (ORACLE_HOME=/app001/oracle/11107/software)
USERID [email protected], PASSWORD manager
RMTHOST APPSRV1, MGRPORT 7810
RMTTRAIL /export/apps/ggate/dev/11.1/DataB/dirdat/sa
TABLE SCOTT.EMP;

#########################

ADD REPLICAT AWREAL, EXTTRAIL /export/apps/ggate/dev/11.1/DataB/dirdat/sa
EDIT PARAMS AWREAL

REPLICAT AWREAL
SETENV (ORACLE_HOME=/app001/oracle/10204/software)
USERID [email protected], PASSWORD manager
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/AWREAL.dsc, PURGE
MAP SCOTT.EMP, TARGET BRENDA.EMP;

But when I go over to start the EXTRACT, I get the following error message.

2010-12-03 12:21:36 ERROR OGG-00446 error 2 (No such file or directory) opening redo log /ora001/oradata/DataA/redo_DataA_05a.log for sequence 2711Not able to establish initial position for begin time 2010-12-03 12:20:57.

2010-12-03 12:21:36 ERROR OGG-01668 PROCESS ABENDING.

Is there not a way for me to run the GG extract and replicat processes from a remote server other than the servers where the databases reside?

Thank you

Answers

  • Hi

    Mount log files on platform that you have GoldenGate installed and tell GoldenGate extract where the logs are:

    You need to say what platform is this logs from in extract parameter file:
    TRANLOGOPTIONS LOGSOURCE <platform>
    Page 370 of reference guide.

    Where are they:
    TRANLOGOPTIONS PATHMAP <NFS mount point> <log path>
    Page 372 of reference guide.

    Cheers
This discussion has been closed.