Course Description
This Oracle online training course will explain how to backup an Oracle Data Guard environment. This training also discusses how to implement failover and switchover. Additionally, we will utilize data guard with flashback database technology as well as RMAN commands. This course uses Enterprise Manager 1g Grid Control (10.2.0.x) and Grid Release 10.2.0.2.1.
In order to take this course you need to have taken Oracle Data Guard Part 1, Oracle 10g/11g Database Administration I Part 1 and Part 2 and Oracle 10g/11g Database Administration II Part 1 and Part 2 and have six months database administrator experience.
Download the course outline.
In This Course You Will Learn:
- Implement Oracle Data Guard
- Create a Physical and Logical Standby Database
- Create Data Guard with Oracle Grid Control
- Describe the Data Guard components
Prerequisites
You need to have six months database administrator experience and have taken Oracle Data Guard Part 1 or have taken the following GogoTraining courses:
Outline
Module 00: Oracle Data Guard Part 2 Online Training - Course Introduction
Module 01: Backup Methods and Data Guard
- Flashback database and Data Guard
- RMAN commands and Data Guard
- SQL Commands and Data Guard
- Quiz
Module 02: Flashback Database and Data Guard
- Using Flashback database instead of Apply Delay
- Recover the database from a prior point in time
- Use Real-time Apply
- Quiz
Module 03: Demo: Implementing Flashback Database
Module 04: Backing up in a Data Guard Environment
- Oracle Managed Backups
- User Managed Backups
- Recovery in a Data Guard Environment
- Quiz
Module 05: Demo: Backing up a Data Guard Database
Module 06: Data Guard and Failover
- Define Failover
- Define Failover versus Switchover
- Perform a manual Failover
Module 07: Grid and Failover
- Identify Failover needs
- Perform a Failover using Grid
Module 08: Data Guard and Switch Over
- Define Switchover
- Define Switchover versus Failover
- Perform a manual Switchover
Module 09: Grid and Switch Over
- Identify Switchover requirements
- Perform a Switchover using Grid
Module 10: Define Fast Start Failover
- Configure Fast Start Failover
- Monitor Fast Start Failover
- Re-instating the database
- Quiz
Module 11: Failover Client
- Configure automatic failover for OCI Clients
- Configure automatic failover for JDBC clients
- Design database mirroring
- Quiz
Module 12: Define a Snapshot Standby Database
- Convert a physical Standby Database to a Snapshot DB
- Using a Snapshot Database
- Monitoring the Snapshot Database
Module 13: Oracle Active Data Guard
- Define Oracle Active Data Guard
- Implement Active Data Guard
Module 14: Managing Data Guard Components
- Data Guard Monitoring Tools
- Using Grid and Data Guard
- View Dynamic performance views
Module 15: Demo: Monitoring Data Guard Components
Module 16: Upgrading databases with Data Guard
- Use SQL apply to upgrade
- Use Physical Standby for rolling upgrades
Certification
Oracle Data Guard Part 2 online training is part of a two-part course series that will help prepare you for the Oracle Database 11g Administrator Certification. These courses map to Oracle’s Database 11g: Data Guard Administration course. In order to become certified Oracle requires that you take an Oracle instructor-led classroom course or instructor-led online class.
For more information about Oracle Education and Certification click on the link found in the Related Training area found under the course modules section. For testing information about PearsonVue, review the Information document.