您的位置：首页  >>  课程中心  >>  Oracle Dataguard



Oracle Dataguard


学习前提：建议Oracle OCP基础学习


上课方式：线下面授+线上直播+课后专职老师辅导


课程时长：4天32课时



了解更多

​Oracle Data Guard Basics


  • Describe the Architecture of Oracle Data Guard
  • Explain the applicability between physical and logical standby and snapshot databases
  • Explain the benefits of implementing Oracle Data Guard
  • Explain Data Guard use with the Oracle Multi-tennant databases


Creating a Physical Standby Database by Using Enterprise Manager Cloud Control


  • Create a Data Guard broker configuration
  • Create a physical standby database
  • Verify a Data Guard configuration
  • Edit database properties related to Data Guard
  • Test a Data Guard configuration


Managing Oracle Net Services in a Data Guard Environment


  • Configure client connectivity in a Data Guard configuration
  • Implement failover procedures to automatically redirect clients to a new primary database
  • Using Application Continuity in a Data Guard Environment


Creating a Physical Standby Database by Using SQL and RMAN Commands


  • Configure the primary database and Oracle Net Services to support the creation of the physical standby database and role transition
  • Create a physical standby database by using the DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE RMAN command


Using Oracle Active Data Guard


  • Use Real-time Query to access data on a physical standby database
  • Enable RMAN block change tracking for a physical standby database
  • Use Far Sync to extend zero data loss protection for intercontinental configurations
  • Using Temporary Undo. Global Sequences and Session Sequences
  • Using Automatic Block Media Recovery
  • Configure Real-Time Cascading


Creating and Managing a Snapshot Standby Database


  • Create a snapshot standby database to meet the requirement for a temporary, updatable snapshot of a physical standby database
  • Convert a snapshot standby database back to a physical standby database


Creating a Logical Standby Database


  • Determine when to create a logical standby database
  • Create a logical standby database
  • Manage SQL Apply filtering


Oracle Data Guard Broker Basics


  • Describe the Data Guard broker architecture
  • Describe the Data Guard broker components
  • Explain the benefits of the Data Guard broker
  • Describe Data Guard broker configurations


Creating a Data Guard Broker Configuration


  • Create a Data Guard broker configuration
  • Manage the Data Guard broker configuration


Monitoring a Data Guard Broker Configuration


  • Use Enterprise Manager to manage your Data Guard configuration
  • Invoke DGMGRL to manage your Data Guard configuration


Configuring Data Protection Modes


  • Describe the data protection modes
  • Change the data protection mode of your configuration


Performing Role Transitions


  • Explain the database roles
  • Perform a switchover
  • Perform a failover


Using Flashback Database in a Data Guard Configuration


  • Configure Flashback Database
  • Explain the advantages of using Flashback Database in a Data Guard configuration


Enabling Fast-Start Failover


  • Configure fast-start failover
  • View information about the fast-start failover configuration
  • Manage the observer
  • Perform role changes in a fast-start failover configuration
  • Manually reinstate the primary database


Backup and Recovery Considerations in an Oracle Data Guard Configuration


  • Use Recovery Manager (RMAN) to back up and restore files in a Data Guard configuration
  • Offload backups to a physical standby database
  • Recovering databases in a Data Guard Environment
  • Managing Archive Redo Logs in a Data Guard Environment


Patching and Upgrading Databases in a Data Guard Configuration


  • Patch and upgrade databases using traditional patch methods
  • Perform rolling upgrades


Optimizing a Data Guard Configuration

​

  • Monitor configuration performance
  • Optimize redo transport for best performance
  • Optimize SQL Apply



Data Guard 是 Oracle 真正应用集群 (RAC) 的理想补充并可与其他 Oracle 高可用性 (HA) 解决方案（如 Oracle 闪回、 Oracle Recovery Manager (RMAN)）以及 Oracle 数据库 11 g 的新数据库选件（包括 Oracle Active Data Guard 和 Oracle Advanced Compression）结合使用，以提供最高级别的数据保护、数据可用性和资源利用率。


下图为 Oracle Data Guard 的概括示意图：

​


Data Guard 优点：

1、灾难恢复和高可用性


Data Guard 提供了一个高效、全面的灾难恢复和高可用性解决方案。自动故障切换和易于管理的转换功能允许主数据库和备用数据库之间的快速角色转换，从而使主数据库因计划中和计划外的中断所导致的停机时间减到最少。


2、完善的数据保护


备用数据库还针对数据损坏和用户错误提供了有效防护。主数据库上的存储器级物理损坏不会传播到备用数据库上。同样，导致主数据库永久损坏的逻辑损坏或用户错误也能够得到解决。最后，重做数据在到达备用数据库并在以后应用到备用数据库时得到验证。

3、有效利用系统资源


物理备用数据库可用于备份和只读报表，这样既减少了主数据库的负载又节省了宝贵的 CPU 和 I/O 周期。物理备用数据库还可以在不牺牲数据保护的同时在物理备用数据库和开启读/写功能的数据库间轻松转换。逻辑备用数据库支持对同步的备用数据库进行读写访问，和/或向备用数据库添加本地表来实现更新，和/或创建额外索引来优化读取性能。

4、数据保护中的灵活性平衡性能需求和可用性


Oracle Data Guard 提供最大程度的保护、最大的可用性和最佳性能模式来帮助企业平衡数据可用性和系统性能需求。


5、防止通信失败


如果主数据库和一个或多个备用数据库失去网络连接，重做数据将不能从主数据库发送到这些失去连接的备用数据库。一旦连接重新建立起来，Data Guard 将自动检测丢失的重做数据，必要的存档日志将自动传输到备用数据库。备用数据库将与主数据库重新同步，无需管理员手动干预。

6、简单的集中式管理


Data Guard Broker 实现了 Data Guard 配置中跨多个数据库的管理和监视任务的自动化。管理员可以借助 Oracle 企业管理器或 Broker 自己专用的命令行界面 (DGMGRL) 来利用这个集成管理框架。


7、与 Oracle 数据库集成


Data Guard 是 Oracle 数据库（企业版）的一个集成功能，无需另外付费。
点我开启学习之旅