Oracle Data Guard 11gR2 Administration Beginner's Guide


Oracle Data Guard 11gR2 Administration Beginner's Guide
eBook: $35.99
Formats: PDF, PacktLib, ePub and Mobi formats
$30.59
save 15%!
Print + free eBook + free PacktLib access to the book: $95.98    Print cover: $59.99
$59.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Reviews
Support
Sample Chapters
  • 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

Book Details

Language : English
Paperback : 404 pages [ 235mm x 191mm ]
Release Date : June 2013
ISBN : 1849687900
ISBN 13 : 9781849687904
Author(s) : Emre Baransel, Nassyam Basha
Topics and Technologies : All Books, Enterprise Products and Platforms, Oracle Database, Beginner's Guides, Enterprise, Oracle

Table of Contents

Preface
Chapter 1: Getting Started
Chapter 2: Configuring the Oracle Data Guard Physical Standby Database
Chapter 3: Configuring Oracle Data Guard Logical Standby Database
Chapter 4: Oracle Data Guard Broker
Chapter 5: Data Guard Protection Modes
Chapter 6: Data Guard Role Transitions
Chapter 7: Active Data Guard, Snapshot Standby, and Advanced Techniques
Chapter 8: Integrating Data Guard with the Complete Oracle Environment
Chapter 9: Data Guard Configuration Patching
Chapter 10: Common Data Guard Issues
Chapter 11: Data Guard Best Practices
Pop Quiz Answers
Index
  • Chapter 1: Getting Started
    • What is Data Guard?
    • Standby database
      • Physical standby database
      • Logical standby database
      • Snapshot standby database
  • Oracle Data Guard evolution
    • Version 7.3 – stone age
    • Version 8i – first age
    • Version 9i – middle age
    • Version 10g – new age
    • Version 11g – modern age
  • Oracle Data Guard architecture
    • Data Guard services
      • Redo transport services
      • Apply services
  • Time for action – monitoring Redo Apply
    • SQL Apply (logical standby databases)
  • Role transitions
    • Switchover
    • Failover
  • User interfaces for administering Data Guard
    • SQL*Plus
    • DGMGRL
    • Enterprise Manager
  • Time for action – using interfaces to monitor Data Guard
    • Data Guard background processes
  • Other replication solutions and Data Guard
    • Storage-based replication solutions
    • GoldenGate and Streams
  • Summary
    • Time for action – enabling force logging
      • Standby redo logs
    • Time for action – configuring standby redo logs on primary
      • Fast recovery area (FRA)
    • Time for action – enabling FRA
      • Understanding initialization parameters
      • DB_NAME
      • DB_UNIQUE_NAME
      • LOG_ARCHIVE_CONFIG
      • LOG_ARCHIVE_MAX_PROCESSES
      • LOG_ARCHIVE_DEST_n
      • LOCATION and SERVICE
      • VALID_FOR
      • SYNC and ASYNC
      • AFFIRM and NOAFFIRM
      • COMPRESSION
      • MAX_CONNECTIONS
      • MAX_FAILURE
      • REOPEN
      • NET_TIMEOUT
      • DELAY
      • LOG_ARCHIVE_DEST_STATE_n
    • Creating the physical standby database
      • Standby database related initialization parameters
        • FAL_SERVER
        • STANDBY_FILE_MANAGEMENT
        • DB_FILE_NAME_CONVERT
        • LOG_FILE_NAME_CONVERT
      • The physical standby database instance
    • Time for action – starting the physical standby instance and making it ready for the RMAN duplicate
      • Using RMAN duplicate to create physical standby databases
    • Time for action – running an RMAN duplicate
    • Post-installation steps
      • Verifying the standby database configuration
    • Time for action – verifying the standby database configuration
      • Managing Redo Apply
    • Time for action – starting, stopping, and monitoring MRP
      • Verifying synchronization between the primary and standby databases
    • 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
          • Not everything must be duplicated
          • Use for reporting at all times
          • Independent standby database objects
          • Protecting writes on replicated standby tables
          • Limitation for specific data types and objects
          • High availability and disaster recovery considerations
        • 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
          • Selective replication in a logical standby database
        • Time for action – working with skip rules on a logical standby database
          • Data base Guard settings for the logical standby database
        • Time for action – changing the Database Guard setting
          • Disabling database guard for a session
        • Creating objects on the logical standby database
          • Creating and re-creating tables
          • Creating scheduler jobs
          • Creating materialized views
      • Time for action – creating objects on the logical standby database
        • Automatic deletion of archived logs
          • Deletion of the foreign archived logs
          • Deletion of the local archived logs
      • Summary
        • Chapter 4: Oracle Data Guard Broker
          • Introduction to Data Guard broker
          • Data Guard broker features and benefits
            • Centralized and simple management
            • Cloud Control integration
            • Oracle Data Guard and RAC
            • Role transition with Data Guard broker
            • Data Guard fast-start failover
              • Recommendation
          • Data Guard broker components
            • Oracle Data Guard broker server-side components
              • Data Guard Monitor process (DMON)
              • Configuration file
            • Oracle Data Guard broker client-side components
              • DGMGRL utility
              • Enterprise Manager Cloud Control client
          • 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
            • Enabling and disabling broker configuration
          • Time for action – disabling broker configuration
            • Enabling and disabling a standby database
          • Time for action – disabling and enabling database
            • Changing configuration and database properties using broker
          • Time for action – changing the database name
            • Changing the state of the database
            • Troubleshooting Data Guard broker
            • Data Guard tracing
          • 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
              • Current listener description
          • Oracle Data Guard fast-start failover
          • Time for action – configuring fast-start failover
            • Troubleshooting observer configuration
            • Script to stop and start observer
          • 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
                • Performing switchover with a physical standby database using SQL*Plus
              • Time for action – preliminary tests before performing switchover
              • Time for action – switchover with a physical standby using SQL*Plus
                • Performing switchover with a physical standby database using broker
              • Time for action – switchover with a physical standby using broker
                • Performing switchover with a physical standby database using EM Cloud Control
              • Time for action – switchover with a physical standby using EM Cloud Control
                • Performing switchover with a logical standby database using SQL*Plus
              • Time for action – switchover with a logical standby database using SQL*Plus
                • Performing switchover with a logical standby database using broker
              • Time for action – switchover with a logical standby using broker
              • Failover
                • Performing failover with a physical standby database
              • Time for action – failover with a physical standby database using SQL*Plus
                • Performing failover with a logical standby database
              • 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
                  • Why Active Data Guard?
                  • Oracle Data Guard license
                  • Enabling 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
                  • Monitoring Active Data Guard
                    • From primary
                    • From standby
                  • Active Data Guard with applications
                    • Active Data Guard with PeopleSoft
                • Time for action – Active Data Guard with PeopleSoft
                  • Active Data Guard with EBS
                  • Active Data Guard with TopLink
                  • Active Data Guard with Oracle BI
                  • Active Data Guard with SAP
                • Active Data Guard features
                  • EXPDP from standby database using NETWORK_LINK (ADG)
              • 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
                • Limitations with cascade standby database
              • 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
                • Network tuning
                • Redo transport and apply tuning
                • Data Guard 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
                    • Cloud Control Data Guard administration home page
                    • Modifying the Data Guard configuration
                  • Time for action – enabling/disabling fast-start failover
                    • Monitoring Data Guard performance
                    • Using Incident Manager to monitor Data Guard
                  • Time for action – setting the threshold and creating an incident for estimated failover time metric
                  • RMAN integration
                    • Integration requirements and best practices
                      • Physical standby requirement
                      • RMAN Catalog requirement
                      • Using a different DB_UNIQUE_NAME
                      • General RMAN best practices
                    • RMAN settings for the Data Guard environment
                      • Registering primary database in the catalog
                      • Configuring RMAN settings for primary database:
                      • Configuring RMAN settings for standby database
                      • Checking the RMAN configuration
                  • Time for action – recovering a primary database using a standby database disk backup
                    • Using block change tracking with Data Guard
                  • RAC integration
                    • A RAC primary database with a single instance standby database
                    • A RAC primary database with a RAC standby database
                  • Summary
                  • Chapter 9: Data Guard Configuration Patching
                    • What is patch and what are patch types?
                      • Interim patch
                      • CPU/SPU patches
                      • PSU patches
                      • Patch set
                      • Patching on Data Guard
                    • Best practices of patching
                    • Upgrading OPatch
                    • Performing prerequisite checks of patch
                    • How to clean up patch history?
                    • Patching on Data Guard configuration
                      • How to apply an interim/bug patch on logical standby?
                    • Time for action – applying a patch on logical standby
                      • How to apply a PSU patch on physical standby database using broker?
                    • Time for action – applying PSU on a physical standby database
                      • How to apply patch set on physical standby (11.2.0.1 to 11.2.0.3)?
                    • 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
                        • Alert log and trace files
                      • Time for action – monitoring the database alert log using ADRCI
                        • Data Guard broker logs
                        • Dynamic performance views
                      • Summary
                      • Chapter 11: Data Guard Best Practices
                        • Configuring a connection failover
                          • Transparent Application Failover (TAF)
                            • Configuring the client-side TAF
                            • Configuring the server-side TAF
                          • Fast Connection Failover (FCF)
                        • Time for action – configuring FCF for JDBC connections
                          • Fast Application Notification (FAN)
                        • 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
                          • DB_BLOCK_CHECKSUM
                          • DB_BLOCK_CHECKING
                          • DB_LOST_WRITE_PROTECT
                          • Automatic block media repair
                        • Summary
                        • Pop Quiz Answers
                          • Chapter 1, Getting Started
                          • Chapter 5, Data Guard Protection Modes
                          • Chapter 9, Data Guard Configuration Patching
                          • Chapter 10, Common Data Guard Issues

                          Emre Baransel

                          Emre Baransel is a graduate of Electrical and Electronic engineering and has two Master's, one in Business Administration and the other one in Information Systems. He has been working in the IT industry for the past 10 years. He has worked for one of the largest fixed-line and GSM technology based companies in Turkey. He was nominated as an Oracle ACE in 2012. He's an Oracle Certified Professional (OCP), a founding member of TROUG (Turkish Oracle User Group), and a blogger at emrebaransel.blogspot.com. He has spoken at the Oracle Open World in the US and at user group conferences in different countries of Europe. He has also contributed to the Oracle RMAN 11g Backup and Recovery book in 2010. He has focused specially on high database availability and disaster recovery solutions, cloud technologies, and database security.

                          Nassyam Basha

                          Nassyam Basha is a Database Administrator. He has around seven years of IT experience of which the last five years have been as a Production Oracle DBA. He is a post graduate who holds a master's degree in Computer Applications from the University of Madras. He started working with dBase and FoxPro, and has participated in several projects with FoxPro and Oracle database starting from Oracle 7. He is an Oracle 10g Certified Professional having good knowledge in Oracle technologies such as Data Guard, RMAN, RAC, and performance tuning. He has completed more than 90 Data Guard setups on all platforms, from RAC to non-RAC and successful cluster migrations with switchovers and failovers for many business-critical production databases with major Data Guard-related issues. He actively participates in Oracle-related forums such as OTN, having 9000+ posts, using the profile Freelists (https://forums.oracle.com/forums/profile.jspa editMode=true&userID=651869). He maintains an Oracle technology-related blog, (www.oracle-ckpt.com) and he is reachable at nassyambasha@gmail.com.

                          Code Downloads

                          Download the code and support files for this book.


                          Submit Errata

                          Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.


                          Errata

                          - 1 submitted: last submission 14 Aug 2013

                          Errata Category: Typo| Page no: 313

                          In the Time for action section,

                          "1. Create a new database, which will be used for redo transport in the  
                          primary database."

                          Should be

                           

                          "1. Create a new database user, which will be used for redo transport in the primary
                          database."

                           

                          Sample chapters

                          You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                          Frequently bought together

                          Oracle Data Guard 11gR2 Administration Beginner's Guide +    Getting Started with IBM FileNet P8 Content Manager =
                          50% Off
                          the second eBook
                          Price for both: $51.15

                          Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                          What you will learn from this book

                          • 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.

                          Approach

                          Using real-world examples and hands-on tasks, Oracle Data Guard 11gR2 Administration Beginner's Guide will give you a solid foundation in Oracle Data Guard. It has been designed to teach you everything you need to know to successfully create and operate Data Guard environments with maximum flexibility, compatibility, and effectiveness.

                          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.

                          Code Download and Errata
                          Packt Anytime, Anywhere
                          Register Books
                          Print Upgrades
                          eBook Downloads
                          Video Support
                          Contact Us
                          Awards Voting Nominations Previous Winners
                          Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                          Resources
                          Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software