Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 5 down vote favorite

Grid Control 10.2.0.5.

Does anyone know a way to configure a Grid Control notification rule for a failure of the SQL APPLY process on a logical standby database? I'd really like an email notification that the SQL APPLY process has encountered an error and is no longer applying redo to the logical standby.

I can get notifications on job failures, database down, listener stops, agent stops monitoring, but don't see how to get notified for this event.

share|improve this question
2  
I know there's got to be a way, but my brain is too fuzzy to really think it through. If there isn't an in-built method, there's no reason to think that you couldn't do a little shell script to grep the logs and return a warning that way (I did that once w/ grid. It's not too hard to do -- you have to return a number and then you assign a metric to it so that a certain number fires off an email). That said, I can't believe there isn't an in-built metric that would catch this. – Kerri Shotts Jun 8 '11 at 20:32
Thanks for the idea. If nothing else surfaces, I'll try this out. I'd have to rotate the alert log whenever I got the error to avoid repeat notifications... Perhaps you should consider making the comment an answer so I can at least upvote it, and perhaps accept it ;-) – DCookie Jun 9 '11 at 16:22

1 Answer

up vote 2 down vote accepted

Apply Lag will notify you when the apply is slow, not just when it has stopped. This may give you too many notifications, but it seems like you could tweak the threshold to limit these.

See also:
Oracle® Data Guard Concepts and Administration 10g Release 2 (10.2)
Oracle® Data Guard Broker 10g Release 2 (10.2)

(Apply Lag in Grid Control Image)

share|improve this answer
+1, Thanks Leigh, I will check this out. Sounds promising. – DCookie Jun 10 '11 at 21:02
It appears that the apply lag metric is not something you can trigger notifications for - at least I don't see anything in Grid Control to let me do that. The only value that looks to be helpful is the Data Guard Status metric, and I've set that to notify me in case of problems. I think that should do it. – DCookie Jun 21 '11 at 17:44
And, today, I got notification that Data Guard was having trouble, so this has solved my problem. Thanks Leigh and Kerri for your help. – DCookie Jul 22 '11 at 16:41

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.