Oracle 11g容灾Data Guard课程


随着Oracle数据库市场的快速扩张,做为保护实例的RAC(Real Application Cluster)高可用技术与保护数据的DG(Data Guard)容灾技术,正越来越多地成为各种不同规模应用系统中的基本配置,掌握RAC与DG的原理与实践,是DBA必须要具备的高级技能之一。


Data Guard实验课程,可使得学员在短时间内掌握DG的安装、部署、管理与优化等内容。课程以实践能力提升为主,同时注重理论的讲解和学习。


基础要求:

  1. Oracle Database 11g: Administration Workshop I (052)

  2. Oracle Database 11g: Administration Workshop II (053)


学习实验环境:Linux虚拟化云环境。


 
Oracle 11g容灾Data Guard课程模块说明:

序号 模块说明
1 Data Guard的基础架构
2 物理Data Guard的安装和配置
3 物理Data Guard Failover测试
4 物理Data Guard Switchover测试
5 逻辑Data Guard的安装和配置
6 Data Guard常用管理与维护


 
课程详细内容介绍

  1. Introduction to Oracle Data Guard

序号 授课内容
1) Describe the basic components of Oracle Data Guard
2) Explain the differences between physical and logical standby databases
3) Explain the benefits of implementing Oracle Data Guard

  2. Creating a Physical Standby Database by Using SQL and RMAN Commands

序号 授课内容
4) Configure the primary database and Oracle Net Services to support the creation of the physical standby database and role transition
5) Create a physical standby database by using the DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE RMAN commandre

  3. Oracle Data Guard Broker: Overview

序号 授课内容
6) The Data Guard broker architecture
7) Data Guard broker components
8) Benefits of the Data Guard broker
9) Data Guard broker configurations
10) How to use Enterprise Manager to manage your Data Guard configuration
11) How to invoke DGMGRL to manage your Data Guard configuration

  4. Creating a Data Guard Broker Configuration

序号 授课内容
12) Create a Data Guard broker configuration
13) Manage the Data Guard broker configuration

  5. Creating a Physical Standby Database by Using Enterprise Manager Grid Control

序号 授课内容
14) Use Enterprise Manager to create a broker configuration
15) Use Enterprise Manager to manage the broker configuration

  6. Creating a Logical Standby Database

序号 授课内容
16) Determine when to create a logical standby database
17) Create a logical standby database
18) Manage SQL Apply filtering

  7. Creating and Managing a Snapshot Standby Database

序号 授课内容
19) Create a snapshot standby database to meet the requirement for a temporary, updatable snapshot of a physical standby database
20) Convert a snapshot standby database back to a physical standby database

  8. Using Oracle Active Data Guard

序号 授课内容
21) Use Real-time Query to access data on a physical standby database
22) Enable RMAN block change tracking for a physical standby database

  9. Configuring Data Protection Modes

序号 授课内容
23) Describe the data protection modes
24) Change the data protection mode of your configuration

  10. Performing Role Transitions

序号 授课内容
25) Explain the database roles
26) Perform a switchover
27) Perform a failover

  11. Using Flashback Database in a Data Guard Configuration

序号 授课内容
28) Explain the advantages of using Flashback Database in a Data Guard configuration
29) Configure Flashback Database

  12. Enabling Fast-Start Failover

序号 授课内容
30) Configure fast-start failover
31) View information about the fast-start failover configuration
32) Manage the observer
33) Perform role changes in a fast-start failover configuration
34) Manually reinstate the primary database

  13. Managing Client Connectivity

序号 授课内容
35) Configure client connectivity in a Data Guard configuration
36) Implement failover procedures to automatically redirect clients to a new primary database

  14. Backup and Recovery Considerations in an Oracle Data Guard Configuration

序号 授课内容
37) Use Recovery Manager (RMAN) to back up and restore files in a Data Guard configuration
38) Offload backups to a physical standby database
39) Recover your primary database by using a file from the physical standby database

  15. Patching and Upgrading Databases in a Data Guard Configuration

序号 授课内容
40) IBy using traditional upgrade methods
41) By performing rolling upgrades

  16. Monitoring a Data Guard Broker Configuration

序号 授课内容
35) Use Enterprise Manager Grid Control to monitor the configuration
36) Use DGMGRL to view the configuration status

  17. Optimizing a Data Guard Configuration

序号 授课内容
37) Monitor configuration performance
38) Optimize redo transport for best performance
39) Optimize SQL Apply

关于我们 | 新闻中心 | 合作伙伴 | 联系我们 |
西安优盛信息技术有限公司  版权所有©2007-2018  陕ICP备07501629号
在线客服系统