Link to home
Start Free TrialLog in
Avatar of Mushfique Khan
Mushfique Khan

asked on

Oracle Alert Monitoring, Copy & Cleanup

Need to monitor my alert logs: Oracle=11.2.0.3 & + & OS= AIX 6 & OLE 5

1. Get email as soon as there is any ORA- in the alert log, also looking for HSM related message too, or if there is any other text/string, if needed
2. Have to keep only 10 or 15 days of alert.log at the primary location, rest should be copy/purge to a secondary location
3. Also is there any fastest way to check/look into alert log, instead of first locating the directory (v$diag_info) and then cd and then tail -100f

Please assist/advice ... thanks in advance.
ASKER CERTIFIED SOLUTION
Avatar of johnsone
johnsone
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mushfique Khan
Mushfique Khan

ASKER

thanks, especially markgeer, how about the #1 & #3, is there any fastest way to look for and got  alerted as soon as there is any ORA- error there?

And we have almost 17 instances running on each node, having 3 nodes cluster, please assist/advise/guide, how to accomplish this too.

Thanks in advance.