Data are not being applied at destination side
611085May 29 2008 — edited May 30 2008Hi all,
I have implemented real time streams replication(not archive log based downstream replication).
source:9.2.0.8.0
destination:10.2.0.2.0
Capture and propagation is working fine. DBlinks are also fine. Apply process is running , but data are not being applied in destination side.
The trc file shows this:
Dump file /dev1/visdb10/10.2.0/admin/VIS_wbsebdev1/bdump/vis_p001_14628.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /dev1/visdb10/10.2.0
System name: Linux
Node name: wbsebdev1
Release: 2.4.21-32.ELsmp
Version: #1 SMP Fri Apr 15 21:17:59 EDT 2005
Machine: i686
Instance name: VIS
Redo thread mounted by this instance: 1
Oracle process number: 21
Unix process pid: 14628, image: oracle@wbsebdev1 (P001)
*** SERVICE NAME:(SYS$USERS) 2008-05-29 11:39:26.957
*** SESSION ID:(388.16) 2008-05-29 11:39:26.957
The Alertlog file shows at the end this:
Thu May 29 11:19:06 2008
Streams APPLY A001 with pid=16, OS id=9531 stopped
Thu May 29 11:21:25 2008
Incremental checkpoint up to RBA [0x746.d359.0], current log tail at RBA [0x746.d471.0]
Thu May 29 11:39:26 2008
Streams APPLY A001 started with pid=18, OS id=14624
Streams Apply Reader started P000 with pid=20 OS id=14626
Streams Apply Server started P001 with pid=21 OS id=14628
Thu May 29 11:41:33 2008
Incremental checkpoint up to RBA [0x746.11565.0], current log tail at RBA [0x746.121b9.0]
Pls help.
Thanking You,
Nitesh.