被動式監控oracle的rman備份情況

urgel_babay發表於2016-05-11
Oracle
被動式監控oracle的rman備份情況

dbbackup.sh

點選(此處)摺疊或開啟

  1. [oracle@db rman]$ cat dbbackup.sh
  2. cd /home/db/oracle/
  3. . ./.bash_profile
  4. mv /oradata/rman/db_* /oradata/rmanbak/db_*
  5. logName=db_rman_`date +\'%Y%m%d%H%M%S\'`_full.log
  6. find /oradata/rmanbak -name \"db_*\" -mtime +0 -exec rm -rf {} \\;
  7. cd /oradata/rman
  8. rman target / CMDFILE rman_db.rcv >> $logName

  10. ##################################
  11. sh check_backup.sh
  12. ##################################


RMAN_db.rcv

點選(此處)摺疊或開啟

  1. [oracle@db rman]$ cat rman_db.rcv 
  2. run{
  3. crosscheck archivelog all;
  4. allocate channel c1 type disk;
  5. allocate channel c2 type disk;
  6. allocate channel c3 type disk;
  7. allocate channel c4 type disk;
  8. backup as compressed backupset database format \'/oradata/rman/hxpif_full_%U\'
  9. plus archivelog skip inaccessible format \'/oradata/rman/hxpif_ARC_%U\';
  10. delete noprompt archivelog all completed before \'sysdate-1/8\';
  11. backup current controlfile format \'/oradata/rman/hxpif_control_bak_%T\';
  12. backup spfile format \'/oradata/rman/hxpif_spfile_bak_%T\';
  13. release channel c1;
  14. release channel c2;
  15. release channel c3;
  16. release channel c4;
  17. }


check_backup.sh

點選(此處)摺疊或開啟

  1. [oracle@db rman]$ cat check_backup.sh
  2. IP=192.168.0.56
  3. SID=db

  5. status=`sqlplus -silent \"/as sysdba\" <<eof
  6. set feedback off
  7. set verify off
  8. set heading off
  9. set echo off
  10. set pagesize 0
  11. SELECT /*+ rule */ DECODE (
  12.              TRUNC (SYSDATE - start_time),
  13.              0, DECODE (
  14.                    status,
  15.                    \'COMPLETED\', \'0\',
  16.                    \'COMPLETED WITH WARNINGS\',\'1\',
  17.                    \'2\'),
  18.              \'2\')
  19.           backup_status
  20.   FROM v\\\\$rman_backup_job_details
  21.  WHERE start_time = (SELECT MAX (start_time) FROM v\\\\$rman_backup_job_details);
  22. exit;
  23. eof`
  24. output=`sqlplus -silent \"/as sysdba\" <<eof
  25. set feedback off
  26. set verify off
  27. set heading off
  28. set echo off
  29. set pagesize 0
  30. SELECT /*+ rule */ DECODE (
  31.           TRUNC (SYSDATE - start_time),
  32.           0, DECODE (status,
  33.                      \'COMPLETED\', \'Backup Suess!\',
  34.                      \'COMPLETED WITH WARNINGS\', \'Backup With Warnings!\',
  35.                      \'Backup Failed!\'),
  36.           \'No Backup!\')
  37.           backup_status
  38.   FROM v\\\\$rman_backup_job_details
  39.  WHERE start_time = (SELECT MAX (start_time) FROM v\\\\$rman_backup_job_details);
  40. exit;
  41. eof`
  42. hostip=$IP
  43. checkname=\"Rman_Backup_\"$SID
  44. echo -e \"$hostip\\t$checkname\\t$status\\t$output\" > backup_status.log

  46. /usr/local/nagios/bin/send_nsca 192.168.128.45 -c /usr/local/nagios/etc/send_nsca.cfg < backup_status.log


[oracle@db rman]$ cat backup_status.log 
192.168.0.56     Rman_Backup_DB       0       Backup Suess!












來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/30936525/viewspace-2097971/，如需轉載，請註明出處，否則將追究法律責任。

相關文章