Business continuity and disaster recovery are top priorities for the senior management of most global enterprises. Economic fluctuations, rapid changes in market trends, and competitive pressures imply that the global enterprise of today must operate in a 24x7 environment, and must be bale to swiftly and efficiently deal with unforeseen business interruptions. Oracle Data Guard is the most effective solution available today to protect the core asset of any enterprise - its data, and make it available on a 24x7 basis even in the face of disasters and other calamities. This course discusses Oracle Data Guard 12c technology, and demonstrates how it is one of the most important elements in the business continuity infrastructure of any enterprise.
Oracle Data Guard is the most effective and comprehensive Disaster Recovery solution available today for enterprise data.
Topics Covered In This Course
- Overview of Oracle11g/12c Data Guard
- Objectives
- Causes of data loss
- What is Oracle Data Guard
- Types of standby databases
- Oracle Data Guard Broker Framework
- Types of services
- Role transitions: Switchover and failover
- Data protection modes
- Benefits of Oracle Data Guard
- Summary
- Understanding the Oracle Data Guard Architecture
- Objectives
- Data Guard Operational Requirements: Hardware and OS
- Data Guard Operational Requirements: Software
- Oracle Data Guard Architecture
- Primary Database Flow
- Standby Database Flow
- Standby Redo Logs
- Physical Standby Database: Redo Apply Architecture
- Logical Standby Database: SQL Apply Architecture
- SQL Apply Process: Architecture
- Real-Time apply
- Standby Redo Log Configuration
- Standby Database Modes
- Summary
- Using Data Guard Broker and Enterprise Manager
- Objectives
- Data Guard Broker Features
- Data Guard Broker Architecture
- Data Guard Broker Requirements
- Life Cycle of Data Guard Broker: Architecture
- Benefits of Using the Data Guard Broker
- Data Guard Broker Interfaces
- Using the Command Line Interface of the Data Guard Broker
- Configuring a Physical Standby Database Using SQL
- Objectives
- Steps to Create a Physical Standby Database
- Preparing the Primary Database
- Setting the INIT parameters on the Primary DB
- Backing up the Primary DB using RMAN
- Creating the control file for the Standby DB
- Copying files to the Standby DB
- Setting the INIT parameters for the Standby DB
- Starting the Physical Standby DB
- Summary
- Configuring Data Protection Modes and Redo Log Transport Services
- Objectives
- Data Protection Modes and Redo Transport Modes
- Data Protection Modes
- Setting the Data Protection Mode
- Delaying the application of Redo
- Summary
- Creating a Logical Standby Database by Using SQL
- Objectives
- Preparing to Create a Logical Standby Database
- Creating a Logical Standby Database
- Summary
- Performing Switchover
- Objectives
- Types of Roles in an Oracle Data Guard Configuration
- Role Management Services
- Role Transitions: Switchover
- Choosing the best Role Transition Operation
- Switchover
- Activating a Standby Database
- Restoring Databases after a Role Transition
- Summary
- Performing Failover
- Objectives
- Types of Roles in an Oracle Data Guard Configuration
- Role Management Services
- Role Transitions: Failover
- Choosing the best Role Transition Operation
- Failover
- Activating a Standby Database
- Restoring Databases after a Role Transition
- Summary
- Enabling Fast Start Failover
- Objectives
- Overview of Fast-Start Failover
- C Disabling Fast-Start Failover
- Performing Role Changes
- Performing a manual Failover
- Summary
- Other considerations for Oracle Data Guard
- Objectives
- Using RMAN to Backup a Physical Standby DB
- Restrictions and Usage Notes
- Flashback across Database Changes
- Enabling Redo Encryption
- Activating a Physical Standby DB for Reporting
- Cascaded Redo log Destinations
- RAC considerations
- Summary
What You Can Expect
Oracle11g Data Guard class enables the student participants to acquire and develop key skills to effectively implement and administer an Oracle Data Guard environment . This Oracle Data Guard course will:
Provide a detailed understanding of Oracle11g Data Guard features
Enable the participant to implement Data Guard for the class on a single server
Explain the benefits of creating a Data Guard Environment
Describe the factors that affect planned and unplanned downtime
Configure the database for Data Guard Options
Employ basic Data Guard monitoring procedures
Who Should Take This Course
Recommended for both Oracle Database Administrators and System Administrators.
Recommended Prerequisites
Attendees should be experienced Oracle Database Administrators, including experience with RMAN.
Training Style
Instructor Led with 50% lecture and 50% lab.
« Hide The Details
Every student attending a Verhoef Training class will receive
a certificate good for $100 toward their next public class taken
within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a
single student in any of our public or web-based classes.
Contact your account manager or our sales office for details.