端海教育集团
全国免费热线:4008699035 微信号:shuhaipeixun
或15921673576(微 信 同 号) Q Q:849322415
首页 课程表 在线聊 报名 讲师 品牌 QQ聊 活动 就业
   班级规模及环境--热线:4008699035 手机:15921673576( 微信同号)
       坚持小班授课,为保证培训效果,增加互动环节,每期人数限3到5人。
   上课时间和地点
上课地点:【深圳分部】:电影大厦(地铁一号线大剧院站)/深圳大学成教院 【上海】:同济大学(沪西)/新城金郡商务楼(11号线白银路站) 【北京分部】:北京中山学院/福鑫大楼 【南京分部】:金港大厦(和燕路) 【武汉分部】:佳源大厦(高新二路) 【成都分部】:领馆区1号(中和大道) 【沈阳分部】:沈阳理工大学/六宅臻品 【郑州分部】:郑州大学/锦华大厦 【广州分部】:广粮大厦 【西安分部】:协同大厦 【石家庄分部】:河北科技大学/瑞景大厦
最近开课时间(周末班/连续班/晚班):请点击此处咨询在线客服
   实验设备
     ☆资深工程师授课
        
        ☆注重质量 ☆边讲边练

        ☆合格学员免费推荐工作
        ★实验设备请点击这儿查看★
   质量保障

        1、培训过程中,如有部分内容理解不透或消化不好,可免费在以后培训班中重听;
        2、课程完成后,授课老师留给学员手机和Email,保障培训效果,免费提供课后答疑。
        3、培训合格学员可享受免费推荐就业机会。

