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;