Oracle DataGuard物理备库的数据模式

在DataGuard中数据保护模式要按照需求来设置在所有的配置中都是用性能换数据的安全，要么就是用数据的安全级别来换性能。1.数据的保护模式
第一种：最大限度保护数据
Maximum availability： This protection mode provides the highest level of data protection that is possible without compromising the availability of a primary database. With Oracle Data Guard, transactions do not commit until all redo data needed to recover those transactions has either been received in memory or written to the standby redo log （depending upon configuration） on at least one synchronized standby database. If the primary database cannot write its redo stream to at least one synchronized standby database, it operates as if it were in maximum performance mode to preserve primary database availability until it is again able to write its redo stream to a synchronized standby database.This protection mode ensures zero data loss except in the case of certain double faults, such as failure of a primary database after failure of the standby database.--先将log写入到内存或者一个备库归档，然后执行事务，除了双方同时故障的意外。第二种：最大性能
Maximum performance： This is the default protection mode. It provides the highest level of data protection that is possible without affecting the performance of a primary database. This is accomplished by allowing transactions to commit as soon as all redo data generated by those transactions has been written to the online log. Redo data is also written to one or more standby databases, but this is done asynchronously with respect to transaction commitment, so primary database performance is unaffected by delays in writing redo data to the standby database（s）.This protection mode offers slightly less data protection than maximum availability mode and has minimal impact on primary database performance.--默认的保护方式，先将事务执行，然后记录到log，然后同步到备库，对主库iude影响非常小第三种：数据0丢失
Maximum protection： This protection mode ensures that no data loss will occur if the primary database fails. To provide this level of protection, the redo data needed to recover a transaction must be written to both the online redo log and to the standby redo log on at least one synchronized standby database before the transaction commits. To ensure that data loss cannot occur, the primary database will shut down, rather than continue processing transactions, if it cannot write its redo stream to at least one synchronized standby database.--当事务提交后，将log先提交到备库，关闭主库其他的事务，然后执行事务，完毕后执行下一个事务2.修改方式（数据保护由主库参数操控）
注意：在主库操作按数据包户程度排序maximize protection < maximize availability < maximize performanceSQL> select protection_mode,protection_level from v$database;PROTECTION_MODE PROTECTION_LEVEL
------------------------------------------------------------ ------------------------------------------------------------
MAXIMUM PERFORMANCE MAXIMUM PERFORMANCESQL> alter database set standby database to maximize availability;数据库已更改。SQL> select protection_mode,protection_level from v$database;PROTECTION_MODE PROTECTION_LEVEL
------------------------------------------------------------ ------------------------------------------------------------
MAXIMUM AVAILABILITY RESYNCHRONIZATION //没生效更多详情见请继续阅读下一页的精彩内容： http://www.linuxidc.com/Linux/2013-11/926034p2.htm推荐阅读：使用RMAN的Duplicate功能创建物理DataGuard http://www.linuxidc.com/Linux/2012-04/59330.htmOracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htmRMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htmRMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htmOracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm通过RMAN备份duplicate创建DataGuard http://www.linuxidc.com/Linux/2013-08/89225.htm

Oracle 12c R1 DataGuard的主备切换使用select语句查看Oracle的各种命中率和性能统计数据相关资讯 DataGuard

DataGuard如何传送Redo到Standby （05月04日）
RAC环境下DataGuard到单机（04月08日）
Oracle 11G R2 DataGuard日常维护（02月20日）

MRP0- Background Media Recovery （04月16日）
DataGuard环境中的密码维护（03月17日）
Oracle 11G R2利用RMAN搭建（02月20日）

本文评论查看全部评论（0）