AUDIENCE
This Oracle Data Guard training course is designed for practicing Oracle professionals who have basic experience with Oracle. Prior experience with Oracle is not required, but experience using Oracle database is highly desirable.
01 – Introduction to Data Guard
• What is Oracle Data Guard • MAA - Maximum Availability Architecture • Configurations • Primary Database • Standby Database • Physical Standby Database • Logical Standby Database • Snapshot Standby Database • Data Guard Services • Redo Transport Services • Apply Services • Role Transitions • Data Guard Broker • Protection Modes • Architecture • Primary • Standby • Physical Redo Architecture • Logical SQL Apply • Redo Transport • After Standby Startup • Standby Startup • Logical Apply • Gap Detection and Resolution • Complimentary Technology • Benefits of Using Data Guard • Licensing
02 – Creating a Physical Standby (SQL & RMAN)
• Preparing the Primary • Force Logging • Configuring Standby Redo Logs • Logfiles on the Standby • Standby Redo Logs • Using SQL to Create SRLs • Initialization Parameters on Primary • Role-Based Destinations • Redo Transport Mode • Oracle Net for Physical Standby • Creating a Listener Entry • Copying the Primary's Password File • Standby Init.ora File • Directory Path on the Target • Starting the Physical Standby • Invoking RMAN • Real-Time Apply • Starting Redo Apply • Standby on the Same Server • Data Corruption • Lost Write Detection
03 – Overview of Data Guard Broker
• Data Guard Broker Components • Broker Configuration • Data Guard Broker Architecture • DMON Process • Benefits of Using Data Guard Broker • DGMRL Commands • Enterprise Manager
04 – Creating a Data Guard Broker Configuration
• Requirements • Configuration File • Log Files • Workflow • Changing Properties • Database Properties • Disable Broker Management
05 – Creating a Physical Standby Using Enterprise Manager
• Creating Physical Standby • Physical Standby via EM
06 – Configuring Data Protection Modes
• Data Protection Modes • Maximum Protection • Maximum Availability • Maximum Performance • Comparisons • How to Set the Mode • Using Grid Control to Set the Mode
07 – Monitoring a Data Guard Configuration
• Monitoring Using Enterprise Manager • Viewing Data Guard Status • Data Guard Performance • Viewing Data Guard Performance • Viewing Log Files • Data Guard Metrics • Viewing Diagnostic Information • Destination Settings
08 – Optimizing a Data Guard Configuration
• Monitoring Performance • Optimizing Redo Transport • Optimizing Redo Transmissions • MaxConnections Database Property • RedoCompression Property • Delaying the Application of Redo
09 – Using Flashback Database in a Data Guard Configuration
• Flashback Database • Configuring Flashback Database • Enable Flashback Database • Flash Recovery Area • Flashback and Role Transitions • Flashback Database After Failover • Flashback Database Scenario
10 – Performing Role Transitions
• Role Transitions Role Management Services Switchover Switchover Using DGMGRL Switchover • Using Enterprise Manager Problems • Failover • Failover Using DGMGRL • Re-enable Disabled Databases • Failover Using Enterprise Manager • Failover - Back on the Standby
11 – Backup and Recovery Considerations
• RMAN in Data Guard • Maximum Availability Architecture (MAA) • Offload Backups to a Physical Standby • Usage RMAN Recovery Catalog • Create the Recovery Catalog • Register the Primary Database • Persistent Configuration Settings • RMAN Parameters for Primary • RMAN Parameters for Standby • Daily Incremental • RMAN Script • Loss of Data File on Primary • Using a Backup • Using the Physical Standby • Recovering a File on the Standby • Block Media Recovery
12 – Managing Client Connectivity
• Client Connectivity Issues • Helping Make the Right Connection • Managing Services • Client Failover • Automating Client Failover • Client Failover Components • Automatic Failover to a New Primary • Data Guard Broker and FAN • OCI Clients • OLE DB Clients • JDBC Clients • AFTER STARTUP Trigger • Service Names and tnsnames.ora File
13 – Patching & Upgrading Databases in a Data Guard Configuration
• Data Guard Broker • Upgrading with a Physical Standby • Rolling Upgrade Workflow • Rolling Upgrade