使用crontab和expdp实现数据库定期逻辑备份

$crontab -l
10 23 * * 0,1,3,5 /backup/exp_fulldb.sh
45 22 * * 0 /backup/del_obsolete.sh
0 20 1 * * /backup/del_nohup_out.sh

crontab列表解释
每周日,一,三五晚上23:10 ,运行/backup/exp_fulldb.sh,进行数据库的全库逻辑备份.
每周日22:45分,清除上一周的备份集文件,防止备份目录空间不足.
每月1日20:00,删除/backup/nohup.out文件.nohup.out文件记录了上一个月的备份日志情况.



$more /backup/exp_fulldb.sh
nohup expdp system/root_123 directory=imp_dir dumpfile=dbcenter_full_$(date +%Y%m%d%H%M)_%U.dmp cluster=n parallel=16 filesize=30g l
ogfile=dbcenter_full_$(date +%Y%m%d%H%M).log full=y &

备注:使用数据泵进行数据库逻辑导出,同时根据时间生成备份集的文件名,避免文件名重复.

$more /backup/del_obsolete.sh
rm -rf /backup/*.dmp
rm -rf /backup/*.log

$more /backup/del_nohup_out.sh
rm -rf /backup/nohup.out

备份后/backup目录的内容如下:
$ ls -lt
total 31030100
-rw-r----- 1 oracle oinstall 2461114368 May 23 17:07 dbcenter_full_201405231653_02.dmp
-rw-r----- 1 oracle oinstall 2624397312 May 23 17:07 dbcenter_full_201405231653_03.dmp
-rw-r----- 1 oracle oinstall 2403418112 May 23 17:07 dbcenter_full_201405231653_04.dmp
-rw-r----- 1 oracle oinstall 2264018944 May 23 17:07 dbcenter_full_201405231653_05.dmp
-rw-r----- 1 oracle oinstall 2187218944 May 23 17:07 dbcenter_full_201405231653_06.dmp
-rw-r----- 1 oracle oinstall 2356625408 May 23 17:07 dbcenter_full_201405231653_08.dmp
-rw-r----- 1 oracle oinstall 2132647936 May 23 17:07 dbcenter_full_201405231653_09.dmp
-rw-r----- 1 oracle oinstall 2068774912 May 23 17:07 dbcenter_full_201405231653_10.dmp
-rw-r----- 1 oracle oinstall 1738346496 May 23 17:07 dbcenter_full_201405231653_11.dmp
-rw-r----- 1 oracle oinstall 1783275520 May 23 17:07 dbcenter_full_201405231653_13.dmp
-rw-r----- 1 oracle oinstall 1477828608 May 23 17:07 dbcenter_full_201405231653_14.dmp
-rw------- 1 oracle oinstall      15959 May 23 17:07 nohup.out
-rw-r--r-- 1 oracle oinstall      15809 May 23 17:07 dbcenter_full_201405231653.log
-rw-r----- 1 oracle oinstall 2122567680 May 23 17:07 dbcenter_full_201405231653_07.dmp
-rw-r----- 1 oracle oinstall 1850421248 May 23 17:07 dbcenter_full_201405231653_15.dmp
-rw-r----- 1 oracle oinstall 2598641664 May 23 17:07 dbcenter_full_201405231653_01.dmp
-rw-r----- 1 oracle oinstall 1673379840 May 23 17:07 dbcenter_full_201405231653_12.dmp
-rw-r----- 1 oracle oinstall     933888 May 23 17:05 dbcenter_full_201405231653_16.dmp
-rwxr-xr-x 1 oracle oinstall        187 May 23 16:53 exp_fulldb.sh
-rwxr-xr-x 1 oracle oinstall         25 May 23 16:50 del_nohup_out.sh
-rwxr-xr-x 1 oracle oinstall         43 May 23 16:48 del_obsolete.sh
drwxr-xr-x 2 oracle oinstall      16384 May 21 10:38 lost+found

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/32980/viewspace-1168531/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/32980/viewspace-1168531/