Free Sample
+ Collection

Oracle Data Guard 11gR2 Administration : Beginner's Guide

Beginner's Guide
Emre Baransel, Nassyam Basha

If you’re an Oracle Database Administrator it’s almost essential to know how to protect and preserve your data. This is the perfect primer to Data Guard that covers all the bases with a totally practical, user-friendly approach.
$35.99
$59.99
RRP $35.99
RRP $59.99
eBook
Print + eBook

Want this title & more?

$21.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781849687904
Paperback404 pages

About This Book

  • Understand the essentials and components of Oracle Data Guard
  • Configure your Data Guard environment using practical examples
  • Find solutions to the most common real-world Data Guard issues
  • Dedicated chapters for Data Guard best practices and Data Guard patching
  • See how Data Guard is integrated with the existing Oracle database cluster and backup environment
  • An easy to read, comprehensive guide with clear, step-by-step instructions

Who This Book Is For

If you are an Oracle database administrator who wants to configure and administer Data Guard configurations, then "Oracle Data Guard 11gR2 Administration Beginner's Guide" is for you. With a basic understanding of Oracle database administration, you’ll be able to easily follow the book.

Table of Contents

Chapter 1: Getting Started
What is Data Guard?
Standby database
Oracle Data Guard evolution
Oracle Data Guard architecture
Time for action – monitoring Redo Apply
Time for action – using interfaces to monitor Data Guard
Other replication solutions and Data Guard
Summary
Chapter 2: Configuring the Oracle Data Guard Physical Standby Database
Preconfiguration for Data Guard
Time for action – enabling the archive log mode
Time for action – enabling force logging
Time for action – configuring standby redo logs on primary
Time for action – enabling FRA
Creating the physical standby database
Time for action – starting the physical standby instance and making it ready for the RMAN duplicate
Time for action – running an RMAN duplicate
Post-installation steps
Time for action – verifying the standby database configuration
Time for action – starting, stopping, and monitoring MRP
Time for action – verifying synchronization between the primary and standby databases
Time for action – testing real-time apply
Summary
Chapter 3: Configuring Oracle Data Guard Logical Standby Database
Logical standby database characteristics
Preparation for the configuration
Time for action – checking for the unsupported data types
Time for action – searching for and fixing any table row uniqueness problem
Creating a logical standby database
Time for action – making a physical standby database environment ready for conversion
Time for action – converting a physical standby database into a logical standby database
Verifying the logical standby database
Time for action – checking the redo transport service status
Time for action – checking the SQL Apply service status
Customization and management in a logical standby database
Time for action – working with skip rules on a logical standby database
Time for action – changing the Database Guard setting
Time for action – creating objects on the logical standby database
Summary
Chapter 4: Oracle Data Guard Broker
Introduction to Data Guard broker
Data Guard broker features and benefits
Data Guard broker components
Implementation of Oracle Data Guard broker
Time for action – initial setup of Data Guard broker
Time for action – connecting to Data Guard broker
Time for action – basic monitoring with Data Guard broker
Management with Data Guard broker
Time for action – disabling broker configuration
Time for action – disabling and enabling database
Time for action – changing the database name
Most Common Data Guard broker issues
Oracle Data Guard fast-start failover
Time for action – configuring fast-start failover
Summary
Chapter 5: Data Guard Protection Modes
The Maximum Protection mode
The Maximum Performance mode
The Maximum Availability mode
Choosing the correct mode for your requirements
Changing Data Guard protection mode
Time for action – changing the protection mode with SQL*Plus
Time for action – changing the protection mode with Data Guard broker
Time for action – changing the protection mode with Enterprise Manager Cloud Control
Summary
Chapter 6: Data Guard Role Transitions
Role transition considerations
Switchover
Time for action – preliminary tests before performing switchover
Time for action – switchover with a physical standby using SQL*Plus
Time for action – switchover with a physical standby using broker
Time for action – switchover with a physical standby using EM Cloud Control
Time for action – switchover with a logical standby database using SQL*Plus
Time for action – switchover with a logical standby using broker
Failover
Time for action – failover with a physical standby database using SQL*Plus
Time for action – failover with a logical standby using broker
Summary
Chapter 7: Active Data Guard, Snapshot Standby, and Advanced Techniques
Oracle Active Data Guard
Time for action – enabling Active Data Guard if Redo Apply is running using SQL *PLUS
Time for action – enabling Active Data Guard if the standby database is shut down
Time for action – enabling Active Data Guard using broker
Time for action – Active Data Guard with PeopleSoft
Time for action – exporting a database backup from Active Data Guard
Time for action – using the ASH report from the standby database
Using a snapshot standby database
Time for action – converting to a snapshot standby database
Time for action – converting to a physical standby database
Cascade standby databases
Time for action – cascade standby database
Advanced compression in Data Guard
Time for action – enabling advanced compression
Preparation of standby on a cross-platform Data Guard
Time for action – creating a cross-platform Data Guard setup
Data Guard tuning and wait events
Summary
Chapter 8: Integrating Data Guard with the Complete Oracle Environment
The Oracle Enterprise Manager Cloud Control integration
Time for action – adding the Data Guard configuration into Cloud Control
Time for action – enabling/disabling fast-start failover
Time for action – setting the threshold and creating an incident for estimated failover time metric
RMAN integration
Time for action – recovering a primary database using a standby database disk backup
RAC integration
Summary
Chapter 9: Data Guard Configuration Patching
What is patch and what are patch types?
Best practices of patching
Upgrading OPatch
Performing prerequisite checks of patch
How to clean up patch history?
Patching on Data Guard configuration
Time for action – applying a patch on logical standby
Time for action – applying PSU on a physical standby database
Time for action – patch set upgrade of physical standby
Summary
Chapter 10: Common Data Guard Issues
Recreating the standby control file
Time for action – recreating the standby control file
Dealing with redo transport authentication problems
Time for action – changing the SYS password in a Data Guard environment
Time for action – changing the redo transport user
Dealing with UNNAMED datafiles
Time for action – resolving UNNAMED datafile errors
Closing a gap with an RMAN incremental backup
Time for action – closing a gap with an RMAN incremental backup
Fixing NOLOGGING changes on the standby database
Time for action – fixing NOLOGGING changes on a standby database with incremental datafile backups
Time for action – fixing NOLOGGING changes in the standby database with incremental database backups
Turning on Data Guard tracing
Gathering diagnostic data
Time for action – monitoring the database alert log using ADRCI
Summary
Chapter 11: Data Guard Best Practices
Configuring a connection failover
Time for action – configuring FCF for JDBC connections
The archived log deletion policy on the standby database
Time for action – the recommended configuration for archived log maintenance on a standby database
Using flashback on a standby database
Time for action – using flashback on a standby database
Database rolling upgrade using the transient logical standby database
Time for action – performing a rolling upgrade using the transient logical standby database
Corruption detection, prevention, and automatic repair with Oracle Data Guard
Summary

