crontab \u914d\u7f6e<\/p>
\u5468\u672b\u5168\u91cf\u5907\u4efd\uff0c\u5176\u4ed6\u65e5\u671f\u589e\u91cf\u5907\u4efd,\u6e05\u966415\u5929\u4ee5\u524d\u6587\u4ef6
0 5 * * * find \/app\/oracle11g\/product\/11.2.0\/archdir\/ecudb\/* -mtime +6 |xargs rm -fr<\/p>
#rmanbackup
30 4 * * 6 sh \/backup\/feikong\/scripts\/rman_backup_0.sh
30 4 * * 0,1,2,3,4,5 sh \/backup\/feikong\/scripts\/rman_backup_1.sh
30 4 * * * find \/backup\/data -ctime +15 -type f |grep -E "DB_0|DB_1|arch_" |xargs -L 1 rm -rf<\/p>
rman_backup_0.sh
#!\/bin\/bash
source ~\/.bash_profile
rq=`date +%Y%m%d`
rman target \/ log \/backup\/log\/rmanbackup_${rq}.log append<<EOF
set encryption on identified by "u9j04hkUvfRu" only;
run{
ALLOCATE CHANNEL ch1 TYPE disk;
ALLOCATE CHANNEL ch2 TYPE disk;
BACKUP INCREMENTAL LEVEL 0 TAG "DB0" DATABASE FORMAT "\/backup\/data\/DB_0_%T%U.bkp";
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
sql "alter system archive log current";
backup archivelog all format "\/backup\/data\/arch_%T%U.arc";
delete noprompt backup of archivelog until time "sysdate-8";
backup current controlfile format "\/backup\/data\/ctl_%T%U.ctl";
CROSSCHECK BACKUP;
CROSSCHECK backupset;
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT EXPIRED BACKUPSET;
REPORT OBSOLETE;
delete NOPROMPT obsolete device type disk;
RELEASE CHANNEL ch1;
RELEASE CHANNEL ch2;
}
exit
EOF<\/p>
rman_backup_1.sh
#!\/bin\/bash
source ~\/.bash_profile
rq=`date +%Y%m%d`
rman target \/ log \/backup\/log\/rmanbackup_${rq}.log append<<EOF
set encryption on identified by "u9j04hkUvfRu" only;
run{
ALLOCATE CHANNEL ch1 TYPE disk;
ALLOCATE CHANNEL ch2 TYPE disk;
BACKUP INCREMENTAL LEVEL 1 TAG "DB1" DATABASE FORMAT "\/backup\/data\/DB_1_%T%U.bkp";
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
sql "alter system archive log current";
backup archivelog all format "\/backup\/data\/arch_%T%U.arc";
delete noprompt backup of archivelog until time "sysdate-8";
backup current controlfile format "\/backup\/data\/ctl_%T%U.ctl";
CROSSCHECK BACKUP;
CROSSCHECK backupset;
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT EXPIRED BACKUPSET;
REPORT OBSOLETE;
delete NOPROMPT obsolete device type disk;
RELEASE CHANNEL ch1;
RELEASE CHANNEL ch2;
}
exit
EOF<\/p>