Oracle 11G&12C备份脚本

Oracle 11G&12C备份脚本

#对某服务器上的多个用户备份,自动删除N天前的备份数据#::::::::::::::::::::::::::::::::::::::::::::::::::::: 参数配置（需要管理员初始化）# param_oracleServerBin            可选    Oracle Server Bin所在目录# param_LocalNetServicesName    必选    本地Net服务器名    （tnsnames.ora中的名称，而不是sid）# param_homeBak_Local            可选    备份文件到本地        （dmp文件相关）    # param_homeBak_Remote             可选    备份文件复制到远程    （dmp文件相关）    # param_delFileDay_Local        可选    删除N天前本地备份    （dmp文件相关）# param_delFileDay_Remote        可选    删除N天前远程备份    （dmp文件相关）echo "==================================================="  export param_homeBak_Local=/opt/backupexport param_homeBak_Remote=export param_delFileDay_Local=export param_delFileDay_Remote=export param_oracleHome=/data/oracle/product/11.2.0/dbhome_1export param_LocalNetServicesName=ORCLexport User01=NC20181113export User02=export User03=export User04=export User05=export User06=export User07=export User08=export User09=export User10=export User11=export User12=export User13=export User14=export User15=export Pass01=NC20181113export Pass02=export Pass03=export Pass04=export Pass05=export Pass06=export Pass07=export Pass08=export Pass09=export Pass10=export Pass11=export Pass12=export Pass13=export Pass14=export Pass15=#::::::::::::::::::::::::::::::::::::::::::::::::::::: 以下内容不要调整#=================  生成日期 用于备份 export CurrentDateTime=`date +%Y%m%d%H%M%S`  #================= 重新设置变量# Home_Backup 当前sh位置export Home_Backup=$(pwd)export HomeBak_Local=$Home_Backupexport HomeBak_Remote=$Home_Backupif [[ $param_homeBak_Local != "" ]] ; then export HomeBak_Local=$param_homeBak_Local ;fiif [[ $param_homeBak_Remote != "" ]] ; then export HomeBak_Remote=$param_homeBak_Remote ;fiif [[ $param_delFileDay_Local = "" ]] ; then export param_delFileDay_Local=7 ;fiif [[ $param_delFileDay_Remote = "" ]] ; then export param_delFileDay_Remote=1 ;fiexport HomeBak_KeyName=OracleDbexport HomeBak_Local=$HomeBak_Local/$HomeBak_KeyName"_bakLocal"export HomeBak_Remote=$HomeBak_Remote/$HomeBak_KeyName"_bakRemote"export homeBak_TimeFolder=$CurrentDateTime"_"$HomeBak_KeyNameexport homeBak_TimeFolder_Local=$HomeBak_Localexport homeBak_TimeFolder_Remote=$HomeBak_Remote#================= 创建文件夹,删除N天前的备份文件夹#创建文件夹mkdir -p $homeBak_TimeFolder_Localmkdir -p $HomeBak_Remote#删除N天前文件find $homeBak_TimeFolder_Local -mtime +$param_delFileDay_Local -name "*.*" -exec rm -rf {} \; find $homeBak_TimeFolder_Remote -mtime +$param_delFileDay_Remote -name "*.*" -exec rm -rf {} \;#================= 备份Oracle# 创建新的路径+文件名export FileName_01=$homeBak_TimeFolder_Local/$CurrentDateTime"_"$User01export FileName_02=$homeBak_TimeFolder_Local/$CurrentDateTime"_"$User02export FileName_03=$homeBak_TimeFolder_Local/$CurrentDateTime"_"$User03export FileName_04=$homeBak_TimeFolder_Local/$CurrentDateTime"_"$User04export FileName_05=$homeBak_TimeFolder_Local/$CurrentDateTime"_"$User05export FileName_06=$homeBak_TimeFolder_Local/$CurrentDateTime"_"$User06export FileName_07=$homeBak_TimeFolder_Local/$CurrentDateTime"_"$User07export FileName_08=$homeBak_TimeFolder_Local/$CurrentDateTime"_"$User08export FileName_09=$homeBak_TimeFolder_Local/$CurrentDateTime"_"$User09export FileName_10=$homeBak_TimeFolder_Local/$CurrentDateTime"_"$User10export FileName_11=$homeBak_TimeFolder_Local/$CurrentDateTime"_"$User11export FileName_12=$homeBak_TimeFolder_Local/$CurrentDateTime"_"$User12export FileName_13=$homeBak_TimeFolder_Local/$CurrentDateTime"_"$User13export FileName_14=$homeBak_TimeFolder_Local/$CurrentDateTime"_"$User14export FileName_15=$homeBak_TimeFolder_Local/$CurrentDateTime"_"$User15export ORACLE_HOME=$param_oracleHomeexport PATH=$ORACLE_HOME/bin:$PATHif [[ $User01 != "" ]] && [[ $Pass01 != "" ]] ; then exp $User01/$Pass01@$param_LocalNetServicesName owner=$User01 file=$FileName_01.dmp log=$FileName_01.log ;fiif [[ $User02 != "" ]] && [[ $Pass02 != "" ]] ; then exp $User02/$Pass02@$param_LocalNetServicesName owner=$User02 file=$FileName_02.dmp log=$FileName_02.log ;fiif [[ $User03 != "" ]] && [[ $Pass03 != "" ]] ; then exp $User03/$Pass03@$param_LocalNetServicesName owner=$User03 file=$FileName_03.dmp log=$FileName_03.log ;fiif [[ $User04 != "" ]] && [[ $Pass04 != "" ]] ; then exp $User04/$Pass04@$param_LocalNetServicesName owner=$User04 file=$FileName_04.dmp log=$FileName_04.log ;fiif [[ $User05 != "" ]] && [[ $Pass05 != "" ]] ; then exp $User05/$Pass05@$param_LocalNetServicesName owner=$User05 file=$FileName_05.dmp log=$FileName_05.log ;fiif [[ $User06 != "" ]] && [[ $Pass06 != "" ]] ; then exp $User06/$Pass06@$param_LocalNetServicesName owner=$User06 file=$FileName_06.dmp log=$FileName_06.log ;fiif [[ $User07 != "" ]] && [[ $Pass07 != "" ]] ; then exp $User07/$Pass07@$param_LocalNetServicesName owner=$User07 file=$FileName_07.dmp log=$FileName_07.log ;fiif [[ $User08 != "" ]] && [[ $Pass08 != "" ]] ; then exp $User08/$Pass08@$param_LocalNetServicesName owner=$User08 file=$FileName_08.dmp log=$FileName_08.log ;fiif [[ $User09 != "" ]] && [[ $Pass09 != "" ]] ; then exp $User09/$Pass09@$param_LocalNetServicesName owner=$User09 file=$FileName_09.dmp log=$FileName_09.log ;fiif [[ $User10 != "" ]] && [[ $Pass10 != "" ]] ; then exp $User10/$Pass10@$param_LocalNetServicesName owner=$User10 file=$FileName_10.dmp log=$FileName_10.log ;fiif [[ $User11 != "" ]] && [[ $Pass11 != "" ]] ; then exp $User11/$Pass11@$param_LocalNetServicesName owner=$User11 file=$FileName_11.dmp log=$FileName_11.log ;fiif [[ $User12 != "" ]] && [[ $Pass12 != "" ]] ; then exp $User12/$Pass12@$param_LocalNetServicesName owner=$User12 file=$FileName_12.dmp log=$FileName_12.log ;fiif [[ $User13 != "" ]] && [[ $Pass13 != "" ]] ; then exp $User13/$Pass13@$param_LocalNetServicesName owner=$User13 file=$FileName_13.dmp log=$FileName_13.log ;fiif [[ $User14 != "" ]] && [[ $Pass14 != "" ]] ; then exp $User14/$Pass14@$param_LocalNetServicesName owner=$User14 file=$FileName_14.dmp log=$FileName_14.log ;fiif [[ $User15 != "" ]] && [[ $Pass15 != "" ]] ; then exp $User15/$Pass15@$param_LocalNetServicesName owner=$User15 file=$FileName_15.dmp log=$FileName_15.log ;fi#================= 复制到远程cp $homeBak_TimeFolder_Local/$CurrentDateTime*.* $homeBak_TimeFolder_Remote#:::::::::::::::::::::::::::::::::::::::::::::::::::::echo "Bakup completed."

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。