【Vegas原创】RMAN数据库Daily备份脚本（Linux版）

最新推荐文章于 2021-10-22 19:02:00 发布

weixin_30820077

最新推荐文章于 2021-10-22 19:02:00 发布

阅读量76

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/amadeuslee/archive/2009/08/11/3744320.html

本文介绍了一个用于Oracle数据库的RMAN备份方案，包括每日全备脚本及过期备份清理脚本，并通过crontab实现了定时任务。全备脚本采用多通道并行备份提高效率。

例：添加oralin数据库每日RMAN备份

1，添加/u03/script/oralin/fullbak.sh

#!/bin/sh
echo "`date` backup start"
$ORACLE_HOME/bin/rman target / nocatalog <<EOF
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
backup format '/u03/dmp/oralin/dbfile/full%u_%s_%p' database
include current controlfile;
sql 'alter system archive log current';
backup filesperset 3 format '/u03/dmp/oralin/log/arch%u_%s_%p'
archivelog all delete input;
release channel c1;
release channel c2;
release channel c3;
}
EOF
echo "`date` backup successful"
exit;

2,添加/u03/script/oralin/delobsolete.sh

$ORACLE_HOME/bin/rman target / nocatalog <<EOFi
run{
crosscheck archivelog all;
crosscheck backup;
delete noprompt obsolete;
}

3，crontab -e，添加：

00 03 * * * su - oracle -c "sh /u03/script/oralin/fullbak.sh">/u03/script/oralin/full.log
00 07 * * * su - oracle -c "sh /u03/script/oralin/delobsolete.sh">/u03/script/oralin/delobsolete.log

转载于:https://www.cnblogs.com/amadeuslee/archive/2009/08/11/3744320.html