*Friday CLOSED

Timings 10.00 am - 08.00 pm

Call : 021-3455-6664, 0312-216-9325 DHA 021-35344-600, 03333808376, ISB 03333808376

Oracle Database 11g – Data Guard Administration


Be the first to rate Oracle Database 11g – Data Guard Administration
Or log in to access your purchased courses
by admin2
Price: 50,000
4 Days
0 Lessons

Data Guard Admin Course

Oracle Database 11g – Data Guard Administration

This Oracle Database 11g: Data Guard Administration Release 2 training helps you develop the skills to use Oracle Data Guard to help protect your Oracle database against planned and unplanned downtimes. Explore how Data Guard standby databases can be used to support production functions such as reporting, querying and testing, while in a standby role.


Benefits To You:

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.


Data Guard Architecture

This course explores Data Guard architecture, the configuration of physical and logical standby databases and role transitions. Expert instructors will also help you explore Oracle Data Guard 11g features, including Oracle Active Data Guard and snapshot standby databases.


Course Content:

Introduction to Oracle Data Guard

Causes of Data Loss
Oracle Data Guard Architecture
Types of Standby Databases (benefits of each type)
Using the Data Guard Broker
Differentiating Between Standby Databases and Data Guard Broker Configuration
Data Protection Modes
Performing Role Transitions


Creating a Physical Standby Database by Using SQL and RMAN Commands

Preparing the Primary Database
Creating the Physical Standby Database


Oracle Data Guard Broker: Overview

Oracle Data Guard Broker Features
Oracle Data Guard Broker Configurations
Data Guard Monitor Process
Data Guard Monitor Configuration Files
Benefits of Using the Data Guard Broker
Comparing Configuration Management With and Without the Broker
Using DGMGRL


Creating a Data Guard Broker Configuration

Defining a Data Guard Configuration (overview)
Setting up the Broker Configuration Files
Setting the DG_BROKER_START Initialization Parameter to TRUE to start the Data Guard Broker
Creating the Broker Configuration
Adding the Standby Database to the Configuration


Creating a Physical Standby Database by Using Enterprise Manager Grid Control

Using Enterprise Manager Grid Control to Create a Physical Standby Database
Using the Add Standby Database Wizard
Verifying a Configuration
Editing Standby database properties
Viewing the Data Guard Configuration Status


Creating a Logical Standby Database

Monitoring the Data Guard Configuration by Using Enterprise Manager Grid ControlVerifying the configuration viewing Log File Details
Using Enterprise Manager Data Guard Metrics
Using the DGMGRL SHOW CONFIGURATION Command to Monitor the Configuration
Viewing Standby Redo Log Information
Monitoring Redo Apply


Creating and Managing a Snapshot Standby Database

Snapshot Standby Database: Architecture
Converting a Physical Standby Database to a Snapshot Standby Database
Activating a Snapshot Standby Database: Issues and Cautions
Viewing Snapshot Standby Database Information
Converting a Snapshot Standby Database to a Physical Standby Database


Using Oracle Active Data Guard

Using Real-Time Query
Enabling and Disabling Real-Time Query
Enabling Block Change Tracking on a Physical Standby Database
Creating Fast Incremental Backups
Monitoring Block Change Tracking


Configuring Data Protection Modes

Preparing to Create a Logical Standby Database
Checking for Unsupported Objects, Data Types, and Tables
Ensuring Unique Row Identifiers
Creating the Logical Standby Using SQL Commands and Grid Control
Securing your Logical Standby Database


Performing Role Transitions

Contrast switchover vs. failover
Preparing for a Switchover
Performing a Switchover using DGMGRL and Enterprise Manager
Types of Failovers
Re-enabling Disabled Databases


Using Flashback Database in a Data Guard Configuration

Overview of Flashback Database
Configuring Flashback Database
Using Flashback Database Instead of Apply Delay
Using Flashback Database and Real-Time Apply
Flashback Through Standby Database Role Transitions
Using Flashback Database After Failover


Enabling Fast-Start Failover

Installing the Observer Software
Configuring Fast-Start Failover
Configuring Automatic Reinstatement of the Primary Database
Initiating Fast-Start Failover from an Application
Disabling Fast-Start Failover
Starting and Stopping the Observer
Moving the Observer to a new Host


Managing Client Connectivity

