RAC下的備份策略V1.1

hp-ux 11.11

oracle 9.2.0.6 RAC

本文可以任意轉載，轉載時請務必以超連結形式標明文章原始出處和作者資訊及本宣告

http://blog.itpub.net/post/11/11499

兩個節點,RACA&RACB

1.每天晚上22:00 執行資料庫全備份到共享磁碟上

2.每天晚上23:50分執行歸檔日誌備份到兩個節點上

3.每天凌晨1:00啟動dp備份分別把資料庫全備份/兩個節點上的歸檔日誌備份儲存到磁帶庫上,同時刪除資料庫備份和歸檔日誌備份

指令碼:

# crontab -l
#0 22 * * 0,1,2,4,5 su - oracle -c /opt/app/oracle/backup/script/backup_level1.sh > /opt/app/oracle/backup/log/backup_level1.log
#0 22 * * 6 su - oracle -c /opt/app/oracle/backup/script/backup_level0.sh > /opt/app/oracle/backup/log/backup_level0.log
#0 22 * * 3 su - oracle - c /opt/app/oracle/backup/script/backup_level1_cum.sh > /opt/app/oracle/backup/log/backup_level1_cum.log
0 22 * * * su - oracle - c /opt/app/oracle/backup/script/backup_full.sh > /opt/app/oracle/backup/log/backup_full.log
0 12,18 * * * su - oracle -c /opt/app/oracle/backup/script/backup_archivelog.sh > /opt/app/oracle/backup/log/backup_1.log
50 23 * * * su - oracle -c /opt/app/oracle/backup/script/backup_archivelog.sh > /opt/app/oracle/backup/log/backup_2.log
#45 12,18 * * * su - oracle -c /opt/app/oracle/backup/script/cp_archivelog.sh > /opt/app/oracle/backup/log/cp_archivelog.log
# omnitrig entry was automatically added by
0,15,30,45 * * * * /opt/omni/sbin/omnitrig

#資料庫全備份
#backup_full.sh
rman target / catalog exit;

#備份歸檔日誌
#backup_archivelog.sh
rman target / catalog rman/@catalog ALLOCATE CHANNEL node_c1 DEVICE TYPE DISK CONNECT 'sys/@simis1' format '/backup/ARC_simis1_%U';
ALLOCATE CHANNEL node_c2 DEVICE TYPE DISK CONNECT 'sys/@simis2' format '/archivelog/backup/ARC_simis2_%U';
backup archivelog all delete all input;
}
exit;