Sharing Tips & Tricks from my Database Experience
Tag: oracledatabase
Oracle GoldenGate Replicat is a software program that plays a crucial role in data replication within the Oracle GoldenGate data integration platform. It's responsible for applying changes captured from a source database to a target database, ensuring data consistency between the two database systems. Replicat is also responsible to deliver transaction to Big Data systems with … Continue reading GoldenGate Replicat? Which one should I use?
Now that we have completed Part 1 to set up the Container infrastructure, it's time to create the GoldenGate replication. The script below will auto-create everything we need to enable a Bi-directional replication for the West and East databases (created in Part 1). If you have not completed Part 1, please go back and look at … Continue reading Part 2 – Build GoldenGate Bi-Direction Replication in few minutes on Docker
Introduction: This Part 1 post will show you how to create a GoldenGate Free 23.3 (Hub) that connects to two Oracle Database Free 23.3 (I am calling them West and East). This is extremely easy if we take advantage of containers as I will describe it below. Part 2 will demonstrate how to automate the creation … Continue reading Part 1- Deploy GoldenGate 23c Free and two Oracle Database 23.3 on Docker in just a few Minutes
An essential consideration when configuring Oracle GoldenGate for bi-directional or multi-directional (active-active) data replication is the potential for data collision, which occurs when identical data is modified in distinct databases involved in the integration. GoldenGate includes an out-of-the-box capability to detect and resolve such conflicts. Automatic Conflict Detection and Resolution (ACDR) is configured at the … Continue reading Enable ACDR for all tables in a GoldenGate Bi-Directional Replication
From time to time you might need to find out where a particular transaction is in the redo logs. Most of the time if you want to look for an old transaction you will need to look into the archived logs history. This script will give you a good understanding of where the SCN for … Continue reading Find the Archived log from a SCN
The ACDR feature of Oracle GoldenGate adds hidden columns to tables to resolve conflicts when the same row is updated by different databases using active replication. GoldenGate can also create a "tombstone table," which records interesting column values for deleted rows. The Oracle Data Pump Import command-line mode TRANSFORM parameter enables you to alter object creation DDL … Continue reading Oracle Data Pump Filters GoldenGate ACDR Columns from Tables
GoldenGate Free 23c now supports per-pluggable Database (per-PDB) capture (Only). Oracle GoldenGate 23c (23.3) enables you to grant privileges to users at the PDB level. Root-level access using common user c##ggadmin, is no longer available. https://docs.oracle.com/en/middleware/goldengate/free/23/uggfe/goldengate-free-release-notes.html#GUID-65470EEC-B982-4817-8083-4D058D973125
Automatic Conflict Detection and Resolution (ACDR) was introduced in Oracle Database 12c Release 2 (and Oracle GoldenGate 12.3.0.1) to automate the conflict detection and resolution configuration in active-active Oracle GoldenGate replication setups. In Oracle Database 21c, Oracle enhanced ACDR to support earliest timestamp based resolution and site priority based resolution. In Oracle Database 23c, Oracle … Continue reading Automatic CDR Enhancements in 23c
OCI goldenGate has come a long way in the last year or so. Below are the connections it currently supports. Lots of excitement in this area of the product. I can't wait to see what comes next. What do you think? What would you like to see? Drop a comment below. Here are some cool … Continue reading OCI GoldenGate Service (GGS) Connection Types
Don't be left behind. GoldenGate Migration Utility was created to help you migrate from Classic to Microservices architecture without many manual procedures. Check out the video DEMO available on the GoldenGate Youtube Channel: https://www.youtube.com/watch?v=PQktlsAuJYI&ab_channel=oraclegoldengate
Our Spring Summit will be a 4hr webinar packed with the latest updates about Oracle GoldenGate and Stream Analytics, featuring customer stories, live demos, and a roadmap for the future of Data Fabric and Data Mesh architectures. We look forward to hosting you at this highly informative event. Zoom Event for EMEA Wednesday March 29, … Continue reading Oracle GoldenGate 2023 Virtual Customer Summit
Let's add and start an Extract with REST API, note that I am not starting at creation: -- Add Extractcurl -s -u oggadmin:"xxxxx" \-H "Accept: application/json" \-X POST http://localhost:9011/services/v2/extracts/EDEMO \-d '{"description":"Create Extract Demo","config":["EXTRACT EDEMO","EXTTRAIL ed","USERIDALIAS OGG_SRC_CDB","-- Integrated extract parameters","TRANLOGOPTIONS INTEGRATEDPARAMS (max_sga_size 2048, parallelism 4)","LOGALLSUPCOLS","UPDATERECORDFORMAT COMPACT","GETTRUNCATES","DDL INCLUDE MAPPED","DDLOPTIONS GETREPLICATES, GETAPPLOPS","TABLE SRCPDB.HR.*;"],"source":{"tranlogs":"integrated"},"credentials":{"alias":"OGG_SRC_CDB"},"registration":{"containers": [ "SRCPDB" ],"optimized":false},"begin":"now","targets":[{"name":"ed","sizeMB":50}],"status":"stopped"}' \| json_reformat … Continue reading GoldenGate Add Extract – (Part 3 Rest API Series)
alexlima.com 