关于RMAN备份数据块一致性的讨论

本文详细讨论了RMAN备份数据块一致性和不一致性的概念。一致备份发生在数据库关闭时,确保所有重做已应用于数据文件。不一致备份则在数据库开放或遇到异常关闭时发生,需要介质恢复。RMAN在归档模式下可进行非一致备份,但NOARCHIVELOG模式下不允许。文章还解释了快照控制文件如何确保备份期间的读取一致性,并强调了备份归档日志和控制文件的重要性。
摘要由CSDN通过智能技术生成

原 关于 RMAN 备份 数据块 一致性的讨论https://blog.csdn.net/tianlesoftware/article/details/5800172版权声明: https://blog.csdn.net/tianlesoftware/article/details/5800172
  今天和 杭州恒生 的一个朋友讨论一个RMAN 在备份时数据块一致性的问题。
  关于RMAN 的备份原理参考blog:
    RMAN 系列(一)---- RMAN 体系结构概述
http://www.cndba.cn/Dave/article/1165
      先看官方文档上的一段话:
  Consistent Backups
You can use the BACKUP command to make consistent and inconsistent backups of the database. A consistent backup occurs when the database is in a consistent state. A database is in a consistent state after being shut down with the SHUTDOWN NORMAL, SHUTDOWN IMMEDIATE, or SHUTDOWN TRANSACTIONAL commands. A consistent shutdown guarantees that all redo has been applied to the datafiles. If you mount the database and make a backup at this point, then you can restore the database backup later and open it without performing media recovery.
  Inconsistent Backups
Any database backup that is not consistent is an inconsistent backup. A backup made when the database is open is inconsistent, as is a backup made after an instance failure or SHUTDOWN ABORT command. When a database is restored from an inconsistent backup, Oracle Database must perform media recovery before the database can be opened, applying any pending changes from the redo logs.
  Note:
RMAN does not permit you to make inconsistent backups when the database is in NOARCHIVELOG mode. If you employ user-managed backup techniques for a NOARCHIVELOG database, then you must not make inconsistent backups of this database.
If the database runs in ARCHIVELOG mode, and you back up the archived redo logs and datafiles, inconsistent backups can be the foundation for a sound backup and recovery strategy. Inconsistent backups offer superior availability because yo

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值