手机版
你好,游客 登录 注册
背景:
阅读新闻

RMAN备份策略制定参考内容

[日期:2013-03-26] 来源:Linux社区  作者:tanguooo19866 [字体: ]

一:在制定rman备份策略前,需对redo日志进行评估。本文按照官方文档的建议进行设置:

文档建议:

Oracle recommends that you multiplex the online redo log. The loss of log files can be catastrophic if recovery is required. When you multiplex the online redo log, the database must increase the amount of I/O it performs. Depending on your system, this additional I/O may impact overall database performance.

oracle建议使用多个redolog(如图中redo01a.log),保证redo的冗余!,并将冗余的redolog放在不同的磁盘上(图中redo01a.log放在diakA中),以减少I/O开销!

二:归档日志的配置本文参考的是:

To archive to multiple destinations, you can choose to archive to two or more locations using theLOG_ARCHIVE_DEST_n initialization parameters, or to archive only to a primary and secondary destination using theLOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST initialization parameters.

oracle还是建议使用log_archive_dest_n来配置archivelog的放置路径!而且还是遵循上的冗余策略!


注意:

If you configure a Fast Recovery Area (by setting the DB_RECOVERY_FILE_DEST andDB_RECOVERY_FILE_DEST_SIZE parameters) and do not specify any local archive destinations, the database automatically selects the Fast Recovery Area as a local archive destination and setsLOG_ARCHIVE_DEST_1 to USE_DB_RECOVERY_FILE_DEST.

如果指定了 快速恢复区(Fast Recovery Area),并且没有指定任何本地归档路径时。oracle将默认快速恢复区作为归档路径。

You must ensure that there is sufficient disk space at all times for archive log destinations. If the database encounters a disk full error as it attempts to archive a log file, a fatal error occurs and the database stops responding. You can check the alert log for a disk full message.

要确保指定的归档路径有足够的空间来存放归档日志。如果oracle在归档时发现空间不足的话,就会停止响应(挂起),在alter文件中会有提示磁盘不足的消息!

linux
本文评论   查看全部评论 (0)
表情: 表情 姓名: 字数

       

评论声明
  • 尊重网上道德,遵守中华人民共和国的各项有关法律法规
  • 承担一切因您的行为而直接或间接导致的民事或刑事法律责任
  • 本站管理人员有权保留或删除其管辖留言中的任意内容
  • 本站有权在网站内转载或引用您的评论
  • 参与本评论即表明您已经阅读并接受上述条款