shell脚本启动rman全备

最新推荐文章于 2022-04-28 15:42:09 发布

L30736473

最新推荐文章于 2022-04-28 15:42:09 发布

阅读量206

点赞数

分类专栏： rman 文章标签：脚本 Oracle SQL F#

本文链接：https://blog.csdn.net/L30736473/article/details/83777241

版权

rman 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

. /home/oracle/.profile
cd /picclife/filenet/backup/script/
SENDMAIL=/picclife/filenet/script/send_mail.sh
IP="10.64.2.11"
mtitle="`date +%Y"-"%m"-"%d"_"%H":"%M":"%S` $ORACLE_SID $IP `hostname` "
log=log/rman_`date +%Y"-"%m"-"%d`.log
rman target / log=$log < rman.sql
date >> $log
sleep 60
if [ ! -f $log ]
then
error_msg="Not found file: $log"
$SENDMAIL "$mtitle $error_msg" "db" "$log"
else
last_line=`cat $log | grep "RMAN-" | wc -l `
if [ "$last_line" -gt "0" ]
then
error_msg="Backup not finish"
$SENDMAIL "$mtitle $error_msg" "db" "$log"
fi
fi

----------------------------------
run {
BACKUP TAG = 'full backup' DATABASE;
sql 'alter system switch logfile';
backup as compressed backupset archivelog all delete all input ;
crosscheck backupset;
DELETE force noprompt OBSOLETE device type disk;
}