Data Guard Administration

Data Guard Administration

培训课时：16小时（脱产2天、周末2天、晚班4个晚上）

培训费用：4400元/人（送培训资料）

适合人群：学完Oracle Database 10g：管理I和管理II这两门课程。

培训目标：

•  Use Data Guard to achieve a highly available Oracle Database

•  Describe the Data Guard architecture

•  Modify the Data Guard services

•  Use the Data Guard broker

•  Implement physical and logical standby databases

•  Perform failover and switchover operations

•  Enable fast-start failover

课程大纲：

1、 Oracle Data Guard: Overview

•  What Is Oracle Data Guard?

•  Types of Standby Databases

•  Data Guard Broker Framework

•  Types of Services

•  Benefits of Implementing Oracle Data Guard

2、 Understanding the Oracle Data Guard Architecture

•  Oracle Data Guard Architecture

•  Data Guard Redo Apply Architecture

•  Data Guard SQL Apply Architecture

•  Specifying Role-based Destinations

•  Configuring Standby Redo Logs

•  Standby Database Modes

3、 Using Oracle Data Guard Broker and Enterprise Manager

•  Oracle Data Guard Broker Features

•  Data Guard Broker Configurations

•  Benefits of Using the Data Guard Broker

•  Data Guard Broker Interfaces

•  Using Enterprise Manager 10g Grid Control

4、  Creating a Configuration and Physical Standby Database by Using Enterprise Manager

•  Using Enterprise Manager to Create a Broker Configuration

•  Using the Add Standby Database Wizard

•  Creating a Physical Standby Database

•  Verifying a Configuration

•  Creating Standby Redo Logs

•  Viewing the Data Guard Configuration Status

•  Viewing Data Guard Performance

5、 Creating a Physical Standby Database by Using SQL

•  Preparing the Primary Database

•  Setting Initialization Parameters on the Primary Database

•  Backing Up the Primary Database Using RMAN

•  Creating a Control File for the Standby Database

•  Setting Initialization Parameters on the Standby Database

•  Setting Up the Environment to Support the Standby Database

•  Starting the Physical Standby Database

•  Performing Additional Configuration Tasks

6、 Configuring Data Protection Modes and Log Transport Services

•  Setting the Log Transport Mode

•  Setting the Data Protection Mode

•  Delaying the Application of Redo

•  Using Flashback Database as an Alternative to Apply Delay

•  Additional Attributes that Affect Log Transport Services

7、 Creating a Logical Standby Database by Using Enterprise Manager

•  Benefits of Implementing a Logical Standby Database

•  Preparing to Create a Logical Standby Database

•  Checking for Unsupported Objects and Data Types

•  Enabling Supplemental Logging

•  Creating a Logical Standby Database by using Enterprise Manager

•  Using the Add Standby Database Wizard

•  Enabling and Disabling the Auto-Delete Feature

8、 Creating a Logical Standby Database by Using SQL

•  Preparing to Create a Logical Standby Database

•  Creating a Physical Standby Database

•  Preparing the Primary Database

•  Transitioning to a Logical Standby Database

•  Opening the Logical Standby Database

•  Verifying the Logical Standby Database

•  Performing Additional Configuration Tasks

9、 Performing Switchover and Failover

•  Choosing the Best Role Transition Operation

•  Performing a Switchover by Using Enterprise Manager

•  Performing a Switchover by Using SQL

•  Performing a Failover by Using Enterprise Manager

•  Performing a Failover by Using SQL

•  Restoring Databases After a Role Transition

•  Flashback Through Standby Database Role Transitions

10、Enabling Fast-Start Failover

•  When Will Fast-Start Failover Occur?

•  Configuring Fast-Start Failover

•  Prohibited Operations After Enabling Fast-Start Failover

•  Managing the Observer

•  Performing Role Changes

•  Using Enterprise Manager to Enable Fast-Start Failover

11、Using Data Guard in a Real Application Clusters Configuration

•  Real Application Clusters and Data Guard

•  Configuration Considerations with RAC

•  Configuring a Primary Database with RAC

•  Configuring a Standby Database with RAC

•  Apply Instance Failover

•  Role Transitions with RAC

21、Other Considerations for Oracle Data Guard

•  Using a Physical Standby Database for Read/Write Testing and Reporting

•  Offloading Backups to a Physical Standby Database

•  Using Flashback Database and Real-time Apply

•  Using Flashback Database After RESETLOGS

•  Enabling Redo Encryption

•  Configuring Cascaded Redo Log Destinations

13、 Workshop

•  Workshop Premise

•  Workshop Flow

•  Wo

威特教育之——特色

威特教育的Oracle培训在杭州乃至浙江地区占有75%的市场份额。浙大网新、浙大快威、浙江移动、杭州移动、温州移动、吉林移动、浙江爱特、杭州荣志、浙大图灵、浙江烟草、杭州烟草、金华烟草、丽水烟草、萧山国际机场、浙江工商管理局、*民生银行、*银行、杭州银行、交通银行、开发银行、IBM、惠普、联想、西门子、诺基亚、杭州市海关等行政*、企业客户以及数以十计的系统集成商和Oracle代理商成为杭州威特教育的企业会员，*杭州威特教育作为Oracle培训提供商。良好的口碑来源于威特教育一贯的对培训质量负责的态度和优质的教学质量的保障。

威特教育之——服务

1、终生不限次数免费重听所报课程，试听制度保障

2、强调动手能力，实战能力，重视理论联系实际

获得Oracle认证的实力保障

1、完备的实验环境，加强实验环节，切实提高学员的动手能力。

2、资深技术实力、工作经验丰富、多家企业和电信运营商首席数据库工程师OCM或者实力远超OCP的讲师授课，将讲师的一些数据系统的实践经验，与学员进行交流，达到学以至用，学有所成。

3、引进国际*的“技术沙龙式”案例分析教学法,学生与讲师面对面地分析实际案例,在讲师步步引导下,由学员分析引发故障的诸多可能性,并提出对应的排查对策,最终解决问题,从而切实提高学员的实际分析问题-解决问题的能力

a．具有丰富的专业技术和实践经验

b．长期为客户定制培训、善于联系实际、因材施教

c．和蔼可亲，风趣幽默，善于调动课堂气氛，具有高超的培训技巧和生动活泼的授课风格

d．引进国际*的业界培训理念

备注：

1、 上课期间人手一台计算机，理论与实验相结合，充分提高学员动手能力

2、 课余时间标准实验室长期免费开放，并有讲师专门辅导

3、 教学16课时，个人上机实验不限时

威特教育之——考试相关

威特教育是Vue授权的指定的Oracle考试报名点，欢迎各位参加IT认证考试的朋友前来报名参加培训及考试。报名考试即送*版题库，题库覆盖率均为95%以上。

 

开班详情请拨打热线：400-8888-780 400-8888-780