Problem with a logical standby - creation of table like CMP3$68792 is blocking the replication
edited Dec 14, 2015 3:22AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 4 commentsAnswered ✓
Hi
I would like to know if some of you has encountered this kind of problem on a logical standby :
sometimes a table like : CMP3$99999 is created, blocking the replication on the logical standby.
We have to skip some transactions in order to fix the problem:
EXECDBMS_LOGSTDBY.SKIP_TRANSACTION('||XIDUSN||','||XIDSLT||','||XIDSQN||')'
--------------------------------------------------------------------------------
EXEC DBMS_LOGSTDBY.SKIP_TRANSACTION (27,4,1412)
EXEC DBMS_LOGSTDBY.SKIP_TRANSACTION (53,18,7251)
EXEC DBMS_LOGSTDBY.SKIP_TRANSACTION (53,28,11339)
Which program can create such tables : CMP3$99999 ?
1