Question: the source machine os is solaris ,the mid machine os is linux , the target machine os is solaris,i want extract archive log file and pump trail file to target on mid machine , i check GoldenGate Reference Guide version 10.4 about TRANLOGOPTIONS, must set ARCHIVEDLOGONLY and LOGSOURCE PATHMAP , in my environment ,how to set LOGSOURCE PATHMAP ? Answer: There two primary things that need to be met when extracting the data remotely. 1. Endian order (How the bytes are stored) Big endian OS : AIX, HPUX, MVS, SOLARIS, S290 Little endian OS : LINUX, VMS, WINDOWS 2. Bit (32 or 64 bit). If your source is SOLARIS(Big Endian) and mid machine where archive logs resides as LINUX(Little Endian), then you cannot use LOGSOURCE as it violates the ENDIAN order. For exampel you can either have source and mid machine as solaris solaris or AIX ,HPUX or vice versa The general syntax to extract data from transaction logs which resides on a platform other than the one which hosts the database If you the source and mid machine are Solaris you can use the following syntax. TRANLOGOPTIONS, LOGSOURCE SOLARIS, PATHMAP Please refer Oracle GoldenGate Reference guide page 356 for the example
How to set LOGSOURCE PATHMAP on GoldenGate
原创
©著作权归作者所有:来自51CTO博客作者maclean_007的原创作品,请联系作者获取转载授权,否则将追究法律责任
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
How to set autocommit to 0
事物处理,Autocommit 变量的设置。
Mysql autocommit tra -
How to Set SMTP Address Template
如何设置SMTP地址模板
Exchange SMTP -
how to set password for listener.
<br />We can manage the listener started at remote machine via the lsnrc
authentication tcp service access oracle