ISBN
0-9745993-5-2
ISBN 13
978-0974599359 |
Library of Congress
Number: 2004096471 |
304 pages:
Perfect bind - 9x7 |
PD 1204 |
Shelving:
Database/Oracle |
Oracle In-Focus Series
#20 |
|
|
Oracle Streams
High Speed Replication and Data Sharing
Madhu Tumma
Retail Price $27.95
/ ฃ20.95
Order now and
get immediate online access to the
code depot! |
Only $19.95
(30% off) |
 |
Get the Oracle
Replication Half-Pack
Three for $49.95 - An $83.00 value |
 |
|
|
Oracle Streams is a high-speed tool that allows synchronization of
replicated databases across the globe and an indispensable feature
for any company using Oracle for global eCommerce. A noted and
respected Oracle author, Madhu Tumma shares his secrets for
achieving high-speed replication and data sharing. Using proven
techniques from mission-critical application, Tumma show the
front-line secrets for ensuring success with Oracle Streams. From
installation through implementation, Tumma provides step-by-step
instruction to ensure your success with these powerful Oracle
features.
Tumma walks you safely through the myriad of complex Oracle
Streams tasks including the set-up of the staging area queue,
propagation through data hubs, customized apply functions,
rule-based data propagation, Oracle Streams transformation, and
lots, lots more. Best of all, Tumma shares working code examples
to allow you to easily manage even the most complex Oracle Streams
implementation.
|
|
* Learn expert secrets for high
speed data replication
* Understand the successful installation and configuration
techniques
* Use Oracle Streams to create a reliable failover database
* Achieve global data sharing and seamless data replication
* Learn the tricks to easily manage subscribed destinations
* Get working scripts to improve streams management
* Learn to customize data apply functions
* Understands tricks for rule-based propagation and data
transformations |
About the Author:

