使用RMAN和控制文件备份删除归档日志的SHELL脚本--RED HAT 5 LINUX 64

最新推荐文章于 2021-04-02 20:04:33 发布

转载最新推荐文章于 2021-04-02 20:04:33 发布 · 1.4k 阅读

文章标签：

#oracle #备份恢复 #rman #archive

备份、恢复专栏收录该内容

22 篇文章

订阅专栏

本文介绍在Oracle环境下如何通过crontab实现定期全备及压缩，并自动删除过期的备份集与归档日志。包括配置备份保留策略、指定备份格式、交叉验证备份集等步骤。

在ORACLE用户下的定时器设置
[oracle@SHARKDB dbscripts]$ crontab -l
# minute hour day month week
15 1 * * 0 sh /home/oracle/dbscripts/backup_full.sh
05 3 * * * sh /home/oracle/dbscripts/del_arc.sh
全备脚本先配置保留时间窗口,配置备份目录和格式,然后交叉检查所有备份集.
删除无效备份集,删除过期对象,进行全备份并压缩..
[oracle@SHARKDB dbscripts]$ cat backup_full.sh
[plain] view plaincopyprint?
#!/bin/ksh
source ~/.bash_profile
echo "------------------Start------------------";date
#backup start
$ORACLE_HOME/bin/rman log=/home/oracle/dbscripts/logs/rman_full_backup.log << EOF
connect target /
run{
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/arch/full_%d_%s_%T_%t.bak';
crosscheck backupset;
delete noprompt expired backupset;
delete noprompt obsoleted;
backup full AS COMPRESSED BACKUPSET DATABASE include current controlfile plus archivelog;
}
exit;
EOF
echo "-------------------End-------------------";date

删除归档日志先检查归档日志把物理删除的信息从控制文件删除,然后执行物理删除 2天前的.
[oracle@SHARKDB dbscripts]$ cat del_arc.sh
[cpp] view plaincopyprint?
#! /bin/bash
source ~/.bash_profile
exec >> /home/oracle/dbscripts/logs/del_arch`date +%F_%H`.log
$ORACLE_HOME/bin/rman target / <<EOF
crosscheck archivelog all;
delete noprompt expired archivelog all;
delete noprompt archivelog until time 'sysdate-2';
exit;
EOF

如果没有su - oracle 语句 -- source ~/.bash_profile 那么要在ROOT下执行定时器切换用户执行脚本

03 04 * * * su - oracle -c '/home/oracle/del_arc.sh'

原文地址： http://blog.youkuaiyun.com/zengmuansha/article/details/13629117