Forum Stats

  • 3,769,410 Users
  • 2,252,962 Discussions
  • 7,875,023 Comments

Discussions

GG Auto CDR

user10126973
user10126973 Member Posts: 126 Red 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,825 Gold Trophy

    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: 126 Red Ribbon

    thank you very much Veera

  • ORASCN
    ORASCN Member Posts: 1,825 Gold Trophy

    You are welcome!

  • user10126973
    user10126973 Member Posts: 126 Red 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,825 Gold Trophy

    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: 126 Red 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,825 Gold Trophy

    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: 126 Red Ribbon

    thank you very much Veera

  • user8417445
    user8417445 Member Posts: 2 Green Ribbon

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

  • User_KACDL
    User_KACDL Member Posts: 5 Green Ribbon
    edited Oct 22, 2021 12:02PM

    While software development teams https://mlsdev.com/blog/top-custom-software-development-companies may come from a variety of backgrounds, most focus on specific software fields. Database designers create software applications that integrate hardware and software to allow for electronic billing and electronic medical records. Web software developers create website applications and add interactivity to help people find information online. Software engineers often work on highly technically demanding jobs such as those involved in computer software design, gaming development, 3D visualization, augmented reality, and video game design.