I am working this to share some of the many scripts I schedule to automatically run to alert me of any current or potential issues. If there are others you can recommend then please do. If you can share, advise, or improvement on anything, please share that as well.
Eventually there will be a post for all of these.
- Checking the Alert Log
- Backups and monitoring the results
- RMAN Validation script
- RMAN Catalog Maintenance script
- Checking for corruption after Validation
- Export datapump expdp (as well as RMAN backups)
- Deletion of audit files
- Updated Monitor Server Disk Space
- Original Monitor Server Disk Space
- Checking for failed logins
- Checking for blocked sessions
- Checking for locked accounts
- Check Tablespace usage
- Monitor for account expiration date
- PL/SQL Jobs
- Check for failed jobs
- Monitor invalid objects, attempt to recompile, otherwise send email
Please comment if there are others you think I should add or improvements to the existing version I am using.
No comments:
Post a Comment