can some one please explain to me if this is normal, in alert.log it show the replicat stop and start every a few minutes, the replication works i.e. data is replicated from src to trg db.
except that out of no where, the replcat just hang, no other error msg in alert.log when hang, just that stats rep_name says time out, and no data replication happening.
I am trying to find out the cause of replicat random hang, not sure this frequent stop and start cause it.
here is in alert.log:
GoldenGate Apply Server AS0E for OGG$R_S1_BID with pid=67 OS id=14560 stopped
GoldenGate Apply Server AS09 for OGG$R_S1_BID with pid=66 OS id=20742 stopped
GoldenGate Apply Server AS03 for OGG$R_S1_BID with pid=81 OS id=23710 stopped
GoldenGate Apply Server AS02 for OGG$R_S1_BID with pid=82 OS id=30202 stopped
Fri Jan 12 00:24:09 2018
GoldenGate Apply Server for OGG$R_S1_BID started AS0G with pid=66 OS id=24143
Fri Jan 12 00:28:50 2018
GoldenGate Apply Server AS0G for OGG$R_S1_BID with pid=66 OS id=24143 stopped
Fri Jan 12 00:29:01 2018
GoldenGate Apply Server for OGG$R_S1_BID started AS0F with pid=66 OS id=24245
Fri Jan 12 00:30:07 2018
GoldenGate Apply Server for OGG$R_S1_BID started AS0A with pid=82 OS id=24285
Fri Jan 12 00:33:51 2018
Fri Jan 12 00:33:51 2018
GoldenGate Apply Server AS0A for OGG$R_S1_BID with pid=82 OS id=24285 stopped
GoldenGate Apply Server AS0F for OGG$R_S1_BID with pid=66 OS id=24245 stopped
Fri Jan 12 00:33:52 2018
GoldenGate Apply Server for OGG$R_S1_BID started AS08 with pid=66 OS id=24365
Fri Jan 12 00:43:54 2018
GoldenGate Apply Server AS08 for OGG$R_S1_BID with pid=66 OS id=24365 stopped
there are thousands of these lines in the alert log all the time.
if this is not a problem, what would be the cause of randomly hang of replicat?
thanks,
Jing