Book description
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.
- 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
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.
Table of contents
-
Oracle Data Guard 11gR2 Administration Beginner's Guide
- Table of Contents
- Oracle Data Guard 11gR2 Administration Beginner's Guide
- Credits
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Preface
- 1. Getting Started
-
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
-
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
-
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
- ORA-16797: database is not using a server parameter file
- ORA-10458:standby database requires recovery
- ORA-16737:the redo transport service for standby database "string" has an error
- ORA-16715:redo transport-related property string of standby database "string" is inconsistent
- ORA-12514:TNS:listener does not currently know of service requested in connect descriptor
- Oracle Data Guard fast-start failover
- Time for action – configuring fast-start failover
- Summary
-
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
-
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
-
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
-
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
-
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
-
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
-
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
- Pop Quiz Answers
- Index
Product information
- Title: Oracle Data Guard 11gR2 Administration Beginner's Guide
- Author(s):
- Release date: June 2013
- Publisher(s): Packt Publishing
- ISBN: 9781849687904
You might also like
book
Oracle Data Guard 11g Handbook
Master Oracle Data Guard 11 g Provide superior data protection, availability, and disaster recovery using the …
book
Oracle Database Administration: The Essential Refe
Visit the catalog page for Oracle Database Administration: The Essential RefeVisit the errata page for Oracle …
book
Oracle Database 12c Security
Best Practices for Comprehensive Oracle Database Security Written by renowned experts from Oracle's National Security Group, …
book
Oracle Database 12c Oracle RMAN Backup & Recovery
This authoritative Oracle Press resource on RMAN has been thoroughly revised to cover every new feature, …