1.设置定时任务
* 22 * * 6 su - oracle -c 'bash /home/oracle/script/rman_full.sh' * 23 * * 0-5 su - oracle -c 'bash /home/oracle/script/rman_lv1.sh' 30 1-23/2 * * 1-6 su - oracle -c 'bash /home/oracle/script/rman_arch.sh'
2.全备脚本(rman_full.sh)
#!/bin/bash source /home/oracle/.bash_profile rman target / log=/dbbackup/log/xxdb/full/full_xxdb_`data +%Y%m%d-%H%M%S`.log append << EOF run{ allocate channel c1 type disk; allocate channel c2 type disk; BACKUP as compressed backupset INCREMENTAL LEVEL=0 SKIP INACCESSIBLE TAG 'db_incr_level_0' FILESPERSET 5 FORMAT '/dbbackup/xxdb/FULL_%d_%T_%s' DATABASE INCLUDE CURRENT CONTROLFILE; backup as compressed backupset archivelog all format '/dbbackup/xxdb/arch_0_%s_%p_%t_%d' delete input; crosscheck backup; delete noprompt expired backup; delete noprompt obsolete; crosscheck archivelog all; delete noprompt expired archivelog all; release channel c1; release channel c2; } exit; EOF
2.增量备份脚本(rman_lv1.sh)