ISBN 0-9745993-8-7 ISBN 13 978-0974599380 Library of Congress Number: 2004096472 360 pages: Perfect bind - 9x7 Publication Date: December 2004 Shelving: Database/Oracle Oracle In-Focus: Series # 19

Oracle Data Guard Standby Database Failover Handbook Bipul Kumar          Retail Price $27.95 /  £19.95  Order now and get immediate online access to the code depot! Only $19.95 (30% off)         Key Features   About the Author Reader Comments Table of Contents   Errata           Get the Oracle Tuning Pack Six for $79.95 - A $150.00 value Oracle Performance Troubleshooting $27.95 Oracle Replication $27.95 Oracle Wait Event Tuning $27.95 Oracle Disk I/O Tuning $27.95 Oracle 10g DBA Reference Poster $8.95 Oracle Silver Bullets $27.95

This small book is an indispensable guide for using Oracle for a disaster recovery strategy. Covering all areas of disaster recovery, standby database and automatic Oracle failover, this book explains the use of Oracle10g Data Guard solution provides a comprehensive Solution for disaster recovery. This book covers all aspects of Oracle Data Guard in detail and provides an overview of the latest Data Guard features in Oracle10g. Written by a working Oracle DBA, this text covers the concepts and the architecture of standby databases and provides a detailed description of the implementation and management of data guard. Expert tips are revealed for success in configuration and first-time implementation of Data Guard. Advance topics such as "Using RMAN to create Data Guard Configuration" and "Data Guard Broker" have been discussed in detail to assist production DBAs managing multiple databases.

* Learn secrets for Data Guard implementation standby and failover * Understand the Oracle10g Data Guard architecture * Ensure success with a first-time failover database implementation * See how to use Recovery Manager with Data Guard * Learn the expert troubleshooting Tips and Techniques * Get working scripts to perform Data Guard administration and monitoring

About the Author:

 

Bipul Kumar		Bipul Kumar is a Senior Application Engineer for a Telecommunications company in St. Albans Hertfordshire, United Kingdom. His responsibilities include Oracle Database administration, Performance tuning, Recovery, and application development. He has more than six years of experience in creating and managing Oracle Databases of varying sizes, primarily on UNIX operating systems. Mr. Kumar has a Masters degree in Science from the Indian Institute of Technology (IIT), Kharagpur, India and nearly nine years of experience in computing.  In addition, he has acquired Oracle DBA certification for 7.3, 8.0, and 8i.

Table of Contents:

 

