ITPub博客

首页 > 数据库 > Oracle > RAC下的备份策略V1.1

RAC下的备份策略V1.1

原创 Oracle 作者:lbocp 时间:2007-01-17 09:24:32 0 删除 编辑

RAC下的备份策略V1.1

两个节点,RACA&RACB

1.每天晚上22:00 执行数据库全备份到共享磁盘上

2.每天晚上23:50分执行归档日志备份到两个节点上

3.每天凌晨1:00启动dp备份分别把数据库全备份/两

[@more@]

本文可以任意转载,转载时请务必以超链接形式标明文章原始出处和作者信息及本声明

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
rman/@catalog <backup database format '/backup/FULL_%T_%d_%U';
exit;

#备份归档日志
#backup_archivelog.sh
rman target / catalog rman/@catalog <run{
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;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/57839/viewspace-890955/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2009-10-22

  • 博文量
    18
  • 访问量
    341488