原 关于 RMAN 备份 数据块 一致性的讨论https://blog.youkuaiyun.com/tianlesoftware/article/details/5800172版权声明: https://blog.youkuaiyun.com/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
关于RMAN备份数据块一致性的讨论
最新推荐文章于 2022-08-02 10:35:41 发布