Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Checkout

Change country

Modal Close icon
Country selected Country selected
country flag Germany
Country selected
country flag Slovakia
Country selected
country flag Canada
Country selected
country flag Brazil
Country selected
country flag Singapore
Country selected
country flag Hungary
Country selected
country flag Philippines
Country selected
country flag Mexico
Country selected
country flag Thailand
Country selected
country flag Ukraine
Country selected
country flag Luxembourg
Country selected
country flag Estonia
Country selected
country flag Lithuania
Country selected
country flag Norway
Country selected
country flag Chile
Country selected
country flag United States
Country selected
country flag Great Britain
Country selected
country flag India
Country selected
country flag Spain
Country selected
country flag South Korea
Country selected
country flag Ecuador
Country selected
country flag Colombia
Country selected
country flag Taiwan
Country selected
country flag Switzerland
Country selected
country flag Indonesia
Country selected
country flag Cyprus
Country selected
country flag Denmark
Country selected
country flag Finland
Country selected
country flag Poland
Country selected
country flag Malta
Country selected
country flag Czechia
Country selected
country flag New Zealand
Country selected
country flag Austria
Country selected
country flag Turkey
Country selected
country flag France
Country selected
country flag Sweden
Country selected
country flag Italy
Country selected
country flag Egypt
Country selected
country flag Belgium
Country selected
country flag Portugal
Country selected
country flag Slovenia
Country selected
country flag Ireland
Country selected
country flag Romania
Country selected
country flag Greece
Country selected
country flag Argentina
Country selected
country flag Malaysia
Country selected
country flag South Africa
Country selected
country flag Netherlands
Country selected
country flag Bulgaria
Country selected
country flag Latvia
Country selected
country flag Australia
Country selected
country flag Japan
Country selected
country flag Russia
Country selected
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Home > Data > Database Administration > Oracle Data Guard 11gR2 Administration : Beginner's Guide
Oracle Data Guard 11gR2 Administration : Beginner's Guide
Oracle Data Guard 11gR2 Administration : Beginner's Guide

Oracle Data Guard 11gR2 Administration : Beginner's Guide: 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.

$27.98 $39.99
Full star icon Full star icon Full star icon Full star icon Half star icon 4.6 (10 Ratings)
eBook Jun 2013 404 pages 1st Edition
eBook
$27.98 $39.99
Paperback
$65.99
Subscription
Free Trial
Renews at $19.99p/m
$27.98 $39.99
Full star icon Full star icon Full star icon Full star icon Half star icon 4.6 (10 Ratings)
eBook Jun 2013 404 pages 1st Edition
eBook
$27.98 $39.99
Paperback
$65.99
Subscription
Free Trial
Renews at $19.99p/m
eBook
$27.98 $39.99
Paperback
$65.99
Subscription
Free Trial
Renews at $19.99p/m

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR

Contact Details

Modal Close icon
Payment Processing...
tick Completed

Billing Address

Table of content icon View table of contents Preview book icon Preview Book

Oracle Data Guard 11gR2 Administration : Beginner's Guide

Chapter 2. Configuring the Oracle Data Guard Physical Standby Database

In this chapter, the installation of the physical standby database will be covered in three steps. The first step will be to prepare the environment for the installation, especially the preinstallation tasks on the database. Then the second step for creating a physical standby database will be covered. In the last step, the Data Guard installation will be verified to see if it is installed correctly.

In this chapter, we'll discuss the following topics:

  • Planning and understanding requirements

  • Preparation for the configuration

  • Step-by-step instructions to create the physical standby database

  • Verifying the physical standby database configuration (post-installation steps)

Before preparing the configuration, you should know the business criticality of your database, how to avoid failures, and how much data you are ready to lose.

Preconfiguration for Data Guard

The Data Guard configuration contains a primary database that transmits redo data to a standby database. The standby database is remotely located from the primary database for disaster recovery and backup operations. You can also configure the standby database at the same location as the primary database. However, for disaster-recovery purposes and to make it highly available, it's strongly recommended to configure standby in a geographically remote location.

