各类数据库备份策略归档

《各类数据库备份策略归档》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、一、电子校务Crontab1.数据方法：(每日备份)3019***/expoit/home/oracle/data_backup/dbbackup.sh3022***/export/home/oracle/test.sh3522***cat/export/home/oracle/ftpbk.txtlftp-nidbbackup.sh：ORACLE_BASE=/var/oracle/ora10exportORACLE_BASEORACLE_HOME=$ORACLE_BASE/productexportORACLE.HOMEORACLE_SID=heerexp

2、ortORACLE_S1DNLS_LANG=MS1MPLIFIEDCHINESE_CH1NA.ZHS16GBK"exportNLS_LANGLD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/libexportLD_LIBRARY_PATHrm/export/home/oracle/data_backup/*.gzpre=,,heerit_,,'date+%Y%m%d'preO=/export/home/oracle/data_backup/nnit_prddate+%Y%m%d'/var/oracl

3、e/ora10/product/bin/expnit_prd/*****file=$preO.dmplog=/expoit/home/oracle/data_backup/out.loggzipSpreO.dnip/export/home/oracle/data_backup/out.logtar-cvfSpreO.tar.gzSpreO.dmp.gz/export/home/oracle/data_backup/out.log.gzftpbk.txt:open10.0.90.10userwzq*****bincde_dataled/export/home

4、/oracle/data_backupmput*.taigzbye2.源代码网页文件见(sunappserver)3•各类文档bash-2.05#moreVFS_backup_NIT.sh#!/bin/bash#=======：=：==：===：===：===：==：====：====：===：=：=：=：===：=======：=============##VFSBackups,targetaimeddefaultat/export/home/vfsroot#Thisscripttendstodomonthlyincrementalbackups#No

5、te:TheVFSROOT'scontentswillincrementonadailybasis,finally#becomeveryBIG,thenAdminshouldremovesomeofthembyhand.#=====================================================#DOmodifythesevariablesBEFOREdoingthebackupsLC_ALL=zh_CNLANG=zh_CN.GBKLANGUAGE=zh_CN.GBK:zh_CN.GB2312:zh_CNLC_CTYPE=z

6、h_CN.GBKexportLC_ALLLANGLANGUAGELC_CTYPE#===========二===============================二##DefaultsettingMMMMMMMMMMMMMMMM=========#YY=date+%Y'#yyyyMM=vdate+%Y_%m、#yyyy_mm#LocalbackupdirectoryVFS_HOME=/export/home/vfsrootBACKUP_HOME=/heer_backup/vfsBACKUP_DIR=$BACKUP_HOME/$YY/$MMif[!-d

7、$VFS_HOME];thenecho”VFS_HOME[$VFS_HOME]isNOTFound.Hexit0flif[!-d$BACKUP_DIR];thenmkdir-p$BACKUP_DIRfi#LoggingfileLOG=$BACKUP_HOME/histo.LOGTTT=date+%F.%T'echo[$TTTJn—~~~~~~~—•—~~START~$TTT~~~~—•—*—~—•—n»$LOG#echo[$TTT]ucd$BACKUP_DIRM»$LOG#cd$BACKUP_DIRSAVE()=$BACKUP_DIR/vfsroot.$M

8、M.tarSAVE=$BACKUP_DIR/vfsroot.$MM