|
Provided by: Oranet (pvt) Ltd Oracle 10g Dataguard Release 2Oracle |
 |
Training
Provided by Oranet (pvt) Ltd
What you will learn:
Minimize the downtime associated with any outage and prevent data loss by learning how to use Oracle Data Guard. The course details Data Guard architecture as well as the creation of physical and logical standby databases. In addition, it examines the performance implications of using various Data Guard features and offers some troubleshooting tips.
Learn to use Enterprise Manager Grid Control to create and manage your Data Guard configuration. A workshop that gives students the opportunity to apply what they have learned to meet stated business requirements reinforces skills.
Learn To:
a Use Data Guard to achieve a highly available Oracle Database
a Create physical and logical standby databases
a Use Enterprise Manager Grid Control to manage the Data Guard configuration
Audience:
a Database Administrators
a Support Engineer
a Technical Consultant
Prerequisites:
Suggested Prerequisites:
Oracle Enterprise Manager 10g Grid Control Release 2
Course Objectives:
a Use Data Guard to achieve a highly available Oracle Database
a Describe the Data Guard architecture
a Modify the Data Guard services
a Use the Data Guard broker
a Implement physical and logical standby databases
a Perform failover and switchover operations
a Enable fast-start failover
Related Software Programs or Products: Oracle
Related Awards, Degrees or Certifications: Oracle
Related Jobs or Careers: Oracle master DBA
|
|
||||||||||||||||||
Oracle 10g Dataguard Release 2
Course Topics:
Oracle Data Guard: Overview
What Is Oracle Data Guard?
Types of Standby Databases
Data Guard Broker Framework
Types of Services
Benefits of Implementing Oracle Data Guard
Understanding the Oracle Data Guard Architecture
Oracle Data Guard Architecture
Data Guard Redo Apply Architecture
Data Guard SQL Apply Architecture
Specifying Role-based Destinations
Configuring Standby Redo Logs
Standby Database Modes
Using Oracle Data Guard Broker and Enterprise Manager
Oracle Data Guard Broker Features
Data Guard Broker Configurations
Benefits of Using the Data Guard Broker
Data Guard Broker Interfaces
Using Enterprise Manager 10g Grid Control
Creating a Configuration and Physical Standby Database by Using Enterprise Manager
Using Enterprise Manager to Create a Broker Configuration
Using the Add Standby Database Wizard
Creating a Physical Standby Database
Verifying a Configuration
Creating Standby Redo Logs
Viewing the Data Guard Configuration Status
Viewing Data Guard Performance
Creating a Physical Standby Database by Using SQL
Preparing the Primary Database
Setting Initialization Parameters on the Primary Database
Backing Up the Primary Database Using RMAN
Creating a Control File for the Standby Database
Setting Initialization Parameters on the Standby Database
Setting Up the Environment to Support the Standby Database
Starting the Physical Standby Database
Performing Additional Configuration Tasks
Configuring Data Protection Modes and Log Transport Services
Setting the Log Transport Mode
Setting the Data Protection Mode
Delaying the Application of Redo
Using Flashback Database as an Alternative to Apply Delay
Additional Attributes that Affect Log Transport Services
Creating a Logical Standby Database by Using Enterprise Manager
Benefits of Implementing a Logical Standby Database
Preparing to Create a Logical Standby Database
Checking for Unsupported Objects and Data Types
Enabling Supplemental Logging
Creating a Logical Standby Database by using Enterprise Manager
Using the Add Standby Database Wizard
Enabling and Disabling the Auto-Delete Feature
Creating a Logical Standby Database by Using SQL
Preparing to Create a Logical Standby Database
Creating a Physical Standby Database
Preparing the Primary Database
Transitioning to a Logical Standby Database
Opening the Logical Standby Database
Verifying the Logical Standby Database
Performing Additional Configuration Tasks
Performing Switchover and Failover
Choosing the Best Role Transition Operation
Performing a Switchover by Using Enterprise Manager
Performing a Switchover by Using SQL
Performing a Failover by Using Enterprise Manager
Performing a Failover by Using SQL
Restoring Databases After a Role Transition
Flashback Through Standby Database Role Transitions
Enabling Fast-Start Failover
When Will Fast-Start Failover Occur?
Configuring Fast-Start Failover
Prohibited Operations After Enabling Fast-Start Failover
Managing the Observer
Performing Role Changes
Using Enterprise Manager to Enable Fast-Start Failover
Using Data Guard in a Real Application Clusters Configuration
Real Application Clusters and Data Guard
Configuration Considerations with RAC
Configuring a Primary Database with RAC
Configuring a Standby Database with RAC
Apply Instance Failover
Role Transitions with RAC
Other Considerations for Oracle Data Guard
Using a Physical Standby Database for Read/Write Testing and Reporting
Offloading Backups to a Physical Standby Database
Using Flashback Database and Real-time Apply
Using Flashback Database After RESETLOGS
Enabling Redo Encryption
Configuring Cascaded Redo Log Destinations
Workshop
Workshop Premise
Workshop Flow
Workshop Scenarios
Oracle Data Guard: Overview
What Is Oracle Data Guard?
Types of Standby Databases
Data Guard Broker Framework
Types of Services
Benefits of Implementing Oracle Data Guard
Understanding the Oracle Data Guard Architecture
Oracle Data Guard Architecture
Data Guard Redo Apply Architecture
Data Guard SQL Apply Architecture
Specifying Role-based Destinations
Configuring Standby Redo Logs
Standby Database Modes
Using Oracle Data Guard Broker and Enterprise Manager
Oracle Data Guard Broker Features
Data Guard Broker Configurations
Benefits of Using the Data Guard Broker
Data Guard Broker Interfaces
Using Enterprise Manager 10g Grid Control
Creating a Configuration and Physical Standby Database by Using Enterprise Manager
Using Enterprise Manager to Create a Broker Configuration
Using the Add Standby Database Wizard
Creating a Physical Standby Database
Verifying a Configuration
Creating Standby Redo Logs
Viewing the Data Guard Configuration Status
Viewing Data Guard Performance
Creating a Physical Standby Database by Using SQL
Preparing the Primary Database
Setting Initialization Parameters on the Primary Database
Backing Up the Primary Database Using RMAN
Creating a Control File for the Standby Database
Setting Initialization Parameters on the Standby Database
Setting Up the Environment to Support the Standby Database
Starting the Physical Standby Database
Performing Additional Configuration Tasks
Configuring Data Protection Modes and Log Transport Services
Setting the Log Transport Mode
Setting the Data Protection Mode
Delaying the Application of Redo
Using Flashback Database as an Alternative to Apply Delay
Additional Attributes that Affect Log Transport Services
Creating a Logical Standby Database by Using Enterprise Manager
Benefits of Implementing a Logical Standby Database
Preparing to Create a Logical Standby Database
Checking for Unsupported Objects and Data Types
Enabling Supplemental Logging
Creating a Logical Standby Database by using Enterprise Manager
Using the Add Standby Database Wizard
Enabling and Disabling the Auto-Delete Feature
Creating a Logical Standby Database by Using SQL
Preparing to Create a Logical Standby Database
Creating a Physical Standby Database
Preparing the Primary Database
Transitioning to a Logical Standby Database
Opening the Logical Standby Database
Verifying the Logical Standby Database
Performing Additional Configuration Tasks
Performing Switchover and Failover
Choosing the Best Role Transition Operation
Performing a Switchover by Using Enterprise Manager
Performing a Switchover by Using SQL
Performing a Failover by Using Enterprise Manager
Performing a Failover by Using SQL
Restoring Databases After a Role Transition
Flashback Through Standby Database Role Transitions
Enabling Fast-Start Failover
When Will Fast-Start Failover Occur?
Configuring Fast-Start Failover
Prohibited Operations After Enabling Fast-Start Failover
Managing the Observer
Performing Role Changes
Using Enterprise Manager to Enable Fast-Start Failover
Using Data Guard in a Real Application Clusters Configuration
Real Application Clusters and Data Guard
Configuration Considerations with RAC
Configuring a Primary Database with RAC
Configuring a Standby Database with RAC
Apply Instance Failover
Role Transitions with RAC
Other Considerations for Oracle Data Guard
Using a Physical Standby Database for Read/Write Testing and Reporting
Offloading Backups to a Physical Standby Database
Using Flashback Database and Real-time Apply
Using Flashback Database After RESETLOGS
Enabling Redo Encryption
Configuring Cascaded Redo Log Destinations
Workshop
Workshop Premise
Workshop Flow
Workshop Scenarios
About The Training Provider: Oranet (pvt) Ltd
Oranet (pvt) Ltd - Oranet is a Business and IT Technology services organization delivering technical, resource and training solutions that contribute to the business transformation and economic performance of private and public sector clients.
Our specialist and focused teams in Oracle Training, Multimedia Training, Business Solutions, Resources, and Immigration Consultancy are committed to collaborative...
