We have developed several scripts over years to manage Oracle databases for our internal and external projects. We would like to share them for public use at no cost. These scripts help DBA to maintan Oracle databases pro actively, monitor various metrics, troubleshoot performance issues and automate routine housekeeping tasks.
- ASH/AWR - To identify top waits, plan history, performance metrics, etc.
- Data Pump - To perform logical backups of the database using Data Pump.
- Data Guard - To start/stop, monitor replication gap, switch over, etc.
- Golden Gate - To monitor Golden Gate processes and replication lag.
Warning:- These scripts should be used by certified and/or experienced DBA. Test these scripts in lower environment before using them in live production system.