来源:Oracle认证 发布时间:2012-11-12 Oracle认证视频 评论
rm -rf $L0_PATH/$WEEK/*
$SH_PATH/db_l0_backup.sh $L0_PATH/$WEEK
cd $L0_PATH/$WEEK
$SH_PATH/ftp.sh $IP $FTPUSER $FTPPASS $FTPROOT0 $WEEK $WEEK_$LOG_TAG.log
fi
fi
else
if [ ! -d $L1_PATH ]; then
mkdir $L1_PATH
fi
if [ ! -d $L1_PATH/$WEEK ]; then
mkdir $L1_PATH/$WEEK
$SH_PATH/db_l1_backup.sh $L1_PATH/$WEEK
cd $L1_PATH/$WEEK
$SH_PATH/ftp.sh $IP $FTPUSER $FTPPASS $FTPROOT1 $WEEK $WEEK_$LOG_TAG.log
else
rm -rf $L1_PATH/$WEEK/*
$SH_PATH/db_l1_backup.sh $L1_PATH/$WEEK
cd $L1_PATH/$WEEK
$SH_PATH/ftp.sh $IP $FTPUSER $FTPPASS $FTPROOT1 $WEEK $WEEK_$LOG_TAG.log
fi
fi
db_l0_backup.sh零级备份程序
#!/bin/bash
L0_PATH=$1
DAY_TAG=`date "%Y-%m-%d"`
rman target / nocatalog msglog $L0_PATH/L0_db_backup_$DAY_TAG.log /dev/null
run{
allocate channel c0 type disk;
backup incremental level 0 database tag 'L0_dbf_bak' format '$L0_PATH/L0_%d_DF_s.%s_p.%p_%T.bak' plus archivelog tag 'L0_arc_bak' format '$L0_PATH/L0_%d_ARC_s.%s_p.%p_%T.bak' delete all input;
backup tag 'L0_spfile_bak' format '$L0_PATH/L0_%d_SPFILE_s.%s_p.%p_%T.bak' spfile;
backup tag 'L0_ctl_bak' format '$L0_PATH/L0_%d_CTL_s.%s_p.%p_%T.bak' current controlfile;
release channel c0;
}
#crosscheck backup;
#delete noprompt expired backup;
#delete noprompt obsolete;
EOF
db_l1_backup.sh一级备份程序
#!/bin/bash
L1_PATH=$1
DAY_TAG=`date "%Y-%m-%d"`
rman target / nocatalog msglog $L1_PATH/L1_db_backup_$DAY_TAG.log /dev/null
run{
allocate channel c1 type disk;
backup incremental level 1 database tag 'L1_dbf_bak' format '$L1_PATH/L1_%d_DF_s.%s_p.%p_%T.bak' plus archivelog tag 'L1_arc_bak' format '$L1_PATH/L1_%d_ARC_s.%s_p.%p_%T.bak' delete all input;
backup tag 'L1_spfile_bak' format '$L1_PATH/L1_%d_SPFILE_s.%s_p.%p_%T.bak' spfile;
backup tag 'L1_ctl_bak' format '$L1_PATH/L1_%d_CTL_s.%s_p.%p_%T.bak' current controlfile;
release channel c1;
}
#crosscheck backup;
#delete noprompt expired backup;
#delete noprompt obsolete;
EOF
FTP主程序
#!/bin/bash
_IP=$1
_FTPUSER=$2
_FTPPASS=$3
_FTPROOT=$4
_WEEK=$5
_LOG=$6
#_FILE=$7
echo "..................FTP Trans $_IP...................." >>$_LOG
date "%Y-%m-%d-%T:FTP $_IP Trans Begin..." >> $_LOG 2>>$_LOG
ftp -d -i -n > $_LOG 2>>$_LOG
open $_IP
user $_FTPUSER $_FTPPASS
cd $_FTPROOT/$_WEEK
bi
mdelete *
mput *
bye
FTPIT
FTP目录维护程序
#!/bin/bash
_IP=$1
_FTPUSER=$2
_FTPPASS=$3
_FTPROOT=$4
_WEEK=$5
_LOG=$6
#_FILE=$7
echo "..................FTP Delete And Trans $_IP...................." >>$_LOG
date "%Y-%m-%d-%T:FTP $_IP Begin..." >> $_LOG 2>>$_LOG
ftp -d -i -n > $_LOG 2>>$_LOG
open $_IP
user $_FTPUSER $_FTPPASS
cd /l1/2
mdelete *
cd /l1/4
mdelete *
cd /l1/5
mdelete *
cd /l1/0.bak
mdelete *
cd /l1
rmdir 0.bak
rename 0 0.bak
mkdir 0
cd /
cd /$_FTPROOT/3
mdelete *
cd /$_FTPROOT/6.bak
mdelete *
cd /$_FTPROOT
rmdir 6.bak
rename 6 6.bak
mkdir 6
cd /$_FTPROOT/$_WEEK
mdelete *
bi
mput *
bye
FTPIT
① 凡本网注明稿件来源为"原创"的所有文字、图片和音视频稿件,版权均属本网所有。任何媒体、网站或个人转载、链接转贴或以其他方式复制发表时必须注明"稿件来源:我考网",违者本网将依法追究责任;
② 本网部分稿件来源于网络,任何单位或个人认为我考网发布的内容可能涉嫌侵犯其合法权益,应该及时向我考网书面反馈,并提供身份证明、权属证明及详细侵权情况证明,我考网在收到上述法律文件后,将会尽快移除被控侵权内容。