RAC下的备份策略V1.1

最新推荐文章于 2024-09-14 19:55:29 发布

cpfvq5770

最新推荐文章于 2024-09-14 19:55:29 发布

阅读量136

点赞数

文章标签：数据库

RAC下的备份策略V1.1

两个节点,RACA&RACB

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

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

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

[@more@]

RAC下的备份策略V1.1

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

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/57839/viewspace-890955/