rman備份的shell指令碼(例子)
#Set oracle path
#source $HOME/.keychain/${HOSTNAME}-sh
export SSH_AUTH_SOCK
echo $SSH_AUTH_SOCK
export PATH
unset USERNAME
export LD_ASSUME_KERNEL=2.4.1
export ORACLE_BASE=/opt/oracle9i
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
export ORACLE_SID=back1
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
#echo "-----------資料庫環境設定完成-----------"
# Set shell search paths
export PATH=$ORACLE_HOME/bin:$PATH
export NLS_LANG=american_america.ZHS16GBK
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
#echo "----------指令碼搜尋環境設定完成----------"
# set the backup script enviroment variable.
#export USERPASS=/nolog
export BACKUP_BASE=/home/oracle/backup
export BACKUP_TARGET=${BACKUP_BASE}/data
#export TABLESPACE_TARGET=${BACKUP_TARGET}/tablespace
export DATABASE_TARGET=${BACKUP_TARGET}/database
export CTRFILE_TARGET=${BACKUP_TARGET}/ctrfile
#export ARCLOG_TARGET=${BACKUP_TARGET}/arclog
export LOG_TARGET=${BACKUP_BASE}/log
#echo "--------備份指令碼環境變數設定完成---------"
#當前時間
CurDate=`date +%Y-%m-%d_%H:%M:%S`
LogDate=`date +%Y-%m-%d`
#ORACLE使用者的使用者名稱
OraUser=oracle
#要備份的表空間變數與登陸資料庫的使用者
#TableSpace=shiyihai #只在備份表空間時需要
User=sys
Psw=sys
DataBase=back2
#恢復目錄使用者，表空間與資料庫名
RmanTs=rman_ts
RmanUser=rman
RmanPsw=rman
RmanDB=test2
#echo "-----------備份伺服器設定完成-------------"
#引數校驗
if [ "p"$1 = "p/?" ]
then
echo "Usage:rman_db.sh Command"
echo "------------------------------------------------"
echo "Command : backup (0,1,2,3,4) （增量備份的基礎策略備份）"
echo "Parameter - 0 （全量備份）"
echo "Parameter - 1 （一級增量備份）"
echo "Parameter - 2 （二級增量備份）"
echo "Parameter - 3 （三級增量備份）"
echo "Parameter - 4 （四級增量備份）"
echo "------------------------------------------------"
echo "Command : full （備份整個資料庫）"
echo "------------------------------------------------"
echo "Command : listts （顯示錶空間備份歷史記錄）"
echo "------------------------------------------------"
echo "Command : listdb （顯示資料庫備份歷史記錄）"
echo "------------------------------------------------"
#echo "Command : arclog （備份歸檔日誌並刪除）"
#echo "------------------------------------------------"
# echo "Command : recoverts （恢復表空間）"
exit
fi
if [ "p"$1 = "p" -o "p"$1$2 = "pbackupts" -o "p"$1$2 = "pbackupdb" ]
then
echo "Usage:rman_db.sh Command"
echo "------------------------------------------------"
echo "Command : backup (0,1,2,3,4) （增量備份的基礎策略備份）"
echo "Parameter - 0 （全量備份）"
echo "Parameter - 1 （一級增量備份）"
echo "Parameter - 2 （二級增量備份）"
echo "Parameter - 3 （三級增量備份）"
echo "Parameter - 4 （四級增量備份）"
echo "------------------------------------------------"
echo "Command : full （備份整個資料庫）"
echo "------------------------------------------------"
echo "Command : listts （顯示錶空間備份歷史記錄）"
echo "------------------------------------------------"
echo "Command : listdb （顯示資料庫備份歷史記錄）"
echo "------------------------------------------------"
# echo "Command : arclog （備份歸檔日誌並刪除）"
# echo "------------------------------------------------"
# echo "Command : recoverts （恢復表空間）"
exit
fi
if [ "p"$1$2 != "pbackup0" -a "p"$1$2 != "pbackup1" -a "p"$1$2 != "pbackup2" -a "p"$1$2 != "pbackup3" -a "p"$1$2 != "pbackup4" -a "p"$1 != "pfull" -a "p"$1 != "plistdb" ]
then
echo "Usage:rman_db.sh Command"
echo "------------------------------------------------"
echo "Command : backup (0,1,2,3,4)（備份資料庫）"
echo "Parameter - 0 （增量備份的基礎策略備份）"
echo "Parameter - 1 （一級增量備份）"
echo "Parameter - 2 （二級增量備份）"
echo "Parameter - 3 （三級增量備份）"
echo "Parameter - 4 （四級增量備份）"
echo "------------------------------------------------"
echo "Command : full （備份整個資料庫）"
echo "------------------------------------------------"
echo "Command : listts （顯示錶空間備份歷史記錄）"
echo "------------------------------------------------"
echo "Command : listdb （顯示資料庫備份歷史記錄）"
echo "------------------------------------------------"
# echo "Command : arclog （備份歸檔日誌並刪除）"
# echo "------------------------------------------------"
# echo "Command : recoverts （恢復表空間）"
exit
fi
echo "HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH" >>${LOG_TARGET}/${LogDate}.log
#----------------------------------------------------------------------------------
#測試主備份目錄是否可寫
if ! test -w ${BACKUP_BASE}
then
echo "沒有對${BACKUP_BASE}資料夾的寫許可權" >>${LOG_TARGET}/${LogDate}.log
echo "`date +%Y.%m.%d.%H.%M.%S`備份終止" >>${LOG_TARGET}/${LogDate}.log
echo "TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT"
exit 1
fi
#------------------------------------------------------------------------------------
#檢查資料夾是否存在
if ! test -d ${BACKUP_TARGET}
then
echo "-----沒有備份目錄，自動建立-----" >>${LOG_TARGET}/${LogDate}.log
mkdir ${BACKUP_TARGET}
fi
#if ! test -d ${TABLESPACE_TARGET}
#then
# echo "-----沒有備份目錄，自動建立-----" >>${LOG_TARGET}/${LogDate}.log
# mkdir ${TABLESPACE_TARGET}
#fi
#if ! test -d ${DATABASE_TARGET}
#then
# echo "-----沒有備份目錄，自動建立-----" >>${LOG_TARGET}/${LogDate}.log
# mkdir ${DATABASE_TARGET}
#fi
#if ! test -d ${CTRFILE_TARGET}
#then
# echo "-----沒有備份目錄，自動建立-----" >>${LOG_TARGET}/${LogDate}.log
# mkdir ${CTRFILE_TARGET}
#fi
#if ! test -d ${ARCLOG_TARGET}
#then
# echo "-----沒有備份目錄，自動建立-----" >>${LOG_TARGET}/${LogDate}.log
# mkdir ${ARCLOG_TARGET}
#fi
#------------------------------------------------------------------------------------
if ! test -d ${LOG_TARGET}
then
echo "-----沒有日誌目錄，自動建立-----" >>${LOG_TARGET}/${LogDate}.log
mkdir ${LOG_TARGET}
fi
#----------------------------------------------------------------------------------
#echo "$CurDate 備份開始"
#-----------------------------------------------------------------------------------
#顯示相關目錄
#echo "基礎備份目錄 : " ${BACKUP_BASE}
#echo "備份資料檔案目錄 : " ${BACKUP_TARGET}
#echo "表空間備份目錄 : " ${TABLESPACE_TARGET}
#echo "資料庫備份目錄 : " ${DATABASE_TARGET}
#echo "歸檔日誌備份目錄 : " ${ARCLOG_TARGET}
#echo "日誌目錄 : " ${LOG_TARGET}
#------------------------------------------------------------------------------------
#表空間備份
#if [ $1 = "backupts" ]
#then
#echo "`date +%Y-%m-%d_%H:%M:%S`開始${TABLESPACE}表空間備份" >>${LOG_TARGET}/${LogDate}.log
#rman target catalog <>${LOG_TARGET}/${LogDate}.log
# run {
# allocate channel dev1 type disk;
# backup
# incremental level $2
# filesperset 4
# format "${TABLESPACE_TARGET}/${TableSpace}_level${2}_s%s_t%t_p%p.bak"
# (tablespace ${TableSpace});
# }
# exit;
#EOF
# echo "`date +%Y-%m-%d_%H:%M:%S`${TABLESPACE}表空間備份結束" >>${LOG_TARGET}/${LogDate}.log
# echo "TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT" >>${LOG_TARGET}/${LogDate}.log
#fi
#資料庫備份
if [ $1 = "backup" ]
then
echo "`date +%Y-%m-%d_%H:%M:%S`開始${DataBase}資料庫備份" >>${LOG_TARGET}/${LogDate}.log
rman target catalog <>${LOG_TARGET}/${LogDate}.log
run {
allocate channel dev1 type disk;
backup
incremental level $2
filesperset 4
format "${BACKUP_TARGET}/%d_level${2}_s%s_t%t_p%p.bak"
(database);
}
exit;
EOF
echo "`date +%Y-%m-%d_%H:%M:%S`${DataBase}資料庫備份結束" >>${LOG_TARGET}/${LogDate}.log
echo "TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT" >>${LOG_TARGET}/${LogDate}.log
fi
#顯示錶空間備份歷史記錄
if [ $1 = "listts" ]
then
rman target catalog < list backupset of tablespace $TableSpace;
exit;
EOF
fi
#顯示資料庫備份歷史記錄
if [ $1 = "listdb" ]
then
rman target catalog < list backupset of database database;
exit;
EOF
fi
#備份整個資料庫
if [ $1 = "full" ]
then
echo "`date +%Y-%m-%d_%H:%M:%S`開始備份${DataBase}資料庫" >>${LOG_TARGET}/${LogDate}.log
rman target catalog <>${LOG_TARGET}/${LogDate}.log
run {
allocate channel dev1 type disk;
backup
full
format "${BACKUP_TARGET}/%d_Full_s%s_t%t_p%p.bak"
(database);
}
exit;
EOF
echo "`date +%Y-%m-%d_%H:%M:%S`${DataBase}資料庫備份結束" >>${LOG_TARGET}/${LogDate}.log
echo "TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT" >>${LOG_TARGET}/${LogDate}.log
fi
#備份歸檔日誌並刪除
#if [ $1 = "arclog" ]
#then
#echo "`date +%Y-%m-%d_%H:%M:%S`開始備份歸檔日誌" >>${LOG_TARGET}/${LogDate}.log
#rman target catalog <>${LOG_TARGET}/${LogDate}.log
# run {
# allocate channel dev1 type disk;
# backup
# format "${ARCLOG_TARGET}/ARCLOG_s%s_t%t_p%p.bak"
# (archivelog all delete input);
# }
# exit;
#EOF
# echo "`date +%Y-%m-%d_%H:%M:%S`備份歸檔日誌結束" >>${LOG_TARGET}/${LogDate}.log
# echo "TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT" >>${LOG_TARGET}/${LogDate}.log
#fi
#恢復表空間
#if [ $1 = "recoverts" ]
#then
#echo "`date +%Y-%m-%d_%H:%M:%S`開始恢復表空間" >>${LOG_TARGET}/${LogDate}.log
#rman target catalog <>${LOG_TARGET}/${LogDate}.log
# run {
# allocate channel dev1 type disk;
# sql "alter tablespace ${TABLESPACE} offline immediate";
# restore tablespace ${TABLESPACE};
# recover tablespace ${TABLESPACE};
# sql "alter tablespace ${TABLESPACE} online";
# }
# exit;
#EOF
# echo "`date +%Y-%m-%d_%H:%M:%S`恢復表空間結束" >>${LOG_TARGET}/${LogDate}.log
# echo "TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT" >>${LOG_TARGET}/${LogDate}.log
#fi
#恢復資料庫
#if [ $1 = "recoverdb" ]
#then
#echo "`date +%Y-%m-%d_%H:%M:%S`開始恢復資料庫" >>${LOG_TARGET}/${LogDate}.log
#rman target catalog <>${LOG_TARGET}/${LogDate}.log
# run {
# allocate channel dev1 type disk;
# sql "alter tablespace ${TABLESPACE} offline immediate";
# restore tablespace ${TABLESPACE}
# recover tablespace ${TABLESPACE}
# sql "alter tablespace ${TABLESPACE} online";
# }
# exit;
#EOF
# echo "`date +%Y-%m-%d_%H:%M:%S`恢復資料庫結束" >>${LOG_TARGET}/${LogDate}.log
# echo "TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT" >>${LOG_TARGET}/${LogDate}.log
#fi
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/38542/viewspace-893557/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Rman備份的shell指令碼指令碼
- linux 下RMAN備份shell指令碼Linux指令碼
- Nocatalog 下的RMAN 增量備份 shell指令碼指令碼
- rman 備份指令碼指令碼
- rman備份指令碼指令碼
- 使用rman備份的指令碼指令碼
- rman備份和增量備份指令碼指令碼
- rman 全備份指令碼指令碼
- rman增量備份指令碼指令碼
- windows rman備份指令碼Windows指令碼
- RMAN常用備份指令碼指令碼
- oracle RMAN備份指令碼Oracle指令碼
- Linux 平臺下 RMAN 全備 和 增量備份 shell 指令碼Linux指令碼
- Oracle 11g EXPDP、RMAN自動備份SHELL指令碼Oracle指令碼
- 分享Oracle Rman的備份指令碼Oracle指令碼
- [Oracle] rman備份的指令碼(1)Oracle指令碼
- ORACLE RMAN備份的指令碼配置Oracle指令碼
- [Oracle] rman備份指令碼(2)Oracle指令碼
- oracle rman備份指令碼收集Oracle指令碼
- Windows下RMAN備份指令碼Windows指令碼
- RMAN全庫備份指令碼指令碼
- RMAN備份Shel指令碼示例指令碼
- rman的備份檢視的指令碼指令碼
- RAC模式下的備份策略以及RMAN備份指令碼模式指令碼
- oracle rman 定時備份指令碼Oracle指令碼
- RMAN定時全備份指令碼指令碼
- 轉貼：RMAN備份指令碼(Unix)指令碼
- rman 自動備份指令碼-windows指令碼Windows
- oracle rman備份恢復的例子Oracle
- 使用shell 指令碼備份資料指令碼
- mysql定時備份shell指令碼MySql指令碼
- ORACLE自動備份shell指令碼Oracle指令碼
- RAC模式下的備份策略以及RMAN備份指令碼（轉）模式指令碼
- RAC模式下的備份策略以及RMAN備份指令碼(ZF)模式指令碼
- 一個完整的RMAN備份指令碼(轉)指令碼
- MySQL資料庫備份的shell指令碼MySql資料庫指令碼
- oracle11g Rman 備份指令碼Oracle指令碼
- RMAN備份歸檔日誌指令碼指令碼