Before implementing a Data Guard configuration, take into account concepts such as high data availability, efficient systems utilization, and data protection.

  • Availability: Outages should be tolerated transparently and should be recovered quickly in case of server failures or any network failures

  • Protection: Ensure minimum data loss; standby data should be isolated from production faults such as storage failures, site failures, data corruptions, or operator errors

  • Utilization: Standby resources should...

Time for action – enabling the archive log mode

Perform the following steps on the primary database:

  1. Check whether archiving has been enabled or disabled, as follows:

    SQL> archive log list
Database log mode                No Archive Mode
Automatic archival               Disabled
Archive destination              USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence       6
Current log sequence             8

  2. Perform a clean shutdown, as follows:

    SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

    Tip

    Ensure that you have performed a clean shutdown; if not, you may see this error: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode.

  3. Start the database in the mount state.

    SQL>startup mount
ORACLE instance started.
Total System Global Area      818401280 bytes
Fixed Size                    2217792 bytes
Variable Size                 515901632 bytes
Database Buffers              297795584 bytes
Redo Buffers                  2486272 bytes...

Time for action – enabling force logging

Perform the following steps on the primary database:

  1. Check the force logging status as follows:

    SQL> select name, force_logging from v$database;
NAME      FOR
--------- ---
ORCL      NO

  2. Enable the force logging mode as follows:

    Enabling Force Logging on Primary Database is mandatory. 
SQL> alter database force logging;
Database altered.

  3. Check the force logging status again as follows:

    SQL> select name,force_logging from v$database;
NAME      FOR
--------- ---
ORCL      YES

    In the alert log, you'll see following lines:

    alter database force logging
ALTER DATABASE FORCE LOGGING command is waiting for existing direct writes to finish. This may take a long time.
Completed: alter database force logging

What just happened?

We've put the primary database in the force logging mode, which is required for the Data Guard physical standby database to work properly.

Standby redo logs

Standby redo logfiles are used by a standby database to store the redo...

Time for action – configuring standby redo logs on primary

Run the following procedures on the primary database to create standby redo logfiles:

  1. Check the ORL's members and the sizes of each member as follows:

    SQL> select a.group#, a.status, a.bytes/1024/1024 SizeMB, b.member from v$log a, v$logfile b where a.group#=b.group# order by group#;

GROUP# STATUS       SizeMB MEMBER
------ -------- ---------- --------------------------------------
     1 INACTIVE        100 /u01/app/oracle/oradata/orcl/redo01.log
     2 CURRENT         100 /u01/app/oracle/oradata/orcl/redo02.log
     3 INACTIVE        100 /u01/app/oracle/oradata/orcl/redo03.log
     4 INACTIVE        100 /u01/app/oracle/oradata/orcl/redo04.log

    Tip

    In this single instance of the primary database, we have four redo log groups, each with one member and a size of 100 MB. We should create at least five standby redo log groups.

  2. Add the standby redo logfiles as shown in the following example:

    SQL> alter database add standby logfile...

Time for action – enabling FRA

Perform the following steps on the primary database now. We'll be enabling FRA on the standby database later.

  1. Check the default FRA location as follows:

    SQL> show parameter db_recovery_file_dest
NAME                                 TYPE        VALUE
------------------------------------ ----------- -----------
db_recovery_file_dest                string

  2. Configure the FRA size.

    SQL> alter system set db_recovery_file_dest_size=4g;
System altered.

  3. Configure the FRA destination.

    SQL> alter system set db_recovery_file_dest='/u01/app/oracle/flash_recovery_area';
System altered.

  4. Control the FRA configuration.

    SQL> show parameter db_recovery_file_dest
NAME                        VALUE
----------------------      ------------------------
db_recovery_file_dest       /u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size  4G

Tip

In RAC databases, use the keyword sid='*'; this ensures that the change will apply to all instances in the cluster.

