查看执行脚本rman.sh
backuplevel0.sh:
backuplevel1:
点击(此处)折叠或打开
-
#!/bin/bash
-
SH_HOME=/backup/rman
-
export SHELL_HOME
-
ORACLE_SID=orcl
-
export ORACLE_SID
-
DATE=`date +\"%Y%m%d%H%M\"`
-
WEEK=`date +%w`
-
-
if [ ! -d \"$SH_HOME/log\" ] ; then
-
mkdir -p $SH_HOME/log
-
fi
-
-
RMAN_LOG=${SH_HOME}/log/RMAN_BACKUP_${DATE}.log
-
-
if [ -f \"$RMAN_LOG\" ] ; then
-
rm -rf $RMAN_LOG
-
touch $RMAN_LOG
-
else
-
touch $RMAN_LOG
-
fi
-
-
-
ps -ef|grep \"dbw0_$ORACLE_SID\" |grep -v grep
-
-
if [ $? -eq 0 ] ; then
-
if [ $WEEK -eq 0 ] ; then
-
echo \"BACKUP TYPE IS INCREMENTAL LEVEL=0 \" >> $RMAN_LOG
-
echo ____________________________________ >> $RMAN_LOG
-
echo \"{\" >> $RMAN_LOG
-
rman target / @$SH_HOME/backuplevel0.sql log=$RMAN_LOG
-
echo \"}\" >> $RMAN_LOG
-
else
-
echo \"BACKUP TYPE IS INCREMENTAL LEVEL=1 \" >> $RMAN_LOG
-
echo ____________________________________ >> $RMAN_LOG
-
echo \"{\" >> $RMAN_LOG
-
rman target / @$SH_HOME/backuplevel1.sql log=$RMAN_LOG
-
echo \"}\" >> $RMAN_LOG
-
fi
- fi
backuplevel0.sh:
点击(此处)折叠或打开
-
run{
-
CROSSCHECK ARCHIVELOG ALL;
-
CROSSCHECK BACKUP;
-
BACKUP INCREMENTAL LEVEL=0 TAG \'LEVEL0\' database
-
INCLUDE CURRENT CONTROLFILE
-
FORMAT \'/backup/rman/lv0_%d_%T_%s\'
-
PLUS ARCHIVELOG
-
FORMAT \'/backup/rman/archive_log_%d_%T_%s\' DELETE ALL INPUT;
-
DELETE NOPROMPT OBSOLETE;
- }
backuplevel1:
点击(此处)折叠或打开
-
run{
-
CROSSCHECK ARCHIVELOG ALL;
-
CROSSCHECK BACKUP;
-
DELETE NOPROMPT OBSOLETE;
-
BACKUP INCREMENTAL LEVEL=1 TAG \'LEVEL1\' DATABASE
-
INCLUDE CURRENT CONTROLFILE
-
FORMAT \'/backup/rman/lv1_%d_%T_%s\';
-
sql \'alter system archive log current\';
-
DELETE NOPROMPT OBSOLETE;
-
BACKUP ARCHIVELOG ALL
-
FORMAT \'/backup/rman/archive_log_%d_%T_%s\'
-
DELETE ALL INPUT;
- }
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24871431/viewspace-776044/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
没有了~
请登录后发表评论
登录
全部评论
