1.Shared a folder which named "dbbak" , and at the same time create one new account for share rights access
2. vi /etc/rc.d/rc.local
/bin/mount -t cifs //192.168.*.20/dbbak -o username=itadmin,password=itadmin123 /backup
3. df -h
[root@APBAK ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda8 3.9G 453M 3.3G 13% /
/dev/sda7 3.9G 73M 3.7G 2% /home
/dev/sda6 3.9G 73M 3.7G 2% /tmp
/dev/sda3 20G 3.7G 15G 20% /usr
/dev/sda2 106G 9.2G 91G 10% /u01
/dev/sda1 996M 40M 905M 5% /boot
tmpfs 2.0G 1.2G 831M 58% /dev/shm
/dev/sdb1 690G 57G 598G 9% /data
//192.168.*.20/dbbak
1.9T 69G 1.8T 4% /backup
4. Edit backup scripts
[root@APBAK backup]# ll
total 44
-rw-r--r-- 1 root root 298 Nov 23 2011 daily_backup.sh
-rw-r--r-- 1 root root 14388 Oct 14 22:00 daily.log
-rw-r--r-- 1 root root 283 Nov 23 2011 full_backup.sh
-rw-r--r-- 1 root root 430 Oct 1 01:09 full.log
[root@APBAK backup]# cat daily_backup.sh
#!/bin/sh
##daily_backup.sh
Bakpath=/data/mu
Fullbakpath=/backup/monthly
Dailybakpath=/backup/daily
Month=`date +%B`
Date=`date +%Y-%m-%d`
tar -g $Fullbakpath/$Month -zcvf $Dailybakpath/ap_incremental_$Date.tar.gz $Bakpath
echo "$Date Incremental Backup Successfully!" >> /home/backup/daily.log
[root@APBAK backup]# cat full_backup.sh
#!/bin/sh
##full_backup.sh
Bakpath=/data/mu
Fullbakpath=/backup/monthly
Daillybakpath=/backup/daily
Month=`date +%B`
Date=`date +%Y-%m-%d`
tar -g $Fullbakpath/$Month -zcvf $Fullbakpath/ap_full_$Date.tar.gz $Bakpath
echo "$Month Full Backup Successfully!" >> /home/backup/full.log
*****
[root@DBSTY backup]# ll
total 44
-rwxr--r-- 1 oracle dba 312 Nov 23 2011 daily_backup.sh
-rw-r--r-- 1 oracle dba 14344 Oct 14 22:00 daily.log
-rwxr--r-- 1 oracle dba 543 Nov 23 2011 full_backup.sh
-rw-r--r-- 1 oracle dba 1326 Oct 2 23:20 full.log
[root@DBSTY backup]# cat daily_backup.sh
#!/bin/sh
##daily_backup.sh
Bakpath=/data/yldb/arch
Fullbakpath=/backup/monthly
Dailybakpath=/backup/daily
Month=`date +%B`
Date=`date +%Y-%m-%d`
tar -g $Dailybakpath/$Month -zcvf $Dailybakpath/database_incremental_$Date.tar.gz $Bakpath
echo "$Date Incremental Backup Successfully!" >> /home/backup/daily.log
[root@DBSTY backup]# cat full_backup.sh
#!/bin/sh
##full_backup.sh
/bin/sh /data/run/shutdown.sh
echo "Shutdown database successfully!" >>/home/backup/full.log
Bakpath01=/data/yldb
Bakpath02=/u01/product
Fullbakpath=/backup/monthly
Daillybakpath=/backup/daily
Month=`date +%B`
Date=`date +%Y-%m-%d`
tar -zcvf $Fullbakpath/database_full_$Date.tar.gz $Bakpath01
tar -zcvf $Fullbakpath/u01_full_$Date.tar.gz $Bakpath02
/bin/sh /data/run/startup.sh
echo "$Date Start database successfully!" >>/home/backup/full.log
echo "$Month Full Backup Successfully!" >> /home/backup/full.log
[root@CRMDBSTY backup]# crontab -l
30 2 * * 0 sh /data/run/ntp 1>>/data/run/log/ntp.log 2>>/data/run/log/ntp.bad
5.estabishment crontab script
crontab -l
[root@APBAK ~]# crontab -l
# Run daily cron jobs at 22:00 every day sync *AP mu:
0 8-20 * * * /bin/sh /etc/rsyncd/rsyncmu.sh > /dev/null 2>&1
# Run full backup job at 01:00 on the 1st monthly
0 1 1 * * /bin/sh /home/backup/full_backup.sh > /dev/null 2>&1
# Run incremental backup job at 22:00 every day
0 22 * * * /bin/sh /home/backup/daily_backup.sh > /dev/null 2>&1
6.Data backup result check