What just...

Creating the physical standby database

In order to create a physical standby database, we first need to install Oracle database binaries to the standby database server and then start a standby database instance. Installing Oracle binaries is out of this book's scope, so it's assumed a standby server is ready with the Oracle database software installed. We will start by covering a standby database instance and copying database files from primary to standby, but first let's look at the initialization parameters that we need to set on standby before starting the instance.

Standby database related initialization parameters

The following are the important Data-Guard-related initialization parameters we set on physical standby databases.

FAL_SERVER

This parameter specifies from where the standby database should request missing archived logs if there is a gap in the logs. It is used only when the database is in the standby role and has a gap in the received archived logs.

A redo gap occurs when the...

Time for action – starting the physical standby instance and making it ready for the RMAN duplicate

Execute the following steps to start a database instance on the standby server and make it ready for the RMAN duplicate operation.

  1. Create a service in Windows.

    If you are creating a Data Guard configuration in Windows, you must create a service using the oradim utility as follows:

    oradim -NEW -SID <sid> -STARTMODE manual -PFILE C:\app\oracle\product\11.2.0\admin\<sid>\pfile\init.ora

    You can skip this step if the environment is not Windows.

  2. Set the standby database initialization parameters:

    Copy the PFILE from the primary system to the standby system under the $ORACLE_HOME/dbs directory with the proper name (initINDIA.ora in our example). Make changes as needed if the control file locations will be different on the standby database and then change locations. The diagnostic destination and memory must be checked. You also need to set the standby-related parameters we've just covered...

Time for action – running an RMAN duplicate

Perform the following steps to create a standby database with the RMAN duplicate method:

  1. Check the primary database status; it must be either open or mount.

    SQL> select db_unique_name,database_role,open_mode from v$database;
DB_UNIQUE_ DATABASE_ROLE    OPEN_MODE
---------- ---------------- --------------------
turkey_un  PRIMARY          READ WRITE

  2. Run the RMAN command from the standby system. Connect the primary and standby instances using Oracle Net Service names.

    [oracle@oracle-stbydbs]$ rman target sys/free2go@turkey auxiliary sys/free2go@india
Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jul 26 18:41:06 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
connected to target database: ORCL (DBID=1316772835)
connected to auxiliary database: ORCL (not mounted)

    RMAN will show the connected sessions as shown previously, which provided the primary status—either open or mounted. Also, standby is in the...

Post-installation steps

In this section, we'll verify the standby database status, start Redo Apply to synchronize the standby database with the primary database, and see how we check the status of Redo Apply at the end.

Verifying the standby database configuration

After creating the physical standby database and enabling redo transport services, you may want to verify the standby database configuration and also check if the database changes are being successfully transmitted from the primary database to standby.

Time for action – verifying the standby database configuration

Run the following actions to verify the standby database configuration and redo transport services:

  1. Connect the standby database using SQL*Plus and check for the database role and status to ensure the database role is the physical standby.

    SQL> select db_unique_name,database_role,open_mode from v$database;
DB_UNIQUE_NAME  DATABASE_ROLE    OPEN_MODE
--------------- ---------------- --------------------
india_un        PHYSICAL STANDBY MOUNTED

  2. Check the standby database, SPFILE.

    SQL> show parameter spfile
NAME   TYPE    VALUE
------ ------- --------------------------------------------------
spfile string  /u01/app/oracle/product/11.2.0/db_1/dbs/spfileINDIA.ora

    Tip

    If you have started the standby instance with PFILE, you should create an SPFILE and start an instance again using the new SPFILE.

  3. Use the v$datafile view to check the location of the datafiles in the standby database. The standby database datafile must be under the...

Time for action – starting, stopping, and monitoring MRP

