I'll be back!

　　Focus on BPM, celebrate PegaRULES Process Commander (PRPC)

posts - 76, comments - 161, trackbacks - 0, articles - 2

:: 管理

Oracle backup script in SUSE Linux

Posted on 2006-11-21 18:55 zolly 閱讀(1037) 評論(1) 編輯收藏

在Linux 下用命令exp執(zhí)行的備份Oracle數(shù)據(jù)庫腳本文件*.sh

export?ORACLE_HOME=/opt/oracle/product/10gR2

export?PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin

time=`date?'+%y%m%d'`

DmpFilePath=/usr/backup/dmpfiles

LogFilePath=/usr/backup/log

exp?ELIPS/ELIPS@ORCL??file=$DmpFilePath/itrack_ELIPS_$time.dmp?log=$LogFilePath/itrack_ELIPS_$time.log

exp?COMPANY/COMPANY@ORCL??file=$DmpFilePath/itrack_COMPANY_$time.dmp?log=$LogFilePath/itrack_COMPANY_$time.log

exp?TIMESHEET/TIMESHEET@ORCL??file=$DmpFilePath/itrack_TIMESHEET_$time.dmp?log=$LogFilePath/itrack_TIMESHEET_$time.log

可直接運行，已可以用Linux的定時任務(wù)系統(tǒng)Cron進行定時備份，具體請見：http://www.aygfsteel.com/zolly/archive/2006/11/21/Linux_Cron.html

2006-11-21 20:43 by 冷面閻羅

恩不錯
可以借鑒一下
我們這邊的數(shù)據(jù)庫服務(wù)器是window的，不過我做計劃任務(wù)簡單的很就寫一句話


只有注冊用戶登錄后才能發(fā)表評論。




網(wǎng)站導(dǎo)航: 博客園 IT新聞 Chat2DB C++博客博問管理

	Pega Lead System Architect
	Pega Senior System Architect
	Pega System Architect
	Sun Certified Java Programmer
	Cognizant Certified Pega System Architect V4.2, CoreJava
	Macromedia Certified Web Designer
Email:	shzolly@gmail.com