Forum Stats

  • 3,851,436 Users
  • 2,263,977 Discussions
  • 7,904,707 Comments

Discussions

GG Auto CDR

user10126973
user10126973 Member Posts: 187 Blue Ribbon

Hi All,

I am trying to implement bi-directional(active-active) ADD_AUTO_CDR and ADD_AUTO_CDR_DELTA_RES

My question is I can execute both packages right ?

And another question is AUTO CDR require Primary Key of each table ?

please share your thoughts,

Regards,

DR

«1

Comments

  • ORASCN
    ORASCN Member Posts: 1,874 Bronze Crown

    Hi ,

    Yes, you can execute both packages. Actually, to enable delta resolution, you need to execute the ADD_AUTO_CDR in first place. Please check the below,


    16.2.2 Configuring Delta Conflict Detection and Resolution

    The ADD_AUTO_CDR_DELTA_RES procedure in the DBMS_GOLDENGATE_ADM package configures delta conflict detection and resolution.

    With delta conflict resolution, you specify one column for which conflicts are detected and resolved. The conflict is detected if the value of the column in the row LCR does not match the corresponding value in the table. The conflict is resolved by adding the difference between the new and old values in the row LCR to the value in the table.

    You can configure an Oracle GoldenGate administrator using the GRANT_ADMIN_PRIVILEGE procedure in the DBMS_GOLDENGATE_ADM package.

    1. Connect to the inbound server database as an Oracle GoldenGate administrator.
    2. Run the ADD_AUTO_CDR procedure and specify the table to configure for latest timestamp conflict detection and resolution.
    3. Run the ADD_AUTO_CDR_DELTA_RES procedure and specify the column on which delta conflict detection and resolution is performed.
    4. Repeat the previous steps in each Oracle Database that replicates the table.



    PK for the table is a must pre-requisite for AUTO_CDR. It is a mandatory one.


    Regards,

    Veera

  • user10126973
    user10126973 Member Posts: 187 Blue Ribbon

    thank you very much Veera

  • ORASCN
    ORASCN Member Posts: 1,874 Bronze Crown

    You are welcome!

  • user10126973
    user10126973 Member Posts: 187 Blue Ribbon

    Hi Veera,

    Auto CDR requires integrated extract and integrated replicate ?

    Range replicate will not support right ?

    Please share what are the restitutions other than primary key ?

    Regards,

    DR

  • ORASCN
    ORASCN Member Posts: 1,874 Bronze Crown

    Hi,

    • Oracle Database 12.2 on Source and Target
    • Requires Integrated Extract
    • Classic Extract does not support
    • Requires Integrated Replicat or Parallel Integrated Replicat 
    • Primary Key is mandatory


    Regards,

    Veera

  • user10126973
    user10126973 Member Posts: 187 Blue Ribbon

    HI Veera,

    thank all your info

    if we enable AUTO CDR,

    it automatically enables all column supplemental logging of each table?

    Regards,

    DR

  • ORASCN
    ORASCN Member Posts: 1,874 Bronze Crown

    Hi ,


    3.2.1 Automatic Conflict Detection and Resolution

    You can configure automatic conflict detection and resolution in an Oracle GoldenGate configuration that replicates tables between Oracle databases. To configure conflict detection and resolution for a table, call the ADD_AUTO_CDR procedure in the DBMS_GOLDENGATE_ADM package.

    Automatic conflict detection and resolution does not require application changes for the following reasons:

    • Oracle Database automatically creates and maintains invisible timestamp columns.
    • Inserts, updates, and deletes use the delete tombstone log table to determine if a row was deleted.
    • LOB column conflicts can be detected.
    • Oracle Database automatically configures supplemental logging on required columns.

    Supplemental logging is required to ensure that each row LCR has the information required to detect and resolve a conflict. Supplemental logging places additional information in the redo log for the columns of a table when a DML operation is performed on the table. When you configure a table for Oracle GoldenGate conflict detection and resolution, supplemental logging is configured automatically for all of the columns in the table.


    Regards,

    Veera

  • user10126973
    user10126973 Member Posts: 187 Blue Ribbon

    thank you very much Veera

  • user8417445
    user8417445 Member Posts: 2 Green Ribbon

    in 19c Auto CDR also supports UK if not PK available.

  • user10126973
    user10126973 Member Posts: 187 Blue Ribbon

    HI Veera/All,

    Can you please share if you have any example for ADD_AUTO_CDR_COLUMN_GROUP.

    I have implemented ADD_AUTO_CDR and its working fine, Now I want implement ADD_AUTO_CDR_COLUMN_GROUP as our application people want update multiple columns on that auto cdr table

    I just want know how to implement ADD_AUTO_CDR_COLUMN_GROUP and what exactly it does

    Please share your thoughts

    Regards,

    DR