Oracle Data Guard and Oracle GoldenGate are disaster recovery software used for data replication. The two software are mainly the top picks for disaster recovery. Other software like...

OBJECTIVE: Write a script is to monitor goldengate processes like extract and replicat, And in case extract or replicat is down, it will send alert to the respective email ids. SOLUTION: Below is the ...

                    COLS & COLSEXCEPT filter parameters are used to exclude or include(select) few columns of a table from goldengate extraction. i.e if a table on source has 5 column, a...

In this tutorial, we will explain how to do schema replication in goldengate. Schema replication means, replicating all the tables of a schema.   1. add supplemental for all tables of a schema [ ...

In this below tutorial, we will enable DDL replication for a table, which is already part of  goldengate replication and currently only DML transactions are getting replicated. TABLE_NAME = APPLIAN...

Below are the steps for adding a new table to the existing extract and replicat. In this example, we will add DBACLASS.SAL table to existing replication. 1.stop extract and pump process [ SOURCE] GGSC...

In this below tutorial, we will setup one-way goldengate replication for below two tables from database SRCDB to TRGDB. DBACLASS.EMP; DBACLASS.DEPT; SEE – Oracle goldengate Fundamentals NOTE &#8...

Like we execute .sql file against SQL, we can write multiple goldengate commands inside a .oby file and execute it against GGSCI prompt using OBEY command. EXAMPLE: In the below example, we will add s...

PROBLEM: Archive logs are not getting deleted with RMAN command, and it is reporting below warnings. RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archi...

     If source and target table structures are different, like source has then we need to use definition file in replicat file. Example: Here we will generate definition file of a table DBACLASS.E...