打开目标端复制进程报如下错误 :
OGG-00664 Oracle GoldenGate Delivery for Oracle, OCI Error Flushing database inbound server,
(status = 26815-ORA-26815: Error from Apply Network Receiver for Apply and Capture “replicat”.
Posted on January 3, 2015, updated on January 3, 2015 by admin
mos上面解决方案如下:
There were two solutions,
1.Remove the UPDATERECORDFORMAT COMPACT parameter from the Integrated Extract Parameter file.
2.The Other solution was to Downgrade the Replicat from Integrated Mode to Classic or Regular Mode.
我参考第一个方法 :
1。修改参数
GGSCI (rs) 2> edit params rep1
replicat rep1
setenv (ORACLE_SID=jscn110)
setenv (ORACLE_HOME="/u01/app/oracle/product/11.2.0/db_1")
setenv (NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK")
userid ggs, password ggs
--DBOPTIONS INTEGRATEDPARAMS(parallelism 10)
DDL INCLUDE MAPPED
map zg.acct_item_0 ,target zg.acct_item_0;
map zg.acct_item_1 ,target zg.acct_item_1;
map zg.acct_item_201604 ,target zg.acct_item_201604;
2.GGSCI (rs) 3> dblogin userid ggs ,password ggs
Successfully logged into database.
3.delete rep1;
4.add checkpointtable ggs.rep1_chkpt --添加 checkpointtable
add replicat rep1 , exttrail /u01/app/oradata/trail/bs checkpointtable ggs.rep1_chkpt--添加复制队列
exttrail该路径在源端查看 pump进程
extract pump1
setenv (ORACLE_SID=birep1)
setenv (ORACLE_HOME="/opt/oracle/products/11.2.0")
setenv (NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK")
userid ggs, password ggs
ReportCount Every 30 Minutes, Rate
DDL INCLUDE MAPPED
Report at 01:00
ReportRollover at 01:15
rmthost 172.31.86.110, mgrport 7809
rmttrail /u01/app/oradata/trail/bs ----查看exttrail
table zg.acct_item_0;
table zg.acct_item_1;
5.start replicat rep1,aftercsn 14898216691596--打开复制进程
6.info all--查看进程状态
GGSCI (rs as ggs@jscn110) 4> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP1 00:00:00 00:00:00
上面六步操作完 进程正常
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31134212/viewspace-2093348/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31134212/viewspace-2093348/