supplemental logging in oracle streams

Posted on 2009-04-20
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 47

    Accepted Solution

    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.
    LVL 7

    Assisted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    Via a live example, show how to take different types of Oracle backups using RMAN.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now