Learn how to a build a cloud-first strategyRegister Now


supplemental logging in oracle streams

Posted on 2009-04-20
Medium Priority
Last Modified: 2013-12-18

i have a small question on supplemental logging in oracle streams. i am trying to configure oracle streams. in oracle documentation i have seen enable supplemental logging at table on source database. i did not quite understand what is supplemental logging. can any one clarify me.

in the documentation have seen this info.

supplemental logging

Additional column data placed in a redo log whenever an operation is performed. A capture process captures this additional information and places it in LCRs, and the additional information might be needed for an apply process to apply LCRs properly at a destination database.

what type additional data is placed when we enable supplemental logging.
what happen if i do not enable supplemental logging.

one more question is, i am configuring 1 way replication. do i need to enable archive log mode fro source database and target database?
Question by:pavan27
LVL 48

Accepted Solution

schwertner earned 1000 total points
ID: 24225004
The Capture process captures this additional information and places it in LCRs.
Supplemental Logging is always configured at a source database, regardless of location of the Capture process that captures the changes that occur in the source database. Even if the capture process is configured at the downstream database, the source database needs to specify the Supplemental Logging. In the case of Streams replication, the Apply process uses the additional information in the LCRs to properly apply DML changes and DDL changes that are replicated from a source database to a destination database.

There are two types of supplemental log groups: Unconditional Supplemental Log Groups and Conditional Supplemental Log Groups.

Unconditional Supplemental Log Groups - The before images of specified columns are logged any time a row is updated, regardless of whether or not the update affected any of the specified columns. This can be referred to as an ALWAYS log group.

Conditional Supplemental Log Groups - The before images of all specified columns are logged only if at least one of the columns in the log group is updated.

Supplemental Logging can be enabled at database level or at table level.

Assisted Solution

BobMc earned 1000 total points
ID: 24335746
Supplemental logging is additional data stored in the redo log that allows the target databases to determine which rows to update. It is a requirement of Streams and LogMiner.

In order to get Streams to work, you will need archiving enabled on your source database, as the streams capture process uses LogMiner, but it isnt absolutely necessary on the target. It is however good practice, and highly recommended.

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question