GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

ERROR OGG-00446 CSN not found in supplemental file

edited Apr 29, 2013 6:39AM in GoldenGate, Streams and Distributed Database (MOSC) 9 commentsAnswered
   

 Hi all,

 

my situation:

 

before we have the db configuration, primary db <--->DG, but for some reason, the disk was corrupted where online redos were on. when we found the proplem, the DG was lagged many logs. and the DG could not skipped the corrupted logs.and my solution is to activate the DG, and make the sync via GG. when activate the DG, record the SCN of DG. when start the GG replicat, when point aftercsn <SCN of DG>.

 

with this solution, some replicats go fine. but few replicat are abended with below errors:

 

2013-04-29 08:06:35  ERROR   OGG-00446  CSN not found in supplemental file /u01/ogg/dirchk/R13Q9.cps

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