No question at this time
DBA Top 10
1 M. Cadot 6600
2 B. Vroman 3400
3 J. PĂ©ran 2200
4 A. Kavsek 1400
5 P. Tsongayinwe 900
6 P. Wisse 600
7 T. Boles 400
7 D. Walgude 400
7 D. Johnson 400
10 J. Alcroft 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48675
Total active users1328
Act. users last 24h0
Act. users last hour0
Registered user hits last week24
Registered user hits last month452
Go up

Golden gate monitoring script for struck processess
Next thread: RMAN ERROR
Prev thread: how to add temp file in oracle 11g rac2 asm

Message Score Author Date
Hi Folks, The requirement is to get an email i...... Jayanand Reddy Jan 16, 2014, 17:20
Im not sure I understand what you mean... but he...... Adam Hudspith Jan 16, 2014, 17:48
Hi, Thanks for your reply Actually we have a s...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Jayanand Reddy Jan 17, 2014, 14:30

Follow up by mail Click here


Subject: Golden gate monitoring script for struck processess
Author: Jayanand Reddy, India
Date: Jan 16, 2014, 17:20, 3089 days ago
Os info: CentOS release 5.7 (Final)
Oracle info: 11.2.0.3.0
Message: Hi Folks,

The requirement is to get an email if any of the golden gate process struck on particular RBA for long time, even there are many tails file to be replicated.

The status of the process is running and there is no lag.

Thanks,
Anand T.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Golden gate monitoring script for struck processess
Author: Adam Hudspith, United Kingdom
Date: Jan 16, 2014, 17:48, 3089 days ago
Message:
Im not sure I understand what you mean... but here goes anyway.

You only need to monitor OGG for ABENDED status. If it's not ABENDED it's doing something at least.

It will ABEND if the database it is replicating from has hung sessions.

Write a script for that.

If a session is hung and all it's doing is a SELECT then NFA is required. That wont cause a problem with OGG.

If it's inserting/updating ... that will cause OGG a headache and you will need to kill the session and possibly intervene with the OGG system.


Adam
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Golden gate monitoring script for struck processess
Author: Jayanand Reddy, India
Date: Jan 17, 2014, 14:30, 3088 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi,
Thanks for your reply

Actually we have a script if replicat or Extract is Abend or lagging

we are looking for script which is able to send an email when RBA is not moving its struck some where in the trail file and even though there is no lag.


Thanks,
Anand T
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here