Oracle Database Discussions

Hi Guys,

I am trying to configure Change data capture using asynchronous autoLog online publishing mode. I configured all the required init parameter on source and staging databases and also added standby redolog groups on staging database. Archiving on both instances are happening properly. Network server process ships the redo to Staging database properly but somehow the redo is not getting applied on staging database.

Here is the some information from staging database alert logfile,

Latent archivelog 'C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\STA\ARCH2_98_1_639407735.DBF'
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[6]: Assigned to RFS process 6440
RFS[6]: Identified database type as 'streams capture'
RFS[6]: Identified database type as 'repository'
Mon Jul 21 15:22:24 2008
RFS LogMiner: Client enabled and ready for notification
Mon Jul 21 15:22:25 2008
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[7]: Assigned to RFS process 3736
RFS[7]: Identified database type as 'streams capture'
RFS[7]: Identified database type as 'repository'
Mon Jul 21 15:22:25 2008
RFS LogMiner: Client enabled and ready for notification
Mon Jul 21 15:22:26 2008
RFS[6]: Archived Log: 'C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\STA\ARCH2_98_1_639407735.DBF'


When I check in v$standby_log file the status of each group is "Unassigned". I did switch logfile on the source database no of time but the standby log group is not becoming active.

Please let me know if anyone has any idea about this.

Thanks.