DBA Bundle V4.8 download: https://www.dropbox.com/s/xn0tf2pfeq04koi/DBA_BUNDLE4.tar?dl=0 What is new in this version: oracle_cleanup.sh script: – Verify the log/trace files location validity before the deletion of log files. dbalarm.sh script: – Check the existence of Restore Points when FRA hits the threshold.                       – Avoid running the script […]

New features of DBA Bundle 4.7 active_sessions.sh script:– Show current running RMAN Backups if exist.– Fixed divide by zero bug when TOTALWORK=0 in v$session_longops dbalarm.sh script:– Enclosing OS Network Failure Statistics (Dropped Packets) whenever TIMEOUT errors appear in the DB or Listener ALERTLOG.– Added RMAN Backup Failure new Check.– Added the Checking of Running RMAN […]

The new features of Bundle V4.6 are: db_locks.sh script: Replaced the column that checks the wait in seconds from SECONDS_IN_WAIT to use WAIT_TIME_MICRO (which is more accurate) for 11gr2 compatibility. dbalarm.sh script:– The BLOCKING SESSION time threshold has been changed so the script will monitor only the blocking sessions that are blocked for more than […]

DBA Bundle version 4.5 is now available for download. Enhancements: – Enhanced the display of the Execution Plan when running sql_id_details.sh using sqlid alias. – Added REPORT UNRECOVERABLE DATABASE FILES that don’t have a valid backup to the Daily Health Check Report [dbdailychk.sh script] To download DBA Bundle version 4.5: https://www.dropbox.com/s/xn0tf2pfeq04koi/DBA_BUNDLE4.tar?dl=0 To read the full […]

DBA Bundle version 4.4 is released. It comes with the following: Bug fixes:– Fixed small bugs with the following scripts: configuration_baseline.sh schedule_rman_image_copy_bkp.sh schedule_rman_full_bkp.sh dbalarm.sh Enhancements:– Added new parameter to dbdailychk_html.sh & dbdailychk.sh to control the display of LAST MODIFIED OBJECTS in the Health Check report. To download DBA Bundle v4.4:https://www.dropbox.com/s/xn0tf2pfeq04koi/DBA_BUNDLE4.tar?dl=0 To read the full article […]

Version 4.3 is now available. It’s packed up with the following features: New Scripts: goldengate_lag_mon.sh For monitoring goldengate LAG, more details: http://dba-tips.blogspot.ae/2018/05/linux-shell-script-to-monitor-and.html New Enhancements: – gather_stats.sh script for gathering statistics can now run in the background (nohup mode). – Paranoid mode feature has been added to dbalarm.sh script for reporting EXPORT/IMPORT, ALTER SYSTEM, ALTER DATABASE, instance STARTUP/SHUTDOWN and […]

Fixed reported bugs inside (dbdailychk.sh, dbalarm.sh, export_data.sh, report_long_runing_queries.sh) scripts. New Features: Added Goldengate log monitoring feature to dbalarm.sh script [Disabled by default]. Added new aliases: – raclog to open the alert logfile for Clusterware/Oracle Restart. – asmlert to open the alert logfile for ASM instance. To download DBA Bundle V4.2: https://www.dropbox.com/s/xn0tf2pfeq04koi/DBA_BUNDLE4.tar?dl=0 To visit the main […]

DBA Bundle V4.1 is now released with the following new scripts: backup_ctrl_spf_AWR.sh Backup Controlfile as (Trace/RMAN BKP), Backup SPFILE and Generate AWR for full day This script can be scheduled in the crontab to run once a day. Script options/variables must be modified to match your environment. New Starting from V4.1 kill_long_running_queries.sh Kill all queries […]

If you were googling for a DBA scripts/tools to help you out with managing the mighty Oracle DB then you have landed on the right blog 🙂 I know you’re super busy and have no time for reading long articles, so let me jump to the bottom line, the DBA Bundle is a group of shell scripts […]