GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Streams capture/apply fallen seriously behind

edited May 15, 2011 10:30PM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered
 Hi,

We have a real-time downstream environment in Oracle 10.2. A week ago, by mistake, a very long insert into a new table on source database was executed. This generated hundreds of archivelog were created in a couple of hours.. The table didn't even exist at the target database. Capture has fallen behind and is not able to read through the archived logs. This insert should never been executed, and the data is not needed/wanted at the target database. I have created the table in the target too, and made a negative rule on it, excluding it both from capture and

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center