Setting up a dedicated application server for golden gate
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