RMAN备份

发布时间 2023-07-16 19:34:51作者: 江曹

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)