课程大纲
 
  • Oracle Database 11g: Data Guard Administration Rel
    Oracle Database 11g: Data Guard Administration Release 2 (11gR2-DATAGUARD)培训
    培训大纲:
    1. Introduction to Oracle Data Guard
    Causes of Data Loss
    Oracle Data Guard Architecture
    Types of Standby Databases and Benefits of Each Type
    Using the Data Guard Broker
    Differentiating Standby Databases and Data Guard Broker Configuration
    Data Protection Modes
    Performing Role Transitions
    2. Creating a Physical Standby Database by Using SQL and RMAN Commands
    Preparing the Primary Database
    Creating the Physical Standby Database
    3. Oracle Data Guard Broker
    Oracle Data Guard Broker Features
    Oracle Data Guard Broker Configurations
    Data Guard Monitor Process
    Data Guard Monitor Configuration Files
    Benefits of Using the Data Guard Broker
    Comparing Configuration Management With and Without the Broker
    Using DGMGRL
    4. Creating a Data Guard Broker Configuration
    Data Guard Configuration
    Setting up the Broker Configuration Files
    Setting the DG_BROKER_START Initialization Parameter to TRUE to Start the Data Guard Broker
    Creating the Broker Configuration
    Adding the Standby Database to the Configuration
    5. Creating a Physical Standby Database by Using Enterprise Manager Grid Control
    Using Enterprise Manager Grid Control to Create a Physical Standby Database
    Using the Add Standby Database Wizard
    Verifying a Configuration
    Editing Standby Database Properties
    Viewing the Data Guard Configuration Status
    6. Creating a Logical Standby Database
    Monitoring the Data Guard Configuration by Using Enterprise Manager Grid Control
    Verifying the Configuration
    Viewing Log File Details
    Using Enterprise Manager Data Guard Metrics
    Using the DGMGRL Show Configuration Command to Monitor the Configuration
    Viewing Standby Redo Log Information
    Monitoring Redo Apply
    7. Creating and Managing a Snapshot Standby Database
    Snapshot Standby Database: Architecture
    Converting a Physical Standby Database to a Snapshot Standby Database
    Activating a Snapshot Standby Database: Issues and Cautions
    Viewing Snapshot Standby Database Information
    Converting a Snapshot Standby Database to a Physical Standby Database
    8. Using Oracle Active Data Guard
    Using Real-Time Query
    Enabling and Disabling Real-Time Query
    Enabling Block Change Tracking on a Physical Standby Database
    Creating Fast Incremental Backups
    Monitoring Block Change Tracking
    9. Configuring Data Protection Modes
    Preparing to Create a Logical Standby Database
    Checking for Unsupported Objects, Data Types, and Tables
    Ensuring Unique Row Identifiers
    Creating the Logical Standby Using SQL Commands and Grid Control
    Securing your Logical Standby Database
    10. Performing Role Transitions
    Switchover vs. Failover
    Preparing for a Switchover
    Performing a Switchover using DGMGRL and Enterprise Manager
    Types of Failovers
    Re-enabling Disabled Databases
    11. Using Flashback Database in a Data Guard Configuration
    Flashback Database
    Configuring Flashback Database
    Using Flashback Database Instead of Apply Delay
    Using Flashback Database and Real Time Apply
    Flashback Through Standby Database Role Transitions
    Using Flashback Database After Failover
    12. Enabling Fast-Start Failover
    Installing the Observer Software
    Configuring Fast-Start Failover
    Configuring Automatic Reinstatement of the Primary Database
    Initiating Fast-Start Failover from an Application
    Disabling Fast-Start Failover
    Starting and Stopping the Observer
    Moving the Observer to a New Host
    13. Managing Client Connectivity
    Client Connectivity in a Data Guard Configuration
    Preventing Clients from Connecting to the Wrong Database
    Creating Services for the Data Guard Configuration Databases
    Automating Client Failover in a Data Guard Configuration
    Automating Failover for OCI Clients
    Automating Failover for OLE DB Clients
    Configuring JDBC Clients for Failover
    14. Performing Backup and Recovery Considerations in an Oracle Data Guard Configuration
    Backup and Recovery of a Logical Standby Database
    Using the RMAN Recovery Catalog in a Data Guard Configuration
    Creating the Recovery Catalog
    Registering a Database in the Recovery Catalog
    Configuring Daily Incremental Backups
    Using a Backup to Recover a Data File on the Primary Database
    Recovering a Data File on the Standby Database
    15. Patching and Upgrading Databases in a Data Guard Configuration
    Upgrading an Oracle Data Guard Broker Configuration
    Using SQL Apply to Upgrade the Oracle Database
    Performing a Rolling Upgrade by Using SQL Apply
    Performing a Rolling Upgrade by Using an Existing Logical Standby Database
    Performing a Rolling Upgrade by Creating a New Logical Standby Database
    Performing a Rolling Upgrade by Using a Physical Standby Database
    16. Monitoring a Data Guard Configuration
    Monitoring the Data Guard Configuration by Using Enterprise Manager Grid Control
    Verifying the Configuration
    Viewing Log File Details
    Using Enterprise Manager Data Guard Metrics
    Using the DGMGRL SHOW CONFIGURATION Command to Monitor the Configuration
    Viewing Standby Redo Log Information
    Monitoring Redo Apply
    17. Optimizing a Data Guard Configuration
    Using Enterprise Manager Grid Control to Monitor Configuration Performance
    Setting the ReopenSecs and NetTimeout Database Properties
    Compressing Redo Data
    Delaying the Application of Redo Data
    Optimizing SQL Apply
    Adjusting the Number of APPLIER and PREPARER Processes
     
     
     
     

  •  

  •  

  •  
     
     
     

  •  
     



 
 



 



 


 


 


 
 



 
 



 


 


 


 
   


 



 
 



 


 













 

 

 

友情链接:Cadence培训 ICEPAK培训 EMC培训 电磁兼容培训 sas容培训 罗克韦尔PLC培训 欧姆龙PLC培训 PLC培训 三菱PLC培训 西门子PLC培训 dcs培训 横河dcs培训 艾默生培训 robot CAD培训 eplan培训 dcs培训 电路板设计培训 浙大dcs培训 PCB设计培训 adams培训 fluent培训系列课程 培训机构课程短期培训系列课程培训机构 长期课程列表实践课程高级课程学校培训机构周末班培训 南京 NS3培训 OpenGL培训 FPGA培训 PCIE培训 MTK培训 Cortex训 Arduino培训 单片机培训 EMC培训 信号完整性培训 电源设计培训 电机控制培训 LabVIEW培训 OPENCV培训 集成电路培训 UVM验证培训 VxWorks培训 CST培训 PLC培训 Python培训 ANSYS培训 VB语言培训 HFSS培训 SAS培训 Ansys培训 短期培训系列课程培训机构 长期课程列表实践课程高级课程学校培训机构周末班 端海 教育 企业 学院 培训课程 系列班 长期课程列表实践课程高级课程学校培训机构周末班 短期培训系列课程培训机构 端海教育企业学院培训课程 系列班