Oracle Data Guard培训容灾培训

课程介绍
本课程中,学员将学习如何使用Oracle Data Guard 以保护Oracle 数据库避免宕机。课程将包括 Oracle Data Guard 的体系结构,以及备份数据库的物理结构和逻辑结构的建立,此外,课程包括使用 Data Guard 对性能的考虑,并且提供诊断错误的技巧。

课程对象

课程长度:3天

最新时间:定制课程(内训),人满开班(公开课)

传统的面对面授课方式。

 

课程大纲:

        第一章. Oracle Data Guard概述
        第二章.了解Oracle Data Guard的体系结构
        第三章.使用Oracle Data Guard Broker和企业管理器
        第四章.使用Enterprise Manager创建一个配置和物理备用数据库
        第五章.使用SQL创建物理备用数据库
        第六章.配置数据保护模式和日志传输服务
        第七章.使用Enterprise Manager创建逻辑备用数据库
        第八章.使用SQL创建逻辑备用数据库
        第九章.执行转换和故障切换
        第十章.启用快速启动故障切换
        第十一章.在一个真正的应用集群配置中使用的数据卫士
        第十二章. Oracle Data Guard的其他注意事项
Oracle Database 11g: Data Guard英文大纲
        Introduction to Oracle Data Guard
           Causes of Data Loss
           Oracle Data Guard Architecture
           Data Protection Modes
        Creating a Physical Standby Database by Using SQL and RMAN Commands
           Preparing the Primary Database
           Creating a Physical Standby Database
        Overview of the Data Guard Broker
           Oracle Data Guard Broker Features
           Oracle Data Guard Broker Configurations
        Using DGMGRL to Create a Data Guard Broker Configuration
           Creating the Broker Configuration
           Adding the Standby Database to the Configuration
        Creating a Physical Standby Database by Using Enterprise Manager Grid Control
           Using the Add Standby Database Wizard
           Verifying a Configuration
           Viewing the Data Guard Configuration Status
        Monitoring a Data Guard Broker Configuration
           Monitoring the Data Guard Configuration
           Verifying the Configuration
           Using Enterprise Manager Data Guard Metrics
           Viewing Log File Details
        Managing Data Protection Modes
           Determining Which Data Protection Mode to Use
           Setting Up Standby Redo Logs
           Setting the Data Protection Mode
        Optimizing a Data Guard Configuration
           Monitoring Configuration Performance
           Optimizing Network Configuration
           Implementing Cascaded Destinations
        Using Flashback Database in a Data Guard Configuration
           Using Flashback Database and Real-time Apply
           Using Flashback Database Instead of Apply Delay
           Recovering Data from the Standby Database From a Past Point-in-time
        Performing Role Transitions
           Understanding Roles in an Oracle Data Guard Configuration
           Performing a Switchover to a Physical Standby Database
           Performing a Failover to a Physical Standby Database
           Re-enabling a Disabled Database After a Role Transition
        Enabling Fast-Start Failover
           Configuring Fast-Start Failover
           Viewing Fast-Start Failover Information
           Performing Role Changes
           Reinstating the Database
        Implementing Client Failover Procedures
           Configuring Your Database to Automate Failover for OCI Clients
           Configuring Your Database to Automate Failover for JDBC Clients
           Troubleshooting Client Failover
        Creating and Managing a Snapshot Standby Database
           Converting a Physical Standby Database into a Snapshot Standby Database
           Using a Snapshot Standby Database
           Monitoring a Snapshot Standby Database
        Using Oracle Active Data Guard
           Opening a Physical Standby Database in Read-only Mode
           Enabling Block Change Tracking on a Physical Standby Database for Fast Incremental Backups
        Creating a Logical Standby Database
           Preparing to Create a Logical Standby Database
           Creating a Logical Standby using SQL/RMAN Commands
           Creating a Logical Standby using Grid Control
           Managing SQL Apply Filtering
           Performing Rolling Upgrades
        Managing the Data Guard Configuration
           Viewing Data Guard Diagnostic Information
           Troubleshooting
        Backup and Recovery Considerations in an Oracle Data Guard Configuration
           Using RMAN to Back Up and Restore Files in a Data Guard Configuration
           Offloading Backups to a Physical Standby Database
           Recovering a Corrupted Datafile on the Primary Database
           Backing Up a Logical Standby Database
        Upgrading Databases in a Data Guard Configuration
           Using SQL Apply to Upgrade the Oracle Database
           Using a Physical Standby for Rolling Upgrades
           Upgrading an Oracle Data Guard Release 10.n Configuration to Release 11.1