No question at this time
DBA Top 10
1 M. Cadot 5400
2 P. Wisse 1300
3 P. Tsongayinwe 1100
4 B. Vroman 500
4 J. Schnackenberg 500
6 M. Pagac 400
7 A. Deledda 200
7 D. Walgude 200
7 B. M 200
10 J. Alcroft 100
10 G. Trivedi 100
10 A. Hudspith 100
10 V. Sharma 100
10 L. Ywema 100
About
DBA-Village
Advertise here
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48742
Total active users1337
Act. users last 24h1
Act. users last hour0
Registered user hits last week108
Registered user hits last month471
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, 3424 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, 3424 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, 3424 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