ISBN 0-9745993-8-7 ISBN 13 978-0974599380 Library of Congress Number: 2004096472 360 pages: Perfect bind - 9x7 PD 1204 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 Table of Contents Index Reader Comments Errata       Get the Oracle Replication Half-Pack Three for $49.95 - An $83.00 value Oracle Data Guard $27.95 Oracle Streams $27.95 Oracle Replication $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:

Chapter 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   Chapter 2 - 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   Chapter 3 - 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   Chapter 4 - 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

Chapter 5 - 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   Chapter 6 - 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   Chapter 7 - 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     Chapter 8 - 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     Chapter 9 - Oracle10g Data Guard New Feature     Chapter 10 - Using RMAN for Standby Database   _______________________________________________   Appendix A - Troubleshooting   Appendix B - Data Guard Reference

Index Topics:

Reviews:

Errata:

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