What You Will Learn

  • Implement Data Guard best practices
  • Set up physical and logical standby databases to build Data Guard configurations
  • Configure and use Data Guard Broker for an easier and more comprehensive management of Data Guard
  • Design configurations with different data protection levels
  • Perform switchover and failover operations
  • Use Active Data Guard and Snapshot Standby features to access standby databases in read-only and read-write modes
  • Integrate Data Guard with RAC, RMAN, and Enterprise Manager 12c Cloud Control
  • Patch Oracle Databases in a Data Guard environment
  • Deal with the most common Data Guard issues
  • Configure cascade standby databases, compression, and cross-platform implementation

In Detail

Data Guard is the high availability, disaster recovery and data replication solution for Oracle Databases.

With the huge growth of Data Guard it’s getting harder to encounter an Oracle DBA not dealing with Data Guard. Since it’s a common DBA task to provide high availability of databases, Data Guard is a must-know topic for every Oracle Database Administrator.

"Oracle Data Guard 11g R2 Beginner's Administration Guide" is a practical guide that provides all the information you will need to configure and maintain Data Guard. This book will show you what Data Guard can really do.

By following the practical examples in this book, you’ll learn to set up your Data Guard Broker, the management framework for Data Guard configurations. Learn and implement different data protection modes, perform role transitions between databases (switchover and failover) and configure Active Data Guard. Next, we will dive into the features of Snapshot Standby. The book progresses into looking at Data Guard configuration with other Oracle products (such as EM, RAC, and RMAN) and patch databases in Data Guard. The final chapters will cover commonly encountered Data Guard issues and Data Guard best practices, which are very important to make a Data Guard configuration perfect and take maximum advantage of Data Guard properties.

Authors

Read More

Recommended for You