Oracle Streams 11g Data Replication

Name: Oracle Streams 11g Data Replication
Brand: McGraw-Hill Education
Price: 93.79 EUR
Availability: OnlineOnly

Kirtikumar Deshpande(Autor*in)

McGraw-Hill Education (Verlag)

1. Auflage

Erschienen am 1. Dezember 2010

599 Seiten

E-Book

ePUB mit Adobe-DRM

Systemvoraussetzungen

978-0-07-175912-0 (ISBN)

93,79 €inkl. 7% MwSt.

Systemvoraussetzungen

für ePUB mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Inhalt

Cover Page
Oracle Streams 11g Data Replication
Copyright Page
Dedication
Contents
Acknowledgments
Introduction
Part I Introduction to Oracle Streams
1 What Is Oracle Streams
Information Flow in Oracle Streams
Architectural Overview of Oracle Streams
Capture
Staging and Propagation
Consumption
Queues
Streams Tag
Rules and Rule Sets
Instantiation
LogMiner Data Dictionary
Streams Data Dictionary
NOLOGGING and UNRECOVERABLE Operations
Supplemental Logging
Logical Change Records
Table Data Comparison
Summary
2 Using Oracle Streams
Data Replication
Unidirectional (One-Way) Replication
Bidirectional Replication
N-Way (Peer-to-Peer) Replication
Hub-and-Spoke Replication
Replication with Non-Oracle Databases
Data Warehouse Loading
Data Auditing
Data Protection
Message Queuing
Minimizing Downtime During Database Upgrades
Minimizing Downtime During Maintenance Tasks
Summary
Part II Oracle Streams Concepts and Architecture
3 Streams Rules and Rule Sets
Rules
Evaluation Context
Rule Condition
Action Context
Rule Sets
Positive Rule Set
Negative Rule Set
Creating Rules and Rule Sets
System-Created Rules and Rule Sets
User-Created Rules and Rule Sets
Rule Condition for Discarding Unsupported LCRs
Procedures to Manage Rules and Rule Sets
Summary
4 Capture Process
Capture Process Types
Local Capture Process
Downstream Capture Process
Capture Process Checkpoints and System Change Numbers
Required Checkpoint SCN
Maximum Checkpoint SCN
First SCN
Start SCN
Captured SCN
Last Enqueued SCN
Applied SCN
Source Reset Logs SCN
Checkpoint Retention Time
Creating the Capture Process
Create the Local Capture Process
Create the Downstream Capture Process
Create the Synchronous Capture Process
The Capture User
Capture Process Components
Capture Process Parameters
Changing Capture Process Parameters
What Changes Are Not Captured?
Changes Not Captured by the Capture Process
Changes Not Captured by the Synchronous Capture Process
How to Check for Unsupported Objects
NOLOGGING Operations
Supplemental Logging
What Needs Supplemental Logging
Types of Supplemental Logging
System-Created Supplemental Log Groups
Summary
5 Staging and Propagation Process
Queue Models
Queue Types
Typed Queue of ANYDATA Type
Buffered Queue
Persistent Queue
Secure Queue
Transactional Queue
Nontransactional Queue
Commit-Time Queue
How Streams Clients Use Queues1
Creating a Streams Queue
Queues and Real Application Clusters
Propagation
Queue-to-Database Link Propagation
Queue-to-Queue Propagation
Directed Networks
Creating the Propagation Process
Propagation Rule Set and Rules
Propagation Job and Schedule
Combined Capture and Apply
Summary
6 Apply Process
Overview of the Apply Process
Apply Process States
Apply Process Components
Reader Server
Coordinator Process
Server Process
Apply User
Creating the Apply Process
Automatic Apply Process Creation
Manual Apply Process Creation
Apply Process Parameters
Handling Triggers
Handling Column Discrepancies
Data Type Mismatch
Fewer Columns at Destination
More Columns at Destination
Column Name Mismatch
No Primary Key or Unique Key
Handling Transaction Dependencies
Object Dependency
Value Dependency
Message Processing by the Apply Process
DML Handler
DDL Handle
Error Handler
Precommit Handler
What Changes Are Not Applied?
Summary
7 Logical Change Records
Row LCRs
DDL LCRs
Extra Attributes in LCRs
Accessing LCR Contents
Accessing Row LCR Contents
Accessing DDL LCR Contents
Modifying LCR Content
Modifying Row LCR Contents
Modifying DDL LCR Contents
LCRs and LOB Data Types
Summary
Part III Oracle Streams Configuration
8 Configuring Oracle Streams for Data Replication
Streams Configuration Methods
Prerequisite Tasks
Prepare the Databases
Create Network Connectivity Between Databases
Create the Streams Administrator Accoun
Create Database Links
Create Directory Objects
Streams Configuration Using MAINTAIN Procedures
Streams Replication at the Database Level
Streams Replication at the Schema Level
Streams Replication at the Table Level
Streams Replication at the Tablespace Level
Configuring the Downstream Capture Process Using MAINTAIN Procedures
Monitoring the Progress of MAINTAIN Procedures
Recovering from an Error in MAINTAIN Procedures
Advantages of MAINTAIN Procedures
Limitations of MAINTAIN Procedures
Streams Configuration Using Custom Scripts
Unidirectional Replication with the Local Capture Process
Unidirectional Replication with the Downstream Capture Process
Bidirectional Replication
Replication from a Single Source to Multiple Destinations
Replication Using Queue Forwarding
Replication Using Apply Forwarding
Replication Using the Synchronous Capture Process
Hub-and-Spoke Replication
N-Way Replication (Multimaster)
Summary
9 Data Transformations
Types of Rule-Based Transformations
Declarative Rule-Based Transformations
Custom Rule-Based Transformations
Where to Use Rule-Based Transformations
Finding the Rule Name
Configuring Declarative Rule-Based Transformations
Add Column Procedure
Delete Column Procedure
Keep Columns Procedure
Rename Column Procedure
Rename Schema Procedure
Rename Table Procedure
Rule-Based Transformations and DDL Replication
Configuring Custom Rule-Based Transformations
Custom Rule-Based Transformation for DDL LCRs
Custom Rule-Based Transformation for Row LCRs
Removing Rule-Based Transformations
Removing Declarative Rule-Based Transformations
Removing Custom Rule-Based Transformations
Table Subset Rule Transformations
Transformation Execution Order
Summary
10 Handling Data Conflicts
Type of Conflicts
Delete Conflicts
Update Conflicts
Uniqueness Conflicts
Foreign Key Conflicts
How to Avoid Conflicts
Avoiding Uniqueness Conflicts
Avoiding Delete Conflicts
Avoiding Update Conflicts
Resolving Conflicts
Using the Prebuilt Update Conflict Handler
Using Column Lists
Using Resolution Column
Setting Up the Prebuilt Update Conflict Handler
Listing Defined Update Conflict Handlers
Modifying Update Conflict Handler
Removing Update Conflict Handlers
Stopping Conflict Detection for Non-Key Columns
Custom Conflict Handlers
Summary
Part IV Oracle Streams Management
11 Managing and Monitoring Streams Replication
Managing Streams Processes
Managing the Capture Process
Managing the Synchronous Capture Process
Managing the Propagation Process
Managing the Apply Process
Monitoring Streams Processes
Monitoring the Capture Process
Monitoring the Propagation Process and Queues
Monitoring the Apply Process
Monitoring Transactions
Monitoring the Alert Log File
Split and Merge: Managing and Monitoring
Automatic Split and Merge
Manual Split and Merge
Streams Performance Advisor
Summary
12 Maintenance and Troubleshooting
Expanding the Streams Environment
Adding Objects to the Exiting Streams Environment
Adding a Database to the Existing Streams Environment
Removing Streams Configuration
Removing Entire Streams Configuration
Removing Specific Streams Configuration
Troubleshooting Streams Processes
Capture Process Troubleshooting
Propagation Process Troubleshooting
Apply Process Troubleshooting
Streams Message Tracking
Streams Health Check Report
Data Comparison and Convergence
Creating the Comparison
Running the Comparison
Listing the Comparison
Converging from the Local Table to the RemoteTable
Rechecking the Comparison
Purging the Comparison
Dropping the Comparison
Summary
13 Streams Performance Considerations
Streams Queue Spilling
Apply Spilling
Handling Large Transactions
Streams Tag
Procedural Replication
Handling Long-Running Transactions
Log Mining Activity
Capture Process Considerations
Parallelism
Checkpoint Information
Propagation Process Considerations
Apply Process Considerations
Tuning Apply Process Parameters
Handling LOB Data Types
Apply Rule Set
Detecting Conflicts
Bug Fixes
Summary
14 Oracle Enterprise Manager Grid Control for Streams Replication
Streams Configuration Wizards
Creating Schema-Level Replication
Step 1: Object Selection
Step 2: Destination Options
Step 3: Replication Options
Step 4: Schedule Job
Step 5: Review
Monitoring and Managing the Streams Replication Environment
Monitoring the Capture Process
Monitoring the Propagation Process
Monitoring the Apply Process
Displaying Transaction Details: LogMiner Session
Displaying Overview of Streams Components
Displaying Streams Paths and Performance Analysis Data
Managing Streams Processes
Managing Apply Errors
Streams Metrics and Alerts
Summary
Part V Appendixes
A Oracle Streams Best Practices
Oracle Patches
ARCHIVELOG Mode and Archived Log Files
Tablespace for Streams
Streams Administrator User Account
Streams Administrator Privileges
Database Initialization Parameters
Database Links
Network Tuning
Operating System Parameters
Network Device Queue Size
Oracle Net Parameters
Heartbeat Table
DDL Replication
Establish Performance Goals
B Oracle Streams Replication in a RAC Environment
Archived Logs
Streams Queues
Queue-to-Queue Propagation
Checking Queue Table and Streams Process Locations
Creating Standby Redo Log Groups for Downstream Capture
C Streams Health Check Report
How to Run the Streams Health Check Script
When to Run the Streams Health Check Script
How to Use the Health Check Report
Configuration
Analysis
Statistics
Other Information
D Data Dictionary Views for Streams Replication
Views for Configuration and Administrative Tasks
Views for Capture Process
Views for Apply Process
Views for Propagation Process
Views for Rules and Rule Sets
Views for Instantiation
Views for Supplemental Logging
Views for Handlers
Views for Conflict Handlers
Views for Transformations
Views for LogMiner
Views for Archived Log/Redo Log Files
View for Transactions
Views for Queues and Queue Table
E References
Index

Systemvoraussetzungen

Als PDF speichern Als Link merken