Oracle±¸·Ý½Å±¾

Ä¿±ê£ºÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£¬Ö»Òª»á¼òµ¥µÄlinuxÃüÁî¾ÍÄÜʵÏÖoracle expµÄ×Ô¶¯±¸·Ý
 
»·¾³£ºlinux as3+oracle9i
¾ßÌåµÄ²½Ö裺
 
1.ÓʼþÉèÖÃ
[root@sxapp1 mail]# cd /etc/mail
[root@sxapp1 mail]# mv submit.cf submit.cfbak
[root@sxapp1 spool]# chmod a+wrx mqueue/
[root@sxapp1 mail]# echo "sdsdssd"|mail -s "sda"westlife_xu@eyou.com
2.½¨Á¢±¸·ÝĿ¼
[root@sxapp1 mail]# su - oracle
[oracle@sxapp1 oracle]$ mkdir -p /home/oracle/phy_backup/data --±¸·ÝÎļþ´æ·ÅĿ¼
[oracle@sxapp1 oracle]$ mkdir -p /home/oracle/phy_backup/log  --±¸·ÝµÄlog·¾¶
[oracle@sxapp1 oracle]$ cd /home/oracle/phy_backup
 
3.±¸·Ý½Å±¾±àд£¬²âÊÔ£¨½Å±¾Òª¸ù¾ÝÐèÇó΢µ÷£¬ÎÒÒѾ­²âÊÔͨ¹ýÁË£©
[oracle@sxapp1 phy_backup]$ vi exp.sh
#!/bin/sh
. /home/oracle/.bash_profile
#define variable......
backup_date=`date +%Y%m%d`
bak_home=/home                           --df -kÀïÃæ±ØÐëÄÜ¿´¼û
backup_dest=/home/oracle/phy_backup/data --¸ù¾ÝÐèÒªÌîд
backup_log=/home/oracle/phy_backup/log   --¸ù¾ÝÐèÒªÌîд
RECIPT='westlife_xu@eyou.com'            --±¨¾¯ÓʼþÉèÖÃ
 
--¼ì²é´ÅÅÌ¿Õ¼ä
# Check local disk space..................................
USED=` df -k|grep $bak_home|awk '{print $5}'|awk -F% '{print $1}'`
if [ $USED -gt 85 ]; then
       echo "Disk space is full\243\254please check it"|mail -s "exp full backup failed"  $RECIPT
       exit 1
fi
--¿ªÊ¼±¸·Ý
#starting exp backup.....
exp system/abc123 full=y buffer=65536   file=$backup_dest/data_$backup_date.dmp  log=$backup_log/data_$backup_date.log
--ɾ³ý¹ýÆڵı¸·ÝÎļþ
# delete expired  backup ...
list=` find $backup_dest -mtime +7`
echo $list
rm -f $list
if [ $? -ne 0 ]; then
       cat $backup_log/data_$backup_date.log|mail -s