rman备份策略

1，计划任务

5 4 3 * *  /export/home/oracle/backup_script/firstly/database_backup_0.sh
5 4 1,2 * * /export/home/oracle/backup_script/firstly/database_backup_2.sh
5 4 4-18 * * /export/home/oracle/backup_script/firstly/database_backup_2.sh
5 4 20-31 * * /export/home/oracle/backup_script/firstly/database_backup_2.sh
5 4 19 * *  /export/home/oracle/backup_script/firstly/database_backup_1.sh

2，database_backup_0.sh

#!/bin/bash
. /export/home/oracle/.profile
export ORACLE_SID=firstly1
/oracle/app/oracle/product/11.1.0/db_1/bin/rman target / log /backup/rman/log/firstly-`date +%Y-%m-%d_%H-%M-%S`.log cmdfile=/export/home/oracle/backup_script/firstly/database_backup_0.rman >/dev/null 2>&1
/usr/bin/find /backup/rman/log -name "firstly-20*.log" -mtime +90 -exec rm -rf {} \;

3,database_backup_0.rman 

run{
backup as compressed backupset incremental level=0 format='/backup/rman/firstly/%d_DF_%s_%p_%T_%t.bak' database include current controlfile plus archivelog format='/backup/rman/firstly/%d_AL_%s_%p_%T_%t.bak' delete all input;
delete noprompt obsolete;
}

4,database_backup_2.sh 

#!/bin/bash
. /export/home/oracle/.profile
export ORACLE_SID=firstly1
/oracle/app/oracle/product/11.1.0/db_1/bin/rman target / log /backup/rman/log/firstly-`date +%Y-%m-%d_%H-%M-%S`.log cmdfile=/export/home/oracle/backup_script/firstly/database_backup_2.rman >/dev/null 2>&1
/usr/bin/find /backup/rman/log -name "firstly-20*.log" -mtime +90 -exec rm -rf {} \;

5,database_backup_2.rman 

run{
backup as compressed backupset incremental level=2 format='/backup/rman/firstly/%d_DF_%s_%p_%T_%t.bak' database plus archivelog format='/backup/rman/firstly/%d_AL_%s_%p_%T_%t.bak' delete all input;
delete noprompt obsolete;
}

6,database_backup_1.sh 

#!/bin/bash
. /export/home/oracle/.profile
export ORACLE_SID=firstly1
/oracle/app/oracle/product/11.1.0/db_1/bin/rman target / log /backup/rman/log/firstly-`date +%Y-%m-%d_%H-%M-%S`.log cmdfile=/export/home/oracle/backup_script/firstly/database_backup_1.rman >/dev/null 2>&1
/usr/bin/find /backup/rman/log -name "firstly-20*.log" -mtime +90 -exec rm -rf {} \;

7, database_backup_1.rman 

run{
backup as compressed backupset incremental level=1 format='/backup/rman/firstly/%d_DF_%s_%p_%T_%t.bak' database plus archivelog format='/backup/rman/firstly/%d_AL_%s_%p_%T_%t.bak' delete all input;
delete noprompt obsolete;
}