Streams Synchronous Capture 11g New Feature Example
(Doc ID 1109293.1)
Last updated on DECEMBER 18, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]Oracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.
Minimal patches that needs to be applied before configuring Streams Streams Specific Patches (Doc ID 437838.1)
10gR2 Streams Recommended Configuration (Doc ID 418755.1)
Goal
Streams Synchronous Capture is a New Feature of Oracle 11g; It doesn't rely on archive logs
or redo logs to capture changes. Instead a synchronous capture uses an internal mechanism to
capture changes and format each captured change into an LCR. The messages captured by a synchronous capture
are called persistent LCRs. A synchronous capture always enqueues into a commit-time queue
to ensure that transactions are ordered properly.
As a matter of fact, propagation and apply processes don't change so much.
Sync capture captures the DML change made using Insert update delete merger
It can be used even if the source database is running in noarchivelog mode and
doesn't require you add any supplemental logging.
Use Synchronous capture when
==========================
Redo-based capture is not possible ( such as the Standards Edition on the database )
Redo or logminer-related cannot be used but other streams background process can be utilized
Capture need to occur at the same time ( Synchronous) to user transaction
Change should be stored on a queue on disk ( persistently)
Clone data of table with few updates
Data Types Captured by Synchronous Capture
When capturing the row changes resulting from DML changes made to tables,
synchronous capture can capture changes made to columns of the following data
types:
- VARCHAR2
- NVARCHAR2
- NUMBER
- FLOAT
- DATE
- BINARY_FLOAT
- BINARY_DOUBLE
- TIMESTAMP
- TIMESTAMP WITH TIME ZONE
- TIMESTAMP WITH LOCAL TIME ZONE
- INTERVAL YEAR TO MONTH
- INTERVAL DAY TO SECOND
- RAW
- CHAR
- NCHAR
- UROWID
More detail
Streams Concepts and Administration 11g Release 2 (11.2) E10704-05
Implicit Capture with Synchronous Capture
Synchronous Capture Rules
=====================
=====================
A synchronous capture table rule with a positive rule set,
A synchronous capture cannot have a negative rule set.
A synchronous capture cannot have a negative rule set.
A synchronous capture cannot use schema rules
A synchronous capture cannot use global rules.
Note: You cannot use ADD_SCHEMA_RULES or ADD_GLOBAL_RULES to create synchronous
capture.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| Requirements |
| Configuring |
| Instructions |
| References |