Madhu
Tumma |
|
Madhu Tumma has been working as Software
Developer, IT
Manager, Database Administrator, and Technical
Consultant for about 18 years. He has worked on a wide
variety of projects and environments ranging from
mainframe, client-server, eBusiness to managed
services.
He has provided consultancy to variety of
clients on database clusters, business continuity and
high availability solutions. His experience ranges
across multiple relational database systems. Madhu is
frequent speaker at Oracle World and IOUG where he
presented many technical papers. Madhu has Master
Degree in science and attended Business Management
graduate program. He lives in New Jersey with his wife Hema and two children Sandi and Sudeep. |
|
Table of Contents:
I INTRODUCTION
Data Sharing
Growing Need
Global Operations
Heterogeneous Systems
Data Synchronization
Data Movement
Data Transformation
Data Migration
Data Replication
What is Oracle Streams?
Why Oracle Streams?
Where to use Streams Mechanism
Replication
AQ Advanced Queuing
Event Management
Data Loading
Summarization of Data
High Availability and Disaster Recovery
Streams Historical Growth
Advanced Replication
Advanced Queuing
Related Oracle Technologies
Log Miner
Standby Data Guard
Peer Products
Sybase Replication
Quest Shareplex
GoldenGate
Data Mirror
II Streams Components and Processes
Producer and Consumer
LCR Object
Row LCR
DDL LCR
Additional Attributes
Hot Mining and Cold Mining
Log based Changes
Capture Process
Propagation of Changes
Apply Process
Queuing and Dequeuing
Rules and Rules Engine
Application of Rules
Transformation
Contexts
Streams Tags
Directed Network
DownStreams Capture
Change Data Capture
LogMiner
Supplemental Logging
Sys.Anydata Object
DML Handlers
III Streams Replication
Source
Database Changes
User Application Message
Destination Database
Data Types for Replication
Rules
Rule Set
Capture Rules
Propagation Rules
Apply Rules
Contexts
Transformations
Instantiation
Capture process for Instantiation
Oracle Data Pump for Instantiation
Export and Import for Instantiation
The Role of Streams Tags
How to create
Utility of Tags
Tags for Apply Process
Methodology
Examples
|
IV Capture and
Propagation Configuration
Capture Mechanism
Data Types
DML Changes and Considerations (I, U, U, D and M)
Types of DDL(s)
NoLogging and Unrecoverable
Supplemental Logging
Instantiation
Local v/s DownStream
The Role of SCN
In Restricted Session
Capture Process
Components
Capture States
Multiple Processes
Rule Evaluation
Parallelism
Propagation and Staging
Schedules
Configuration
Monitoring
Application of Rules
Rule Set
Capture Rules
Propagation Rules
V Apply Configuration
Apply Process
DML Handlers
Application of Rules
Rule Set
Apply Rules
Contexts
Transformations
Methodology
Examples
VI Troubleshooting and Monitoring
Conflict Detection
Conflict Resolution
Monitoring Streams Data Flow
Helpful Scenarios
VII Heterogeneous Data Replication
Heterogeneous Data
Sharing
Oracle to Non-Oracle
Capture process
Instantiation
Data Types
Apply process
Heterogeneous Services
Database link
Non-Oracle to Oracle
User Application
VIII Event Management - Messaging
Event Propagation
Advanced Queuing
IX Data Loading Data Warehousing
Data Loading
CDC Change Data Capture
X Downstream Capture
Log Transportation
Services
DBMS_FILE_TRANSFER
XI RAC and Streams
Multiple Instances
Multiple Buffers
XII Using OEM
Oracle Enterprise
Manager
Grid Control
Appendix
a) Oracle Supplied
Packages
b) Data Dictionary Views |
|
Index Topics:
add_column
add_global_propagation
add_global_propagation_rules
add_global_rules
add_message_rule
add_schema_propagation_rules
add_schema_rules
add_subset_propagation_rules
add_subset_rules
add_table_propagation_rules
add_table_rules
Advanced Queuing
ALL column logging
all_apply_progress
alter_apply
alter_capture
alter_propagation
alter_queue_table
ALWAYS log group
ANALYZE
ANALYZE SQL
and_condition
applied_message_create_time
applied_message_number
applied_scn
Apply
Apply handlers
Apply process
Apply Process
Apply Servers
apply_captured
apply_database_link
apply_name
apply_tag
apply_time
apply_user
asynchronous replication
atter
Automatic Storage Management
B
base_table_name
base_table_owner
BINARY_DOUBLE
BINARY_FLOAT
buffered queues
Builder server
C
Capture
Capture process
capture_message_create_time
captured_scn
CAPTURING CHANGES
cascade
Change Data Capture
cold mining
column list
column_name
command_type
COMMIT
commit_serialization
COMPARE_OLD_ON_DELETE
COMPARE_OLD_ON_UPDATE
compatible
Conditional Supplemental Log Groups
conflict handler
content based routing
convertdata_type
Coordinator Process
create_apply
create_capture
create_evaluation_context
create_propagation
create_rule
create_rule_set
CREATING LCR
current_schema
current_scn
Custom Apply
D
Data Definition Language
Data Guard
Data Manipulation Language
Data Movement
Data Pump
Data Replication
Data Transformation
Data Warehousing Systems
db_txn_scn
dba_apply
dba_apply_conflict_columns
dba_apply_dml_handlers
dba_apply_enqueue
dba_apply_error
dba_apply_execute
dba_apply_instantiated_objects
dba_apply_key_columns
dba_apply_parameters
dba_apply_progress
dba_apply_table_columns
dba_capture
dba_capture_extra_attributes
dba_capture_parameters
dba_capture_prepared_database
dba_capture_prepared_schemas
dba_capture_prepared_tables
dba_captures_parameters
dba_db_links
dba_evaluation_context_tables
dba_evaluation_context_vars
dba_evaluation_contexts
dba_log_group_columns
dba_log_groups
dba_propagation
dba_queue_schedules
dba_queue_tables
dba_queues
dba_registered_archived_log
dba_rule_set_rules
dba_rule_sets
dba_rules
dba_streams_global_rules
dba_streams_message_consumer
dba_streams_message_rules
dba_streams_newly_supported
dba_streams_rules
dba_streams_schema_rules
dba_streams_table_rules
dba_streams_transform_function
dba_streams_unsupported
dba_type_attrs
dba_type_methods
dba_types
DBArtisan
dbms_apply_adm
dbms_aqadm
dbms_capture
dbms_capture_adm
dbms_file_transfer
dbms_ftp_transfer
dbms_job
dbms_propagation_adm
dbms_redefinition
dbms_rule_adm
dbms_streams
dbms_streams_adm
dbms_streams_auth
dbms_streams_messaging
dbms_streams_messaging_enqueue
dbms_streams_tablespace_adm
DDL See Data Definition Language
DDL handler
DDL Handler
ddl_handler
ddl_rule_name
ddl_text
DELETE
Delete Conflict
delete_all_errors
delete_error
Delivery
destination_queue_name
DICTIONARY INITIALIZATION
dictionary_scn
disable_on_error
disable_on_limit
disable_propagation_schedule
Disaster Recovery
DISCARD
dmbs_aq
DML See Data Manipulation Language
DML Handler
DML handlers
dml_condition
dml_rule_name
Down Stream databases
Down Streams capture
drop_apply
drop_capture
drop_propagation
drop_unused_rule_sets
dual
Dynamic views
|
E
elapsed_apply_time
elapsed_capture_time
elapsed_dequeue_time
elapsed_enqueue_time
elapsed_lcr_time
elapsed_redo_wait_time
elapsed_rule_time
emsg_array
enable_propagation_schedule
enqueue_message_create_time
enqueue_time
ENQUEUING MESSAGE
error handler
error_handler
ERROR_HANDLER
EVALUATING RULE
evaluation_function
event enqueuing latency
Event propagation
execute_all_errors
execute_as_user
execute_error
expdp
Explicit Log Assignment
Extract Transform and Load
F
first_scn
flashback_scn
force
Foreign Key Conflict
FOREIGN KEY logging
G
gateways
get_base_table_owner
get_error_message
get_object_owner
get_scn_mapping
get_streams_name
get_streams_type
get_system_change_number
get_tag
Global rule
global_names
GoldenGate
grant_admin_privilege
gv$_buffered_queues
H
hist_upd
Hot Mining
hwm_message_create_time
hwm_message_number
I
Identification Key Logging
impdp
Implicit Log Assignment
include_ddl
include_dml
include_extra_attribute
include_tagged_lcr
inclusion_rule
Index Organized Tables
Informatica
init.ora
INITIALIZING
inittrans
INSERT
instantiation_scn
Interested Transaction List
J
job_queue_processes
L
LCR See Logical Change Record
lcr$_row_record
lcr_print_error
lcr_print_errors_all
lcr_print_values
LGWR
load_ny_allinsured.sql
LOADING
local_transaction_id
LOG DATA
LOG GROUP
log writer
log_archive_dest_
log_archive_dest_state_
log_archive_format
logfile_assignment
Logical Change Record
LogMiner
LogMiner Data Dictionary
logminer_session_name
logon_user
LONG
LONG RAW
Loose Consistency
M
Manager
max_checkpoint_scn
MAXIMUM
maximum_scn
MERGE
Message Handler
Message Systems
message_handler
message_limit
message_number
Messaging client
method_name
Minimal Logging
MINIMUM
MINING
msg_handler
multi-consumer queues
Multi-Way replication
N
NCLOB
negative_rule_set_name
new_values
nologging
O
Object Instantiation
object_name
object_owner
object_type
old_values
One-Way Replication
open_link
operation_name
OPERATION_NAME
Oracle Transparent Gateway
OVERWRITE
P
parallelism
PAUSED FOR FLOW CONTROL
pre-commit handler
pre-commit handlers
precommit_handler
prepare_global_instantiation
prepare_schema_instantiation
prepare_table_instantiation
Preparer server
PRIMARY KEY logging
primary_instance
producer and consumer
Propagation
Propagation process
publish and subscribe methodology
Q
queue table
R
re$variable_type
Read Consistency Model
Reader Server
Real Application Cluster
redo log scanning latency
remote_archive_enable
remove_apply_tag
remove_ddl_handler
remove_message_handler
remove_negative_rule_set
remove_precommit_handler
remove_queue
remove_rule_set
remove_streams_configuration
required_checkpoint_scn
REQUIRED_CHECKPOINT_ SCN
resolution columns
resolution_column
RMAN
ROLLBACK
row LCR
row_id
Rule Action Context
Rule Condition
Rule Evaluation Context
Rule sets
rule_condition
RULE_CONDITION
rule_set_name
RULE_SET_NAME
|
rule-based
transformations
Rules Engine
S
Scalability
Schema rule
schema_name
SCHEMA_NAME
scn
secondary_instance
Secure queues
serial#
server_id
session#
session_privs
set_dml_handler
set_enqueue_destination
set_execute
set_global_instantiation_scn
set_key_columns
set_parameter
set_rule_transform_function
set_schema_instantiation_scn
set_table_instantiation_scn
set_tag
set_up_queue
set_update_conflict_handler
Shared Pool
shared_pool_size
SharePlex
show_capture_details.sql
SHUTTING DOWN
Snapshot based replication
source_database
source_database_name
SQL*Loader
standby_archive_dest
start_apply
start_capture
start_scn
startup_seconds
startup_time
Static views
steams_name
stop_apply
stop_capture
storage_clause
Streams AQ
Streams Clients
Streams pool
Streams Tags
streams_instantiation
streams_pool_size
streams_type
Subset rules
supplemental log group
Supplemental Logging
SYS.AnyData
sys.streams$_evaluation_context
System Change Number
System Global Area
T
Table rule
tag
thread#
Tight Consistency
time_limit
timed_statistics
total_admin
total_applied
total_assigned
total_full_evaluations
total_messages_applied
total_prefilter_discarded
total_prefilter_kept
total_received
trace_level
transaction_id
transaction_limit
transactional queues
transformation handlers
transformations
transport_tablespace
Two-Phase Commit
Two-Way Replication
tx_name
U
Unconditional Supplemental Log Groups
UNIQUE index
Uniqueness Conflict
unrecoverable
UPDATE
Update Conflict
use_database_link
user_procedure
USER_PROCEDURE
user-enqueued events
username
V
v$archived_log
v$buffered_publishers
v$buffered_queues
v$buffered_subscribers
v$capture_process
v$database
v$dblink
v$log
v$logmnr_contents
v$logmnr_dictionary
v$logmnr_logs
v$propagation_receiver
v$propagation_sender
v$queue
v$rule
v$rule_set
v$rule_set_aggregate_stats
v$session
v$streams_apply_coordinator
v$streams_apply_reader
v$streams_apply_server
v$streams_capture
W
WAITING FOR DICTIONARY REDO
WAITING FOR REDO
write_alert_log |
Reviews:
Click
here to read the review of Oracle Streams by Lewis
Cunningham.
Errata:
|