Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 

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.

 
Key Features

* 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:

A
ALTER DATABASE CLEAR UNARCHIVED LOGFILE
ALTER SYSTEM
applied_scn
apply_unset
arch_log.sql
arch_log_name.sql
Archive Gap Sequence
archive process (ARCH)
archived redo log file
ARCHIVED_SEQ#
ARCHIVELOG mode
ASYNC
AUTOMATIC CHANNEL ALLOCATION
B
BACKGROUP_DUMP_DEST
BACKUP mode
BACKUP VALIDATE
Bad_Column
BLOB
C
CLOB
Command Line Interface (DGMGRL)
completion_time
Configuration Layer
CONFIGURE AUXNAME
control_files
CREATE SITE
D
Data Guard Broker
Data Guard Log Apply Services
Data Guard Monitor (DMON)
Database Object Layer
database_role
db_file_name_convert
db_name
db_nfile_name_convert
db_protection.sql
db_unique_name
dba_data_files
dba_indexes
dba_logstdby_events
dba_logstdby_log
dba_logstdby_not_unique
dba_logstdby_progress
dba_logstdby_skip
dba_logstdby_unsupported
dba_tablespace view
dba_tablespaces
dbms_logmnr
dbms_logmnr_d.build
dbms_logstdby.build
dbms_logstdby.unskip
Delayed Protection
dg_broken_config_file=’filespec’
dg_broker_config_file=’filespec’
dg_broker_config_file=’filespec’
dg_broker_start
dg_stats.sql
DGMGRL
DICTIONARY_BEGIN
DISABLE CONFIGURATION
DISCONNECT FROM SESSION
DMON process
DORECOVER
E
eager_size
ENABLE CONFIGURATION
F
failover operation
failover_mode
fal_client
fal_server
Fetch Archive Log (FAL)
Find_Archive_Time.sql
find_gap.sql
Flashback database
FORCE LOGGING
FORCE_LOGGING
forced failover
G
graceful failover
Guaranteed Protection
 I
init.ora
instance_name
Instant Protection
instantiate_table
INSTANTIATE_TABLE
iostat
L
listener.ora
lock_name_space
Log Apply Process
Log Apply Service
Log Transport Process
Log Transport Service
Log Writer (LGWR)
log_archive_config
log_archive_dest
log_archive_dest_
log_archive_dest_
log_archive_dest_
log_archive_dest_
log_archive_dest_n
log_archive_dest_state
log_archive_format
log_archive_local_first
log_archive_trace
log_dest_attr.sql
log_file_name_convert
log_parallelism
log_progress.sql
LOG-APPLY-OFF
log-file_name_convert
Logical Standby Process (LSP)
LogMiner
logstdby_stats.sql
M
Managed Recovery Process (MRP)
managed_stdby.sql
MANDATORY
MANUAL CHANNEL ALLOCATION
manual recovery mode
max_failure
MAX_FAILURE
MAXIMUM AVAILABILITY
MAXIMUM PERFORMANCE
MAXIMUM PROTECTION
maxlogfiles
maxlogmembers
MngStandby.sql
N
Network_BW.sql
newest_scn
nid utility
NOFILENAMECHECK
NOPARALLEL
NOREOPEN
not_unique.sql
O
OPTIONAL
ORA-
Oracle Data Guard Broker
Oracle Parallel Server
Oracle Streams
oracle_sid
orapwd
P
PARALLEL
protection_level
 
R
Rapid Protection
Real Application Cluster
RECOVER DATABASE
RECOVER MANAGED STANDBY DATABASE
Recovery MANager (RMAN)
Redo Apply mode
Redo Log file
redo_log_type
reg_log.sql
Remote File Server (RFS) Process
remote_archive_enable
remote_login_passwordfile
REMOVE CONFIGURATION
REOPEN
REPORTS
RESETLOGS
rman_backup
rman_image
S
Session Data Unit
SET NEWNAME
shared_pool_size
SHOW CONFIGURATION
SHOW SITE
sort_area_size
spfile
SPFILE
sp-name
SQL apply mode
sql_apply_progress.sql
sqlnet.ora
standby_archive_dest
STANDBY_ARCHIVE_DEST
standby_file_management
STATSPACK
stdby_log.sql
switchover operation
SYNC
T
tnsnames.ora
transaction_consistency
U
unsup_objects.sql
V
v$archive_dest
v$archive_dest_status
v$archive_gap
v$archive_log
v$archived_log
v$archived_standby
v$database
v$datafile
v$datafile view
v$dataguard_status
v$instance
v$log
v$logfile
v$logfiles
v$logmnr_contents
v$logstandby
v$logstdby
v$managed_standby
v$recover_file
v$session
v$system_event
v$thread
VALID_FOR
VERBOSE

Reviews:

 

Errata:

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



 

 

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks