技术标签: linux异地备份脚本
传了这个脚本得休息了,继续Oracle internal研究,希望能与大家分享交流
hand_ftp.sh
#!/bin/bash
#
#SCRIPT.:FTP_BAK
#AUTHOR:LENG BO
#DATE
#PLATFORM.:LINUX AS4.6
#PURPOSE
#
#REV LIST:
# DATE:2009-12-03
# BY:lengbo
# USAGE:FTP oracle backup to remote backup server
#
BAK='/home/bak/bak'
LOC='/home/bak'
ERR_LOG='/home/bak/err_log'
LOG='/home/bak/log'
LOST='/home/bak/lost'
RMAN_IP='172.20.10.8'
RMAN_SH_LOC='/home/rman/bak_ftp'
RMAN_SH_NAME='ftp_8_bak.sh'
RMAN_BAK_TMP='home/rman/bak_ftp_tmp'
SEV_LOG_TMP='/home/bak/ftp_ser_log_tmp'
if [ ! -d $LOG ];
then mkdir -p $LOG
fi
if [ ! -d $ERR_LOG ];
then mkdir -p $ERR_LOG
fi
#######Make Director of lost files
if [ ! -d $LOST ];
then mkdir -p $LOST
fi
if [ ! -d $SEV_LOG_TMP ];
then mkdir -p $SEV_LOG_TMP
fi
} sh ${RMAN_SH_LOC}/${RMAN_SH_NAME}'
#SSH_WC='ls ${RMAN_BAK_TMP} |wc -l'
#LOC_WC='ls ${BAK} |wc -l'
#REM_CNT=$(SSH_WC)
REM_CNT=$(ssh ls /home/rman/bak_ftp_tmp |wc -l)
#BAK_CNT=$(LOC_WC)
BAK_CNT=$(ls /home/bak/bak |wc -l)
REM_SIZE=$(ssh du -h /home/rman/bak_ftp_tmp |awk ' {print $1}' |sed 's/[A-Z]//')
BAK_SIZE=$(du -h /home/bak/bak/ |awk ' {print $1}' |sed 's/M//')
#echo $REM_CNT
#echo $BAK_CNT
#echo $REM_SIZE
#echo $BAK_SIZE
f_ssh()
{
LOG='/home/bak/log'
SEV_LOG_TMP='/home/bak/ftp_ser_log_tmp'
echo "========This rman client script. logs Details!=======">>$LOG/log
if [ $BAK_CNT -ne 0 ];
then
cd $BAK
mv * $LOST
if [ $? -ne 0 ];
then rm -rf *
fi
fi
ssh
EOF
if [ $? -ne 0 ];
then echo "========This rman client script. executed with errors,Please check it!=======">>$LOG/log
exit 1
else echo "=======This rman client script. executed Succesfully!!!========">>$LOG/log
fi
#mv $LOG/log $LOG/log_$(date +'%F-%H-%M-%S')
}
f_ssh
########Not format '%F-%X',otherwise may occue errors!
#REM_CNT=$(SSH_WC)
REM_CNT=$(ssh ls /home/rman/bak_ftp_tmp |wc -l)
#BAK_CNT=$(LOC_WC)
BAK_CNT=$(ls /home/bak/bak |wc -l)
REM_SIZE=$(ssh du -h /home/rman/bak_ftp_tmp |awk ' {print $1}' |sed 's/[A-Z]//')
BAK_SIZE=$(du -h /home/bak/bak/ |awk ' {print $1}' |sed 's/M//')
#echo $REM_CNT
#echo $BAK_CNT
#echo $REM_SIZE
#echo $BAK_SIZE
f_ser()
{
#if [ $BAK_CNT -ne 0 ];
# then
# cd $BAK
# mv * $LOST
# if [ $? -ne 0 ];
# then rm -rf *
# fi
#fi
if [ $BAK_CNT -ne $REM_CNT ];
then echo "********Check number of between backups succesfully!Remote backups and lock backups is different,whic is expected********">>$LOG/log
if [ $BAK_CNT -eq 0 ];
then echo "********$BAK have one null backups Now to recreate it and ftping it!!!********">>$LOG/log
# cd $BAK
# mv * $LOST
# if [ $? -ne 0 ];
# then echo "********Warnings!Move backups from $BAK to $LOST Failed,Remov it********">>$LOG/log
# rm -rf *
#
# else echo "********Congratulations!Move backups from $BAK to $LOST Done!*******">>$LOG/log
# mv $LOG/* $ERR_LOG
# echo "********This is Log of ReExecute $RMAN_SH_NAME,If you see this,That means the quality of Local Ftp server and Rman backups is is OK ********">>$LOG/log
#
cd $LOG
mv * $ERR_LOG
f_ssh
if [ $? -eq 0 ];
then echo "********If you see this,That means the quality of Local Ftp server and Rman backups is is OK ********">>$LOG/log
else echo "********Error to Reexecute $RMAN_SH_NAME.Please check it.Now exiting!!!!!!!!********">>$LOG/log exit 1
fi
fi
else
echo "********Congratulations!Ready:Remote Rman backups is:$REM_CNT and backup Server is:$BAK_CNT.Redy to check the size between Remote and Local backups!!!********">>$LOG/log
fi
}
f_ser
#############Create f_comp function
f_comp()
{
if [ $REM_SIZE -ne $BAK_SIZE ];
then echo "********Errors!!!Size of Rman backups and Ftp bakckups is not equal!!!Now to hand it ...********">>$LOG/log
echo "*******Wating,Now move bad temp backups from $BAK to $LOST!!!********">>$LOG/log
cd $BAK
mv * $LOST
if [ $? -ne 0 ];
then echo "********Move bad temp backups from $BAK to $LOST Failed!!!Remove bad backups...*********">>$LOG/log
cd $BAK
rm -Rf *
if [ $? -ne 0 ];
then echo "*******Rmove bad temp backups failed,Please check it.Read to exiting!!!*********">>$LOG/log
exit 1
fi
else echo "********Move bad temp backups from $BAK to $LOST Successfully!!!Now follow next f_all to do the next work...********">>$LOG/log
fi
else echo "********OK!The size of rman backups is:$REM_SIZE(M) and Ftp backup Server is:$BAK_SIZE (M).Now to handing the Good backups to its own dir...*********">>$LOG/log
fi
}
f_comp
########Create f_all function
f_all()
{
echo "========This is Server script. logs========">>$LOG/log
echo "********Now Creating backup directory $LOC/bak_$(date +'%F')********">>$LOG/log
DB='/home/bak/bak_db'
echo "********Now Recreate dir $DB/bak in $(date +'%F-%H-%M-%S')!!!********">>$LOG/log
if [ ! -d $DB/bak ];
then mkdir -p $DB/bak
if [ $? -ne 0 ];
then echo "********Create dir $DB/bak in $(date +'%F-%H-%M-%S') Failed.Now Recreate it...********">>$LOG/log
mkdir -p mkdir -p $DB/bak
if [ $? -ne 0 ];
then echo "********Recreate dir $DB/bak in $(date +'%F-%H-%M-%S') Failed.Exiting...********">>/$LOG/log
exit 1
else echo "********Recreate dir $DB/bak in $(date +'%F-%H-%M-%S') Successfully!********">>$LOG/log
fi
else echo "********Create backup directory $DB/bak in $(date +'%F-%H-%M-%S') Successfully!********">>$LOG/log
fi
fi
echo "********Now move $BAK temp backup to DB backup dir $DB/bak_$(date +'%F-%H-%M-%S')!!!...********">>$LOG/log
cd $BAK
mv * $DB/bak
if [ $? -ne 0 ];
then echo "********Errors when moving $BAK temp_backup dir to DB_backup dir $DB/bak_$(date +'%F-%H-%M-%S'),Now hand it...*********">>$LOG/log
cd $BAK
mv * $DB
if [ $? -ne 0 ];
then rm -rf *
if [ $? -ne 0 ];
then echo "********Remove bad temp bakcups in Ftp Server at $BAK,Now to Exsiting...*********">>$LOG/log
exit 1
fi
else
echo "********Successfully Move bad temp backups in Ftp Server to $DB ,Now to recreate rman backups and Ftping...*********">>$LOG/log
f_ser
if [ $? -ne 0 ];
then echo "*********Recreate Rman backups Filed!!!Existing...********">>$LOG/log
exit 1
fi
f_comp
if [ $? -ne 0 ];
then echo "*********Recreate Rman backups Filed!!!Existing...********">>$LOG/log
exit 1
fi
fi
fi
mv $DB/bak $DB/bak_$(date +'%F-%H-%M-%S')
if [ $? -eq 0 ];
then echo "********Rename $DB/bak to $DB/bak_$(date +'%F-%H-%M-%S') Successfully!!!">>$LOG/log
else echo "********Rename $DB/bak to $DB/bak_$(date +'%F-%H-%M-%S') Failed.Now handing it...Please waiting..........">>$LOG/log
cd $DB/bak
mv * $DB
if [ $? -ne 0 ];
then echo "********Handing backup from $DB/bak to $DB Done!!!Now to next step........">>$LOG/log
else echo "********Handing backup from $DB/bak to $DB Failed!!!Now to Clear $DB/bak and Recreate rman backup and FTping.........">>$LOG/log
f_ssh
f_comp
fi
fi
echo "********Now to move $LOG/log_$(date +'%F-%H-%M-%S') to Remote log Server!!!...********">>$LOG/log
cd $LOG
echo "========Script. end without error...!!!========">>$LOG/log
mv log log_$(date +'%F-%H-%M-%S')
scp $LOG/log_$(date +'%F-%H-%M-%S')
if [ $? -ne 0 ];
then echo "********Error when moving /share/ftp_sev_log to Remote log Server!!!,Saving it as error_log">>$LOG/log_$(date +'%F-%H-%M-%S')
cd $LOG
mv * $ERR_LOG
else
cd $LOG
mv * $ERR_LOG
fi
}
f_all
#######Ssh to rman to ftp backups
#if [ ! -d $LOC/ftp_up_log ];
# then mkdir -p /$LOC/ftp_up_log
#fi
#
#ssh sh /home/oracle/ftp_shell/ftp_223_bak.sh
#
#if [ $? -eq 0 ];
# then move $LOC/ftp_up_log/ftp_up.log $LOC/ftp_up_log/ftp_up.log_$(date +'%F-%X')
# more $LOC/ftp_up_log/ftp_up.log_$(date +'%F-%X')>>$LOG_LOC/log_$(date +'%F-%X')
#
#else echo "********Ftp_up.sh Failed!,Please check it quickly!********">>$LOG_LOC/log_$(date +'%F-%X')
#fi
#
########Check the number of backups between Oracle and Ftp Server
#
#RMAN_CNT='$(ssh ls /rman/ora_rman |wc -l)'
#if [ $RMAN_CNT -ne $BAK_CNT ];
# then echo "********Warnings!Rman backups is not the same as Backup Server backups,Please Check it!">>$LOG_LOC/log_$(date +'%F-%X')
# exit 1
#
#fi
#
#
#
#
######Move new backups to its own directory
#mv $LOC/bak/* $LOC/bak_$(date +'%F')
#
#if [ $? -ne 0 ];
# then echo "********Warings!Move backups to $LOC/bak_$(date +'%F') Failed,Please check it!********">>$ERR_LOC/err_log_$(date +'%F-%X')
#
#else echo "********Congratualations!Move all backups to $LOC/bak_$(date +'%F' Done!********">>$LOG_LOC/log_$(date +'%F-%X')
#fi
#
# more $LOC/ftp_up_log/ftp_up.log_$(date +'%F-%X')>>$
#
#echo "********Ftp and move new backups to its own directory Done!">>$LOG_LOC/log_$(date +'%F-%X')
通过这个脚本可以实现在无须第3放备份软件下也能实现对数据库的异地备份,因为该脚本有很多重传以及校验功能,花了俺几天时间呢合乎
优秀是种习惯,习惯也是一种优秀
文章浏览阅读7.8k次,点赞12次,收藏62次。C# Console 类主要用于控制台应用程序的输入和输岀操作。和的区别在于,前者读取是根据空白符隔开且返回int类型,后者是用的换行符返回string类型。举个例子,如果读取的数据是a使用读取字符a后会转化成对应的ascii码97使用读取字符a就会原样返回a函数介绍读取用户的输出,返回一个int类型读取用户的输入,返回一个string类型输出数据输出数据并换行读取用户输入,多用于暂停程序如果输入的数据是数字时,使用。_c#输出
文章浏览阅读10w+次,点赞209次,收藏506次。一. 在运行一个_源服务器未能找到目标资源的表示或者是不愿公开一个已经存在的资源表示。
文章浏览阅读2.3k次。链接 牛客OJ:两个链表的第一个公共结点 九度OJ:http://ac.jobdu.com/problem.php?pid=1505 GitHub代码: 037-两个链表的第一个公共结点 CSDN题解:剑指Offer–037-两个链表的第一个公共结点 牛客OJ 九度OJ CSDN题解 GitHub代码 037-两个链表的第一个公共结点 1505-_从链表的第一个结点开始扫描比较
文章浏览阅读2.9k次,点赞3次,收藏15次。常见的测试管理工具主要分为10类:测试管理工具接口测试工具性能测试工具C/S自动化工具白盒测试工具代码扫描工具持续集成工具网络测试工具app自动化工具web安全测试工具从企业团队的角度来说,测试工具的用途主要有两种:一类就是面对QA的功能测试,主要是满足测试人员对用例的维护,测试计划的建立,用例的执行,以及生成测试报告等,另一类就是面对开发人员的接口测试,功能测试,压力测试,性能测试,以及自动化测试,到最后的集成到流水线中。有的公司这块由专门的测试人员来做,而这是2种不同的使用场景,_测试管理相关的工具有哪些
文章浏览阅读532次。0x01 简介有人称它为“钩子”,有人称它为“挂钩”技术。谈到钩子,很容易让人联想到在钓东西,比如鱼钩就用于钓鱼。编程技术的钩子也是在等待捕获系统中的某个消息或者动作。钩子的应用范围非常广泛,比如输入监控、API拦截、消息捕获、改变程序执行流程等方面。杀毒软件会用Hook技术钩住一些API函数,比如钩住注册表读写函数,从而防止病毒对注册表进行写入;病毒使用Hook技术有针对性的捕获键盘的输入,从而..._windows通过hook获取新创建的进程
文章浏览阅读858次。操作系统原理——实验五:内存管理_Debug_实验5内存管理
文章浏览阅读2.1k次。判断素数 时间限制:400ms 内存限制:64MB 代码长度限制:16kB 判题程序:系统默认 作者:陈越 单位:浙江大学 本题的目标很简单,就是判断一个给定的正整数是否素数。 输入格式: 输入在第一行给出一个正整数N(\le≤ 10),随后N行,每行给出一个小于2^{31}231的需要判断的正整数。 输出格式: 对每个需要判断的正整数,如..._miller rabin素数判定算法c语言
文章浏览阅读7k次,点赞3次,收藏19次。ETX系列:EXT基础 EXT表单 EXT表格 EXT事件 EXT窗口 EXT按钮事件 什么是EXT?–Ext是一个Ajax框架,可以用来开发带有华丽外观的富客户端应用,使得我们的b/s应用更加具有活力及生命力,提高用户体验。–Ext是一个用javascript编写,与后台技_items: [{ id: 'xbankcheck', name: 'x_bank_check', fieldlabel: '银行检测情况(
文章浏览阅读369次。nodejstwoday引入模块var fs = require('fs')(在node中所有的异步都使用回调函数来实现的)同步 读取文件var data = fs.readFileSync('./demo.txt')txt内容是abc 输出出来是ascll码值 输出时要转为字符串形式var data = fs.readFileSync(’./demo.txt’)异步 读取文件..._nodejs readdir
文章浏览阅读266次。简介在Android官网中有对UI 优化的文档,开发者有必要对它进行掌握。详解1、抽象布局标签能够重用布局文件[html] view plaincopyinclude layout="@layout/titlebar"/> 标签可以删减多余的层级,它多用于替换FrameLayout或者当一个布局_android 高级ui定制
文章浏览阅读1.3k次。汪华:我记得从2009年,我们创新工场刚开始的时候,那一年开始,每年我大概都要到各个场合呼吁一下移动互联网。最早每年都说移动互联网这件事有多好,这个事明年、后年会怎么样。当时大家还是将信将疑,觉得这是一个什么东西。但是最近几年,我们当时关于移动互联网的预言都比较准确的实现了,从当时几百万,到现在已经5亿台设备。再往后看,10亿手机用户换成智能手机也是指日可待。我们当时做的公司只有几万用户,到几_知乎联合创始汪华简介
文章浏览阅读1.3k次,点赞2次,收藏7次。写在前面功能简介:1.scan-to-map匹配:提取当前激光帧特征点(角点、平面点),局部关键帧map的特征点,执行scan-to-map迭代优化,更新当前帧位姿;2.关键帧因子图优化; 关键帧加入因子图,添加激光里程计因子、GPS因子、闭环因子、执行因子图优化,更新所有关键帧的位姿;3.闭环检测:在历史关键帧中找距离相近,时间相隔较远的帧设为匹配帧,匹配帧周围提取局部关键帧地图,同样执行scan-to-map匹配,得到位姿变换,构建闭环因子数据,加入因子图优化。订阅:1.订阅当前激光帧点云信