linuxÏÂoracleµÄ×Ô¶¯±¸·Ý

linuxÏÂoracleµÄ×Ô¶¯±¸·Ý
http://hohai2002.blog.163.com/blog/static/1628166912010323103227543/
±¸·Ý
ÉÏ´«root_cronµ½rootĿ¼
ʹÓÃcrontab ÅäÖÃÎļþ
crontab -u root /root/root_cron
ʹÓÃcrontab -l ¼ì²é
#Îļþ root_cron
01 00 * * * /etc/root_exp.sh
#Îļþroot_exp.sh
su - oracle -c /oracle/db_exp.sh
#Îļþdb_exp.sh
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LIBPATH=$ORACLE_HOME/lib
DATE=`date +%y-%m-%d`
datename=${DATE}
exp yjeas59/yjeas59 file=/orabak/${datename}.dmp
½« root_exp.sh ·Åµ½/etc
½« db_exp.sh ·Åµ½ /oracleÏÂ
chmod -R 775 /etc/root_exp.sh
chown -R oracle:dba /oracle/dba_exp.sh
chmod -R 775 /oracle/dba_exp.sh
×Ô¼ºÊÖ¹¤ÐÞ¸Äorabak£¬±¸·ÝÎļþ´æ·ÅµØÖ·¡£
>>>>>>>>>>>>>>>>>>>>>>>>>>>>
rootÓû§ÊäÈëcrontab -e,ĩβ׷¼Ó£¨vi±à¼­Æ÷£©
0 0 * * * su - oracle -c "exp easdata/kingdee
file=/oradata/databackup/eas.dmp"
ÿÌì0µãexpÊý¾Ý£¬Ç°ÃæÓÐ5¸ö²ÎÊý£¨ÆäʵÊÇ6¸ö£¬ÓÐÒ»¸öûÓÐÓã©£¬¾ßÌ庬Òågoogle
×¢ÒâÒª¸ü¸ÄÄ¿±ê·¾¶µÄȨÏÞ
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
crontab -u root /root/orabak1.sh
ʹÓÃcrontab -l ¼ì²é
orabak1.sh(rootÓû§)
su - oracle -c /appscript/orabak2.sh
orabak2.sh(oracleÓû§)
rq=` date +%Y%m%d `
exp oraycerp2/kingdee file=/orabak/$rq.dmp
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
20090716
chmod 775 kingdeebak
#Îļþ kingdeebak
01 00 * * * /scripts/kingdee_exp1.sh
ʹÓÃcrontab  
crontab -u root /root/kingdeebak
ʹÓÃcrontab -l ¼ì²é
kingdee_exp1.sh
su - oracle -c /scripts/kingdee_exp2.sh
kingdee_exp2.sh
rq=` date +%Y%m%d `
exp oraycerp2/kingdee file=/oraback/easback/