Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Setting up a dedicated application server for golden gate

MtJulietDBADec 3 2010 — edited Dec 6 2010
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 ggadm@DatabaseA, PASSWORD manager
PURGEOLDEXTRACTS /export/apps/oracle/ggate/dev/11.1/DataA/dirdat, USECHECKPOINTS
Replicat:
PORT 7810
USERID ggadm@DatabaseB, PASSWORD manager
PURGEOLDEXTRACTS /export/apps/ggate/dev/11.1/DataB/dirdat, USECHECKPOINTS

And My PARAMS for My extract and replicat

DBLOGIN USERID ggadm@DatabaseA, PASSWORD manager

DELETE EXTRACT SATMP
ADD EXTRACT SATMP, SOURCEISTABLE
EDIT PARAMS SATMP

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

start ext SATMP

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

DBLOGIN USERID ggadm@DatabaseB, 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 ggadm@DatabaseB, 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 ggadm@DatabaseA, 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 ggadm@DatabaseA, 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 ggadm@DatabaseB, 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 3 2011
Added on Dec 3 2010
1 comment
301 views