課程介紹： 本課程中，學員將學習如何使用Oracle Data Guard 以保護Oracle 數據庫避免宕機。課程將包括 Oracle Data Guard 的體系結構，以及備份數據庫的物理結構和邏輯結構的建立，此外，課程包括使用 Data Guard 對性能的考慮，并且提供診斷錯誤的技巧。 課程大綱： ??????? 第一章. 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