2 Getting Started with Data Guard 这里有必要说一下,Oracle把DG环境及配置称为Data Guard configuration。在官方文档里经常使用。DG configuration包含一个primary DB和最多30个standby DB。 2.1 Standby Database Types 2.1.1 Physical Standby Databases Benefits of a Physical Standby Database Disaster recovery and high availability Data protection Reduction in primary database workload Performance2.1.2 Logical Standby Databases Benefits of a Physical Standby Database Protection against additional kinds of failure 逻辑备库的工作原理是通过分析redo,重构逻辑改变,这样可以避免物理备库基于块对块的复制所导致的问题。Oracle建议对于同一个主服务器要同时有物理备库和逻辑备库。 Efficient use of resources Workload distribution Optimized for reporting and decision support requirements Minimizing downtime on software upgrades2.1.3 Snapshot Standby Databases Benefits of a Snapshot Standby Database It provides an exact replica of a production database for development and testing purposes, while maintaining data protection at all times. It can be easily refreshed to contain current production data by converting to a physical standby and resynchronizing.2.2 User Interfaces for Administering Data Guard Configurations2.3 Data Guard Operational Prerequisites2.3.1 Hardware and Operating System Requirements 访问http://support.oracle.com可以得到,但是需要有服务号。 2.3.2 Oracle Software Requirements DG是企业版的特性,标准版不具有; 在DG configuration中,对于物理备库,所有COMPATIBALE参数必须与主库相同,而逻辑备库的COMPATIBALE可以比主库大; 主库必须运行在ARCHIVELOG模式; 主库可以是单实例或者是一个RAC数据库,备库也同样,而且这些备库可以包括逻辑,物理,快照类型; 每个主库和备库都必须有自己的控制文件; 如果备库和主库在同一个OS上,那么备库必须有自己的归档路径,否则会覆盖主库的归档; 主库要开启FORCE LOGGING,这样主库做的所有更改都会通过redo传到备库,即使使用NOLOGGING; 管理主库和备库的用户必须有SYSDBA系统权限; 为了操作上的简便,Oracle建议当你在DG configuration中创建了ASM or OMF,那么对应的也在主库上这样创建,除非你是为了迁移或者维护的目的,否则都应该这么干。2.4 Standby Database Directory Structure Considerations
Data Guard 2
最新推荐文章于 2023-11-28 22:49:18 发布