1 - Introduction     Standby Database Concepts   History of Standby Database      Chronological Development of Standby Technology   Types of Standby Databases      Physical Standby Database      Logical Standby Database      Archive log repository   Benefits and Drawbacks      Disaster Protection      Load Balancing      Automated Management      Not a cheap option   Operational Constraints   Lifecycle of Standby Database   A Sample Configuration   Summary   02 - Data Guard Architecture     Architectural Components      Process Architecture      Redo Log File      Archived Redo Log File   Data Guard Apply Modes      Redo Apply Mode      SQL Apply Mode         Log Miner Technology   Archive Gap Sequence      Detection And Resolution   Data Guard Broker Architecture      Configuration, Sites And Resources      Server Side Components Of The Broker      Client Side Components Of The Broker   Role of Transport Network Substrate   Summary   03 - Implementing Standby Databases     Physical Standby Database      Manual Recovery Physical Standby Database      Managed Recovery Physical Standby Database      Read-Only Physical Standby Database   Creating Physical Standby Database      On A Remote Host Machine         Preparing To Create Physical Standby Database         Backup Primary Database         Modifying Initialization Parameter file         Oracle Net Configuration         Starting Standby Database         Verify Physical Standby Database      On A Local Host Machine         Modifying Initialization Parameters         Oracle Net Configuration         Starting Standby Database      Accommodating Difference In Directory Structure Between Primary And Standby Site   Creating Logical Standby Database      Limitations of Logical Standby Database      Requirements for Logical Standby Database      Creating A Logical Standby database         Backup Primary Database         Building LogMiner Dictionary         Oracle Net Configuration         Modifying Initialisation Parameter File         Changes on Logical Standby Site Sample Configuration Summary   04 - Standby Database Administration     Administration Of Physical Standby Database      General Administration Tasks         Controlling Managed Recovery Process         Opening Standby Database in Read-only mode         Manually Recovery of Standby Database         Shutting Down Standby Database      Monitor Physical Standby Database         Tools For Monitoring Standby Database         Recovery Progress On Standby Site      Propagating Unrecoverable Operations To Standby Database         Changes In The Tablespaces Or Datafiles         Reset Online Redo Logs On Primary Database         Datafile Name Changes On Primary Database         Changing Initialization Parameter On Primary Standby Database      Physical Standby Database With Time Lag      Resolving Archive Gap Sequence On Physical Standby Database   Administration Of Logical Standby Database      Starting Up And Shutting Down A Logical Standby Database      Starting and Stopping Log Apply Service      Monitoring Logical Standby Database         Tools to monitor logical standby site         Monitoring Overall Progress Of SQL Apply Operation         Monitoring Log Apply Services      Managing Schema Objects         Managing Tables In Logical Standby Database      Logical Standby Database With Time Lag      Resolving Archive Gap Sequence On Logical Standby Database   Cascaded Standby Database      Using Physical Standby Database For Cascaded Standby Database      Using Logical Standby Database For Cascaded Standby Database   Summary

05 - Log Management Services     Log Transport Services   Log Apply Services      Physical Standby Database      Logical Standby Database   Log Management Policies      Factors Influencing Log Transport Policies      A Sample Log Management Policy   Standby Redo Logs   Log Transport Service Transmission Attributes      Process To Transfer Redo Data      Network Characteristics Influencing Redo Transmission      Acknowledging Redo Disk I/O Operation On Standby Database   Standby Database Protection Modes      Protection Modes In Oracle9i Release 1         Guaranteed Protection Mode         Instant Protection Mode         Rapid Protection Mode         Delayed Protection Mode      Protection Modes In Oracle9i Release 2         Maximum Protection         Maximum Availability         Maximum Performance   Summary     06 - Switchover And Failover     Types Of Database Role Transitions      Role Transition Using Switchover      Role Transition Using Failover         Graceful Failover         Forced Failover   Determining A Suitable Standby Database For Role Transition   Disadvantages Of Transitioning To Logical Standby Database   Switchover Operation      Preparing Primary Database For Switchover      Preparing Standby Database For Switchover         Physical Standby Database         Logical Standby Database      Switchover To A Physical Standby Database      Switchover To A Logical Standby Database      Verify Switchover Operation   Failover Operation      Failover To A Physical Standby Database      Failover To A Logical Standby Database      Verify Failover Operation      Impact On Other Standby Database In Configuration   Transparent Application Failover   Summary       07 - Management Using Data Guard Broker   Creating Data Guard Configuration Managing Data Guard Configuration Managing Site Managing Database Resources Switchover & Failover using DG Broker Gathering Statistic using BG Broker Summary     08 - Performance Tuning Of Data Guard Configuration     Understanding Tuning Requirements   Monitoring Data Guard Performance   Tuning Log Transfer Service      Determining Optimal Network Bandwidth      Gathering Oracle Net Related Statistics      Network Tuning for Log Transport Service      I/O Activity on the Standby Host   Tuning Log Apply Services      Understanding Memory Usage during Log Apply         Tuning Memory Usage      Wait Events Specific to Standby Database      Tuning SQL Apply Operation   Configuring Standby Database for high performance   Summary       09 - Oracle10g Data Guard New Feature       10 - Using RMAN for Standby Database   _______________________________________________   Appendix A - Troubleshooting   Appendix B - Data Guard Reference

Errata

The Index in this book is incorrect. The corrected Index can be found in the Code Depot.

Index Entries: