苏州三网教育

专业IT教育机构

学校课程咨询服务:
400-882-5311
培训世界 >苏州Oracle认证培训 >Oracle Dataguard

Oracle Dataguard

Oracle Dataguard

上课时段: 详见内容

已关注: 188

课程价格: 请咨询

优惠价格: 请咨询

授课学校: 苏州三网教育

教学点: 1个

开班时间: 滚动开班

咨询电话:400-882-5311

预约试听

课程详情

课程介绍
  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数据库(企业版)的一个集成功能,无需另外付费。
1