Understanding Client Connectivity in a Data Guard Configuration
Preventing Clients from Connecting to the Wrong Database
Creating Services for the Data Guard Configuration Databases
Automating Client Failover in a Data Guard Configuration
Automating Failover for OCI Clients
Automating Failover for OLE DB Clients
Configuring JDBC Clients for Failover


Performing Backup and Recovery Considerations in an Oracle Data Guard Configuration

Backup and Recovery of a Logical Standby Database
Using the RMAN Recovery Catalog in a Data Guard Configuration
Creating the Recovery Catalog
Registering a Database in the Recovery Catalog
Configuring Daily Incremental Backups
Using a Backup to Recover a Data File on the Primary Database
Recovering a Data File on the Standby Database
Patching and Upgrading Databases in a Data Guard Configuration
Upgrading an Oracle Data Guard Broker Configuration
Using SQL Apply to Upgrade the Oracle Database
Performing a Rolling Upgrade by Using SQL Apply
Performing a Rolling Upgrade by Using an Existing Logical Standby Database
Performing a Rolling Upgrade by Creating a New Logical Standby Database
Performing a Rolling Upgrade by Using a Physical Standby Database


Monitoring a Data Guard Configuration

Monitoring the Data Guard Configuration by Using Enterprise Manager Grid ControlVerifying the ConfigurationViewing Log File Details
Using Enterprise Manager Data Guard Metrics
Using the DGMGRL SHOW CONFIGURATION Command to Monitor the Configuration
Viewing Standby Redo Log Information
Monitoring Redo Apply


Optimizing a Data Guard Configuration

Using Enterprise Manager Grid Control to monitor configuration performance
Setting the ReopenSecs and NetTimeout database properties
Compressing Redo Data
Delaying the Application of Redo Data
Optimizing SQL Apply
Adjusting the Number of APPLIER and PREPARER processes


Training Track: Database


📖 Oracle DataBase 11g: Administration-I Free Exam Practise Test



Flexible Class Options

  • Week End Classes For Professionals  SAT | SUN
  • Corporate Group Trainings Available
  • Online Classes – Live Virtual Class (L.V.C), Online Training

Related Oracle Courses

Oracle SQL Fundamentals
Oracle Database Admin – I
Oracle Database Admin – II
Oracle Forms Developer
Oracle BI Analytics and Dashboards


[/vc_column_text]

KEY FEATURES

Flexible Classes Schedule

Online Classes for out of city / country students

Unlimited Learning - FREE Workshops

FREE Practice Exam

Internships Available

Free Course Recordings Videos

Register Now

[/vc_column][/vc_row]

Lessons

Or log in to access your purchased courses
Explore how Data Guard standby databases can be used to support production functions such as reporting, querying and testing.
ABOUT US

OMNI ACADEMY & CONSULTING is one of the most prestigious Training & Consulting firm, founded in 2010, under MHSG Consulting Group aim to help our customers in transforming their people and business - be more engage with customers through digital transformation. Helping People to Get Valuable Skills and Get Jobs.

Read More

Contact Us

Get your self enrolled for unlimited learning 1000+ Courses, Corporate Group Training, Instructor led Class-Room and ONLINE learning options. Join Now!
  • Head Office: A-2/3 Westland Trade Centre, Shahra-e-Faisal PECHS Karachi 75350 Pakistan Call 0213-455-6664 WhatsApp 0334-318-2845, 0336-7222-191, +92 312 2169325
  • Gulshan Branch: A-242, Sardar Ali Sabri Rd. Block-2, Gulshan-e-Iqbal, Karachi-75300, Call/WhatsApp 0213-498-6664, 0331-3929-217, 0334-1757-521, 0312-2169325
  • ONLINE INQUIRY: Call/WhatsApp +92 312 2169325, 0334-318-2845, Lahore 0333-3808376, Islamabad 0331-3929217, Saudi Arabia 050 2283468
  • DHA Branch: 14-C, Saher Commercial Area, Phase VII, Defence Housing Authority, Karachi-75500 Pakistan. 0213-5344600, 0337-7222-191, 0333-3808-376
  • info@omni-academy.com
  • FREE Support | WhatsApp/Chat/Call : +92 312 2169325
WORKING HOURS

  • Monday10.00am - 7.00pm
  • Tuesday10.00am - 7.00pm
  • Wednesday10.00am - 7.00pm
  • Thursday10.00am - 7.00pm
  • FridayClosed
  • Saturday10.00am - 7.00pm
  • Sunday10.00am - 7.00pm
WhatsApp Us