ITPub博客

首页 > 数据库 > Oracle > HQ_显示RMAN备份信息及日志

HQ_显示RMAN备份信息及日志

原创 Oracle 作者:lusklusklusk 时间:2016-11-09 10:15:45 0 删除 编辑
vi /mesbk/scripts/backupLev0.sh
DATE=`date +%Y%m%d`
rman target/ cmdfile=/mesbk/scripts/rmanBackupLev0.rman msglog=/mesbk/log/rmanBackupLev0_$DATE.log

vi /mesbk/scripts/rmanBackupLev0.rman
run{
ALLOCATE CHANNEL ch1 TYPE disk;
BACKUP INCREMENTAL LEVEL 0 TAG 'DB0' DATABASE FORMAT '/mesbk/data/DB_0_%T_%s_%U' PLUS ARCHIVELOG  FORMAT '/mesbk/archivelog/ARCH_0_%T_%s' DELETE ALL INPUT;
RELEASE CHANNEL ch1;
CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED BACKUP;
DELETE EXPIRED ARCHIVELOG ALL;
REPORT OBSOLETE;
DELETE NOPROMPT OBSOLETE;
}

vi /mesbk/scripts/backupLev0_log.sh
DATE=`date -d "-1 day" +%Y%m%d`
mail_list='XX@YY.COM'
cat /mesbk/log/rmanBackupLev0_$DATE.log|mailx -s "MDB 192.168.3.3 0级备份过程明细" $mail_list




vi /mesbk/scripts/backupLev1.sh
DATE=`date +%Y%m%d`
rman target/ cmdfile=/mesbk/scripts/rmanBackupLev1.rman msglog=/mesbk/log/rmanBackupLev1_$DATE.log

vi /mesbk/scripts/rmanBackupLev1.rman
run{
ALLOCATE CHANNEL ch1 TYPE disk;
BACKUP INCREMENTAL LEVEL 1 TAG 'DB1' DATABASE FORMAT '/mesbk/data/DB_1_%T_%s_%U' PLUS ARCHIVELOG  FORMAT '/mesbk/archivelog/ARCH_1_%T_%s' DELETE ALL INPUT;
RELEASE CHANNEL ch1;
CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED BACKUP;
DELETE EXPIRED ARCHIVELOG ALL;
REPORT OBSOLETE;
DELETE NOPROMPT OBSOLETE;
}

vi /mesbk/scripts/backupLev1_log.sh
DATE=`date -d "-1 day" +%Y%m%d`
mail_list='XX@YY.COM'
cat /mesbk/log/rmanBackupLev1_$DATE.log|mailx -s "MDB 192.168.3.3 1级备份过程明细" $mail_list


rman target /
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/mesbk/controlfile/CNTRL_%T%F';


备份文件信息
/mesbk/data
/mesbk/archivelog
/mesbk/controlfile




[root@mesdb log]# crontab -l
0  21 * * 6 su - oracle -c "/mesbk/scripts/backupLev0.sh"
30 8 * * 0  su - oracle -c "sh /mesbk/scripts/backupLev0_log.sh>> /dev/null 2>&1"
0  23 * * 1,2,3,4,5,0 su - oracle -c "/mesbk/scripts/backupLev1.sh"
30 8 * * 1,2,3,4,5,6 su - oracle -c "sh /mesbk/scripts/backupLev1_log.sh>> /dev/null 2>&1"

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/30126024/viewspace-2128114/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: SQLT安装使用说明
请登录后发表评论 登录
全部评论
Welcome to Lukes DB HOME。 Oracle OCM、Mysql OCP, 10年DBA工作经验,博客仅记录自己的一个学习过程,不代表完全准确,如有需要,欢迎转载。

注册时间:2015-02-02

  • 博文量
    348
  • 访问量
    1174937