Before starting Redo Apply services, the physical standby database must be in the MOUNT status. From 11g onwards, the standby database can also be in the OPEN mode. If the redo transport service is in the ARCH mode, the redo will be applied from the archived redo logfiles after being transferred to the standby database. If the redo transport service is in LGWR, the Log network server (LNS) will be reading the redo buffer in SGA and will send redo to Oracle Net Services for transmission to the standby redo logfiles of the standby database using the RFS process. On the standby database, redo will be applied from the standby redo logs.

Redo apply can be specified either as a foreground session or as a background process; it can also be started with real-time apply.

Tip

To execute the following commands, the control file must be a standby control file. If you execute these commands in a database in the primary mode, Oracle will return an...

Time for action – verifying synchronization between the primary and standby databases

By using the following steps, you can control whether the standby database is synchronized with primary:

  1. On the standby database, query the V$ARCHIVED_LOG view for the archived and applied sequences.

    For the last archived sequence, use the following:

    SQL> SELECT MAX(SEQUENCE#) FROM V$ARCHIVED_LOG;
MAX(SEQUENCE#)
--------------
           145

    For the last applied sequence, use the following:

    SQL> SELECT MAX(SEQUENCE#) FROM V$ARCHIVED_LOG WHERE APPLIED='YES';
MAX(SEQUENCE#)
--------------
           144

    From the preceding two queries, we see that the latest sequence, 145, is being archived or written into the standby redo logfiles. There's expected to be a lag of one sequence between archived and applied columns.

  2. Check the status of the latest log sequence.

    SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

 SEQUENCE# APPLIED
---------- ---------
       140 YES
       141 YES
  ...

Time for action – testing real-time apply

If real-time apply is enabled, the apply services can apply redo data without waiting for the current standby redo logfile to be archived. This allows faster role transitions because you avoid waiting for a redo log to be transported to the standby database and then applied. In this example, we'll see how changes are transferred and applied to the standby database. The redo log that includes changes is not archived on primary.

  1. In order to use real-time apply, the redo transport service from primary to standby must use LGWR. Run the following query on the primary database and check the log archive destination configuration.

    SQL> show parameter log_archive_dest_2
NAME                TYPE       VALUE
------------------- --------   ----------
log_archive_dest_2  string     SERVICE=INDIA LGWR ASYNC VALID_FOR                                                                                       =(ONLINE_LOGFILES,PRIMARY_ROLE)                    DB_UNIQUE_NAME...

Summary

We have finished this chapter by describing Data Guard physical standby database creation, configuration, and controlling. We used the RMAN duplicate from the active database method, which is the easiest and most efficient way of creating a physical standby database. This method doesn't require a backup staging disk area in either primary or standby servers because it performs a direct copy from primary files to standby. This chapter also covered pre and post steps of creating a standby database with RMAN duplicate. We learned starting, stopping, and monitoring Redo Apply and the synchronization method of physical standby databases, including real-time apply. In the next chapter, we'll learn about building a Data Guard logical standby database environment.

Left arrow icon

Page 1 of 15

Right arrow icon

Key benefits

  • 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

Description

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.

Who is this book 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.

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

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Jun 24, 2013
Length: 404 pages
Edition : 1st
Language : English
ISBN-13 : 9781849687911
Vendor :
Oracle
Category :
Data
Concepts :
Database Administration
Tools :
Oracle Database

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR

Contact Details

Modal Close icon
Payment Processing...
tick Completed

Billing Address

Product Details

Publication date : Jun 24, 2013
Length: 404 pages
Edition : 1st
Language : English
ISBN-13 : 9781849687911
Vendor :
Oracle
Category :
Data
Concepts :
Database Administration
Tools :
Oracle Database

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
START FREE TRIAL
BUY NOW
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW

Frequently bought together

Oracle Data Guard 11gR2 Administration : Beginner's Guide
Oracle Data Guard 11gR2 Administration : Beginner's Guide
Read more
Jun 2013 404 pages
Full star icon 4.6 (10)
eBook
eBook
  • eBook eBook $27.98
  • Paperback Paperback $65.99
$27.98 $39.99
$65.99
Oracle Database 12c Backup and Recovery Survival Guide
Oracle Database 12c Backup and Recovery Survival Guide
Read more
Sep 2013 440 pages
Full star icon 4.8 (10)
eBook
eBook
  • eBook eBook $27.98
  • Paperback Paperback $65.99
$27.98 $39.99
$65.99
Oracle 11g R1/R2 Real Application Clusters Essentials
Oracle 11g R1/R2 Real Application Clusters Essentials
Read more
May 2011 552 pages
Full star icon 4.4 (11)
eBook
eBook
  • eBook eBook $31.99
  • Paperback Paperback $76.99
$31.99 $45.99
$76.99
Stars icon
Total $ 208.97
Oracle Data Guard 11gR2 Administration : Beginner's Guide
$65.99
Oracle Database 12c Backup and Recovery Survival Guide
$65.99
Oracle 11g R1/R2 Real Application Clusters Essentials
$76.99
Total $ 208.97 Stars icon
Banner background image

Table of Contents

11 Chapters
Getting Started Chevron down icon Chevron up icon
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
Configuring the Oracle Data Guard Physical Standby Database Chevron down icon Chevron up icon
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
Configuring Oracle Data Guard Logical Standby Database Chevron down icon Chevron up icon
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
Oracle Data Guard Broker Chevron down icon Chevron up icon
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
Data Guard Protection Modes Chevron down icon Chevron up icon
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
Data Guard Role Transitions Chevron down icon Chevron up icon
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
Active Data Guard, Snapshot Standby, and Advanced Techniques Chevron down icon Chevron up icon
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
Integrating Data Guard with the Complete Oracle Environment Chevron down icon Chevron up icon
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
Data Guard Configuration Patching Chevron down icon Chevron up icon
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
Common Data Guard Issues Chevron down icon Chevron up icon
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
Data Guard Best Practices Chevron down icon Chevron up icon
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

Recommendations for you

Left arrow icon
Python Machine Learning By Example
Python Machine Learning By Example
Read more
Jul 2024 518 pages
Full star icon 4.9 (8)
eBook
eBook
  • eBook eBook $24.99
  • Paperback Paperback $31.99
$24.99 $36.99
$31.99 $45.99
Unlocking Data with Generative AI and RAG
Unlocking Data with Generative AI and RAG
Read more
Sep 2024 346 pages
eBook
eBook
  • eBook eBook $21.99
  • Paperback Paperback $27.98
$21.99 $31.99
$27.98 $39.99
Building LLM Powered Applications
Building LLM Powered Applications
Read more
May 2024 342 pages
Full star icon 4.2 (22)
eBook
eBook
  • eBook eBook $27.98
  • Paperback Paperback $34.98
$27.98 $39.99
$34.98 $49.99
Python for Algorithmic Trading Cookbook
Python for Algorithmic Trading Cookbook
Read more
Aug 2024 404 pages
Full star icon 4.6 (15)
eBook
eBook
  • eBook eBook $32.99
  • Paperback Paperback $41.98
$32.99 $47.99
$41.98 $59.99
Machine Learning with PyTorch and Scikit-Learn
Machine Learning with PyTorch and Scikit-Learn
Read more
Feb 2022 774 pages
Full star icon 4.4 (95)
eBook
eBook
  • eBook eBook $29.99
  • Paperback Paperback $54.99
$29.99 $43.99
$54.99
Artificial Intelligence Engines
Artificial Intelligence Engines
Read more
Nov 2024 217 pages
eBook
eBook
  • eBook eBook $6.98
$6.98 $9.99
AI Product Manager's Handbook
AI Product Manager's Handbook
Read more
Nov 2024 484 pages
Paperback eBook
RAG-Driven Generative AI
RAG-Driven Generative AI
Read more
Sep 2024 334 pages
Full star icon 4.5 (13)
eBook
eBook
  • eBook eBook $24.99
  • Paperback Paperback $43.99
$24.99 $35.99
$43.99
Hands-On Reinforcement Learning with Python
Hands-On Reinforcement Learning with Python
Read more
Jun 2018 318 pages
Full star icon 2.6 (18)
eBook
eBook
  • eBook eBook $20.98
  • Paperback Paperback $38.99
$20.98 $29.99
$38.99
LLM Engineer's Handbook
LLM Engineer's Handbook
Read more
Oct 2024 522 pages
Full star icon 4.8 (13)
eBook
eBook
  • eBook eBook $47.99
  • Paperback Paperback $59.99
$47.99
$59.99
Right arrow icon

Customer reviews

Top Reviews
  • Top Reviews
  • Most Recent
Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.6
(10 Ratings)
5 star 90%
4 star 0%
3 star 0%
2 star 0%
1 star 10%
Filter icon Filter
Top Reviews
  • Top Reviews
  • Most Recent

Filter reviews by

Rakesh May 07, 2017
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I liked this wonderful book. People who want to learn and be expertise in DataGuard should most probably be reading this book and undoubtedly it will be worth the time spent.One of the things that was unique is very well written content with accompanying real time scenarios with "the commands" make this book stand apart from number of other books available in market.I'd definitely recommend
Amazon Verified review Amazon
Wissem Jul 29, 2013
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Introduction:This book is written by my friends Mr. Emre Baransel and Mr. Nassyam Basha. In the following post, I am going to explain why every Oracle DBA should read this book.2- The Book:First chapter of the book explains the Data Guard architecture; what is Standby Database? What`s physical / Logical / Snapshot standby database? Role Transition, Redo apply and SQL Apply? Switchover and fail over? Understand the concepts and the component definitions are a good start to successfully implement an Oracle Data Guard environment.Chapter 2 shows complete steps to implement a physical standby database. This chapter states and explains most of the options available to implement verify and monitor a successful physical standby database. It provides very deeply explanation of Data Guard initialization parameters.Chapter 3 starts mentioning pre-requisites before a logical standby database implementation. This chapter states and explains most of the options available to configure verify and monitor a successful logical standby database.Chapter 4 introduces the Data Guard Borker, it clearly shows its components, benefits and the DGMGRL tool. This chapter shows also Data Guard Borker setup and how it is used to change dataguard configuration and database proprieties. The chapter has a very good section about troubleshooting Data Guard Borker, Tracing and most common broker issues. Authors also explain about the Fast Start Fail over (FSFO) and the Observer.Chapter 5 is about protection modes, good chapter to understand differences between Data Guard modes. This chapter also has some examples to change protection mode using SQL*Plus, the Broker and Oracle Enterprise Manager 12c.Chapter 6 is about Role transitions (Switch Over and Fai Over). Authors have explained different examples using SQL*Plus, Data Guard Broker and Oracle Enterprise Manager 12c.Chapter 7 is about Active Data Guard, Snapshot Standby databases, Cascade standby. The chapter shows how to enable Active Data Guard option using SQL*Plus and Broker. They show ;- Techniques to monitor the Active Data Guard environment.- Integration of Active Data Guard with EBS, SAP and other applications.- The steps to convert to a snapshot standby database and cascade standby.- How to implement the advanced compression option and a cross platform Data Guard.Chapter 8 shows examples to the integration of the Data Guard configuration with;- Oracle Enterprise Manager 12c.- RMAN- RACChapter 9 is about Data Guard patching with many examples about patch application, Logical and physical standby databases. This is also a very good chapter.Chapter 10 and 11 are unique, they cover handling the most common issues in a Data Guard environment and Data Guard best practices using TAF, FCF, FAN and other recommended configurations.3- Conclusion:In my opinion, this book is not only for beginners but also covers many useful and gives many recommendations for more experienced Oracle DBA. This book is a great help for every DBA who manages Oracle Data Guard environment. You can order the book here: Oracle Data Guard 11gR2 Administration Beginner's GuideThanks,Wissem[...]
Amazon Verified review Amazon
Jay M Jul 26, 2013
Full star icon Full star icon Full star icon Full star icon Full star icon 5
The Book is very well written, precis and up to the point. The authors seems to be well versed with OracleData guard technology and experience in the same field oozes out in their writing.The data flow diagrams in the book are well defined and helps in understanding the flow from primary to standby database ( I would have liked to have color patterns in them ).Here are few other suggestions from my point of view.I like oracle data guard evolution from version 7.3 stone age to version 11g modern age described in chapter 1.In chapter 1 LNS ,RFS ACK acronyms meaning should have been described earlier than they are for the reader to understand them at the earliest.Page 19 Apply spelled wrong as AapplyPage 20 wrong use of like operator it should either use % or use = operatoron page 21 it's better to use scope=both or scope=spfile for permanent change or scope=memory or instance only change.The book describes how logical data guard can have different user schemes than production. This is very important aspect for a DBA to replicate the production data for using it for reporting while use logical standby for other ODS purposes and save cost for the company.The book also describes how to skip/unskip tables and whole user schemes. This is important aspect for DBA to customize and manage logical database as well as save space and cpu cycles by avoiding replication of unnecessary staging tables.SQL> alter system set log_archive_dest_2='SERVICE=TEST_STANDBY LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=TEST';on Page 38 Section Time for action - enabling the archive log mode It is better to set log_archive_dest parameter so that archive log are create at a desired location and not default location which will fill up oracle binaries mount point.
Amazon Verified review Amazon
Michael C Seberg Jun 26, 2013
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Rich with real world examples including logical Standby setup. Has a great best practices section and common issues section.The details on how to patch a Data Guard system are excellent and are probably worth the price of the book alone. There are plenty of Advanced Techniques included. Well done![...]
Amazon Verified review Amazon
Talip Hakan Ozturk Jul 19, 2013
Full star icon Full star icon Full star icon Full star icon Full star icon 5
My dear friends Emre Baransel and Nassyam Basha's new book on Oracle Data Guard 11gR2 Administration Beginner's Guide, is released from Packt Publishing.I think, Oracle Data Guard 11gR2 Administration Beginner's Guide is a great book to learn Oracle Data Guard concepts. The book helps you to create, configure, monitor, troubleshooting and patching Oracle Data Guard Standby Databases.The Book provides practical information to help you start using Oracle Data Guard. I think, it's sufficient for beginners.I want to thank to my friends Emre Baransel and Nassyam Basha for spending time to us and giving this great book.Book Contents:Preface Chapter1: Getting Started Chapter2: Configuring the Oracle Data Guard Physical Standby Database Chapter3: Configuring Oracle Data Guard Logical Standby Database Chapter4: Oracle Data Guard Broker Chapter5: Data Guard Protection Modes Chapter6: Data Guard Role Transitions Chapter7: Active Data Guard, Snapshot Standby, and Advanced Techniques Chapter8: Integrating Data Guard with the Complete Oracle Environment Chapter9: Data Guard Configuration Patching Chapter10: Common Data Guard Issues Chapter11: Data Guard Best Practices Pop Quiz AnswersWishing to get the most from the book ...The link to buy this book from Packt Publishing is [...]
Amazon Verified review Amazon

People who bought this also bought

Left arrow icon
Machine Learning Engineering with Python
Machine Learning Engineering with Python
Read more
Aug 2023 462 pages
Full star icon 4.6 (36)
eBook
eBook
  • eBook eBook $27.98
  • Paperback Paperback $49.99
$27.98 $39.99
$49.99
Deep Learning with TensorFlow and Keras – 3rd edition
Deep Learning with TensorFlow and Keras – 3rd edition
Read more
Oct 2022 698 pages
Full star icon 4.6 (45)
eBook
eBook
  • eBook eBook $27.98
  • Paperback Paperback $49.99
$27.98 $39.99
$49.99
Modern Generative AI with ChatGPT and OpenAI Models
Modern Generative AI with ChatGPT and OpenAI Models
Read more
May 2023 286 pages
Full star icon 4.2 (34)
eBook
eBook
  • eBook eBook $27.98
  • Paperback Paperback $49.99
$27.98 $39.99
$49.99
Generative AI with LangChain
Generative AI with LangChain
Read more
Dec 2023 368 pages
Full star icon 4 (34)
eBook
eBook
  • eBook eBook $27.98
  • Paperback Paperback $49.99
$27.98 $39.99
$49.99
Causal Inference and Discovery in Python
Causal Inference and Discovery in Python
Read more
May 2023 456 pages
Full star icon 4.5 (49)
eBook
eBook
  • eBook eBook $21.99
  • Paperback Paperback $27.98
$21.99 $31.99
$27.98 $39.99
Right arrow icon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How do I buy and download an eBook? Chevron down icon Chevron up icon

Where there is an eBook version of a title available, you can buy it from the book details for that title. Add either the standalone eBook or the eBook and print book bundle to your shopping cart. Your eBook will show in your cart as a product on its own. After completing checkout and payment in the normal way, you will receive your receipt on the screen containing a link to a personalised PDF download file. This link will remain active for 30 days. You can download backup copies of the file by logging in to your account at any time.

If you already have Adobe reader installed, then clicking on the link will download and open the PDF file directly. If you don't, then save the PDF file on your machine and download the Reader to view it.

Please Note: Packt eBooks are non-returnable and non-refundable.

Packt eBook and Licensing When you buy an eBook from Packt Publishing, completing your purchase means you accept the terms of our licence agreement. Please read the full text of the agreement. In it we have tried to balance the need for the ebook to be usable for you the reader with our needs to protect the rights of us as Publishers and of our authors. In summary, the agreement says:

  • You may make copies of your eBook for your own use onto any machine
  • You may not pass copies of the eBook on to anyone else
How can I make a purchase on your website? Chevron down icon Chevron up icon

If you want to purchase a video course, eBook or Bundle (Print+eBook) please follow below steps:

  1. Register on our website using your email address and the password.
  2. Search for the title by name or ISBN using the search option.
  3. Select the title you want to purchase.
  4. Choose the format you wish to purchase the title in; if you order the Print Book, you get a free eBook copy of the same title. 
  5. Proceed with the checkout process (payment to be made using Credit Card, Debit Cart, or PayPal)
Where can I access support around an eBook? Chevron down icon Chevron up icon
  • If you experience a problem with using or installing Adobe Reader, the contact Adobe directly.
  • To view the errata for the book, see www.packtpub.com/support and view the pages for the title you have.
  • To view your account details or to download a new copy of the book go to www.packtpub.com/account
  • To contact us directly if a problem is not resolved, use www.packtpub.com/contact-us
What eBook formats do Packt support? Chevron down icon Chevron up icon

Our eBooks are currently available in a variety of formats such as PDF and ePubs. In the future, this may well change with trends and development in technology, but please note that our PDFs are not Adobe eBook Reader format, which has greater restrictions on security.

You will need to use Adobe Reader v9 or later in order to read Packt's PDF eBooks.

What are the benefits of eBooks? Chevron down icon Chevron up icon
  • You can get the information you need immediately
  • You can easily take them with you on a laptop
  • You can download them an unlimited number of times
  • You can print them out
  • They are copy-paste enabled
  • They are searchable
  • There is no password protection
  • They are lower price than print
  • They save resources and space
What is an eBook? Chevron down icon Chevron up icon

Packt eBooks are a complete electronic version of the print edition, available in PDF and ePub formats. Every piece of content down to the page numbering is the same. Because we save the costs of printing and shipping the book to you, we are able to offer eBooks at a lower cost than print editions.

When you have purchased an eBook, simply login to your account and click on the link in Your Download Area. We recommend you saving the file to your hard drive before opening it.

For optimal viewing of our eBooks, we recommend you download and install the free Adobe Reader version 9.