| Oracle CDC - WAITING FOR REDO [message #515764] |
Wed, 13 July 2011 03:51 |
dbanukesh
Messages: 96
Registered: November 2008
Location: London
|
Member |
|
|
Hi guys,
I am facing troubles with setting up Oracle CDC in my environment. I have source as 2 Node Oracle RAC (10.2.0.3) and stage as standalone server (10.2.0.3) with OWB installed on this. I have implement archive logging on source and it is successfully transporting archive logs on the stage server. Also all the logs are getting registered with the capture process (in dba_registered_archived_log view). Strangely only first file got 'YES' value in the DICTIONARY_BEGIN column but rest has 'NO' value.
When I query v$streams_capture view it says 'WAITING FOR REDO'.
I have set up java_pool, streams_pool, remote_login_passwordfile as SHARED on both source and staging, and global_names = TRUE on source .
Could you please share your insights what can be potentially wrong with the environment. Please advice.
Regards
Nukesh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
