In this course, students learn how to use Oracle Data Guard to help protect their Oracle database against planned and unplanned downtimes. They also learn how Data Guard standby databases can be used to support production functions such as reporting, querying, and testing, while in a standby role. The course includes Data Guard architecture, the configuration of physical and logical standby databases, and role transitions. Oracle Data Guard 11g features, including Oracle Active Data Guard and snapshot standby databases are outlined. In addition, management of a Data Guard configuration and troubleshooting are discussed.
Learn To:
Use Data Guard to achieve a highly available Oracle database
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
Skills Gained
Create a physical standby database
Evaluate benefits of using the Data Guard Broker
Monitoring the Data Guard Configuration
Configure fast-start failover
Identify the factors that affect planned and unplanned downtime
Who Can Benefit
Database Administrators
Support Engineer
Technical Consultant
Prerequisites
Oracle Enterprise Manager 10g Grid Control Release 2
Oracle Database 11g: Administration Workshop II
Oracle Database 11g: Administration Workshop I
Code:
11g-DATAGUARD
Length:
4 days
Type:
Instructor-Led
Certified By:
Oracle
Tuition:
$2,400
This course is taught by Certified Oracle instructors. There is a difference. Learn More
This course is in the following categories. Click the categories to find similar courses and topics of interest.
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below. We can also contact you when the course is scheduled in your area.
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
When you take a certified course with ExitCertified, you are learning from
the creators of the products you use. Our commitment to your IT
community, along with our authorization to deliver certified courses,
ensures you receive a premium training experience.
