Oracle Database 12c: Data Guard Administration

Descriptions

The Oracle Database 12c: Data Guard Administration Ed 1 training teaches participants how to effectively use Oracle Data Guard to protect Oracle databases from both planned and unplanned downtime. Led by expert instructors from Oracle University, this course demonstrates how Data Guard helps organizations build highly available systems while enabling business processing and backup tasks to be offloaded to another system. Participants will also be introduced to Oracle Database Exadata Cloud Service and gain an understanding of its role in improving database performance and reliability. By the end of the course, learners will understand how Data Guard standby databases can support production activities such as reporting, querying, and testing while operating in a standby role. The course also covers the architecture and new features of Oracle Data Guard 12c, including Oracle Active Data Guard, Far Sync, rolling upgrades, and snapshot standby databases, while providing practical knowledge on how to manage and troubleshoot a Data Guard configuration.

Course Objectives

• Use Data Guard standby databases to support production functions such as reporting, querying, testing, and performing backups
• Create and manage physical and logical standby databases
• Use Enterprise Manager Cloud Control and the Data Guard command-line interface (DGMGRL) to maintain a Data Guard configuration
• Use Data Guard to achieve a highly available Oracle database
• Gain an understanding of Oracle Database Exadata Cloud Service

Target Audience

• Administrator
• Database Administrator
• Implementer

Required Pre requisites

• Oracle Database 11g: Administration Workshop I Ed 2
• Oracle Database 11g: Administration Workshop II Ed 2
• Database Administration
• Linux operating system fundamentals

Course Outline

• Introduction to Oracle Data Guard
• Networking for Oracle Data Guard
• Creating a Physical Standby Database by Using SQL and RMAN Commands
• Oracle Data Guard Broker: Overview
• Creating a Data Guard Broker Configuration
• Creating a Physical Standby Database by Using Enterprise Manager Cloud Control
• Creating a Logical Standby Database
• Creating and Managing a Snapshot Standby Database
• Using Oracle Active Data Guard
• Configuring Data Protection Modes
• Performing Role Transitions
• Using Flashback Database in a Data Guard Configuration
• Enabling Fast-Start Failover
• Managing Client Connectivity
• Backup and Recovery Considerations in an Oracle Data Guard Configuration
• Patching and Upgrading Databases in a Data Guard Configuration
• Monitoring a Data Guard Broker Configuration
• Optimizing a Data Guard Configuration
• Oracle Database Exadata Cloud Service Overview