Oracle 11g Data Guard
Course: ORADG
Duration: 3 Days
Level: II
Course Summary
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 11g 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.
« Hide The Details
Topics Covered In This Course
Overview of Oracle10g/11g 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
- Benefits of Using Enterprise Manager
- 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
Related Courses
Code |
Course Title |
Duration |
Level |
|
OR11SEC |
Oracle Database 11g: Encryption & Advanced Data Security |
3 Days |
I |
Details |
ORBKUP |
Oracle Database 11g: Backup and Recovery |
5 Days |
II |
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.
|