使用類型：系統負載集中在某那個時間段，如白天8小時，晚上基本很閑，所以在晚上就可以對數據進行備份 與之相對應的是全庫備份： http://blog.csdn.net/jacson_bai/article/details/39636915 1、ENV: IP: 10.244.171.180/181 Oracle database Oracle 11.2.0.

使用類型：系統負載集中在某那個時間段，如白天8小時，晚上基本很閑，所以在晚上就可以對數據進行備份

與之相對應的是全庫備份：

http://blog.csdn.net/jacson_bai/article/details/39636915

1、ENV:
IP: 10.244.171.180/181
Oracle database Oracle 11.2.0.3
OS RHEL 5.5
Backup Toos:RMAN，shell,crontab

2、備份計劃（增量計劃）
Sunday :execute level 0 incremental back
Monday :execute level 2 incremental back
Tuesday :execute level 2 incremental back
Wednesday:execute level 1 incremental back
Thursday :execute level 2 incremental back
Friday :execute level 2 incremental back
Saturday :execute level 2 incremental back

3、在Node2規劃backup 目錄
--先創建保存備份腳本的目錄
$mkdir -p /Data/scripts/rman/
--創建備份數據的目錄
$mkdir -p /Data/rmandata/ --存放備份的數據目錄

3、制定*.sql和rman_backup.sh腳本

--全備lv0級：
$cd /Data/scripts/rman/
$vi backup_lv0.sql
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
backup incremental level 0 database
include current controlfile format '/Data/rmandata/backup_%T_%s_%U_%t.lv0'
plus archivelog delete all input format '/Data/arch/backup_%T_%s_%p_%t.arc';
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
--增量備lv1級：
vi backup_lv1.sql
run{
allocate channel c1 type disk;
backup incremental level 1 database include current controlfile
format '/Data/rmandata/backup_%T_%s_%p.lv1';
release channel c1;
}
--累計備lv2級：
$vi backup_lv2.sql
run{
allocate channel c1 type disk;
backup incremental level 2 database include current controlfile
format '/Data/rmandata/backup_%T_%s_%p.lv2';
release channel c1;
}

4、編寫shell腳本
--腳本要實現的功能：
1.正確判斷星期
2.記錄每個rman備份運行的時間

#!/bin/bash
source /home/oracle/.bash_profile
myweek=`date +%a`
mydate=`date +%Y%m%d`
mydir=/Data/
#Monday
if [ "$myweek" == "Mon" ]; then
rman target sys/oracle msglog=${mydir}/backup_${mydate}.log cmdfile=${mydir}/scripts/rman/backup_lv2.sql
fi
#Tuesday
if [ "$myweek" == "Tue" ]; then
rman target sys/oracle msglog=${mydir}/backup_${mydate}.log cmdfile=${mydir}/scripts/rman/backup_lv2.sql
fi
#Wednesday
if [ "$myweek" == "Wed" ]; then
rman target sys/oracle msglog=${mydir}/backup_${mydate}.log cmdfile=${mydir}/scripts/rman/backup_lv1.sql
fi
#Thursday
if [ "$myweek" == "Thu" ]; then
rman target sys/oracle msglog=${mydir}/backup_${mydate}.log cmdfile=${mydir}/scripts/rman/backup_lv2.sql
fi
#Friday
if [ "$myweek" == "Fri" ]; then
rman target sys/oracle msglog=${mydir}/backup_${mydate}.log cmdfile=${mydir}/scripts/rman/backup_lv2.sql
fi
#Saturday
if [ "$myweek" == "Sat" ]; then
rman target sys/oracle msglog=${mydir}/backup_${mydate}.log cmdfile=${mydir}/scripts/rman/backup_lv2.sql
fi
#Sunday
if [ "$myweek" == "Sun" ]; then
rman target sys/oracle msglog=${mydir}/backup_${mydate}.log cmdfile=${mydir}/scripts/rman/backup_lv0.sql
fi

5、crontab腳本指定
$crontab -e
30 20 * * * sh /Data/script/rman/rman_backup.sh;

聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com