Tuesday, October 23, 2018

DBA BUNDLE 4.7 released

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 Backup when CPU hit the threshold

configuration_baseline.sh script:
- Enabled the reporting of NOLOGGING objects in the report.

To download DBA Bundle V4.7:
https://www.dropbox.com/s/xn0tf2pfeq04koi/DBA_BUNDLE4.tar?dl=0

This article explains the major features of the DBA BUNDLE:
http://dba-tips.blogspot.com/2014/02/oracle-database-administration-scripts.html

Tuesday, October 16, 2018

Monitoring Failed RMAN Backup Jobs in dbalarm Shell Script

dbalarm script is now capable of monitoring RMAN backup failures. Just make sure to adjust the interval of the following parameter (in minutes) to the same execution interval of dbalarm.sh in your crontab.

e.g. If you are scheduling dbalarm.sh script to run every 5 minutes in the crontab, the following parameter should be set to 5
LAST_MIN_BKP_CHK=5      # REPORT RMAN Backup FAILURE in the last N MINUTES. Should be similar to the crontab execution interval of dbalarm script. [DB]

By default, dbalarm.sh script will monitor RMAN backup failure, in case you want to change this behavior and stop this feature for any reason, just set the following parameter to N
CHKRMANBKP=N           # Enable/Disable Checking of RMAN Backup FAILURE.      [DB]

To download dbalarm script:

To read more about dbalarm script:

Thanks to Rahul Malode who recommended adding this feature.