Oracle Golden Gate Microservice Architecture Components

Till date we have seen all articles on Golden Gate with classic architecture and worked on golden gate software command line interface[ggsci] prompt. With Oracle Golden Gate 12C release 2 [12.3] a new architecture came into picture that is Oracle Golden Gate Microservice Architecture. Image Source Let us see each component in detail : Service […]

Read More

RMAN backup in Noarchive log mode

Today we will see how to take backup of Oracle Database when your database is in NOARCHIVELOG mode. Step 1: Check your database details

In the above output, we can see that the database is in NOARCHIVELOG mode and we have checked the db_recovery_file_dest_size parameter where we can see that it has enough space […]

Read More

Oracle 12c and its new things

I wrote many posts about all new features of Oracle 12c , how multi-tenant architecture works and all. In this post, we will see how oracle’s internal mechanisms have changed with multi-tenant architecture for its existing technologies. Let us start with Oracle Xstream : In Oracle Xtream, capturing changes from the database must always be […]

Read More

Installing Oracle Golden Gate

In previous articles, we have seen basic things we should know before getting started with Oracle Golden Gate All Goldengate In this article, we will see the system requirement for Oracle golden gate and will install oracle golden gate. Supported Operating System for Oracle GoldenGate 12c Linux x86-64: In Linux, Linux 5 and 6 are […]

Read More

Configuring Change Delivery

In previous articles, we have seen the configuration of change capture. Oracle Golden Gate architecture is mainly a collection of two main process Extract and Replicat. Extract process runs as source side from which you want to capture data and Replicat process runs at Destination side where you want run replication process. Each trail file […]

Read More

Data Selection and Filtering in Oracle Golden Gate

Oracle Golden Gate provides a variety of levels and conditions for selection and filtering data. Let’s start with the selection of table : We can map table1 with table2 so operation is done on table1 will be replicated on table2.

Data Selection with WHERE clause : Where () clause is the easiest and simplest […]

Read More

Configuring and Using String Substitution in DDL and DDL Error Handling

In the previous article, we have seen the configuration of DDL replication Configuring and Using Options for DDL Replication Today we will see Configuration of String Substitution in DDL replication. We can substitute strings within a DDL operation while it is being processed by Oracle Golden Gate. This feature provides convenience for changing and mapping […]

Read More

Configuring and Using Options for DDL Replication

As we have seen in previous article Oracle Golden Gate handles DDL operations for objects. DDL Replication in Golden Gate Objects are divided into scope for more simplicity as it shows how DDL operations on an object are handled by Oracle Golden Gate. There are mainly three scopes : Mapped : Objects which are specified […]

Read More

DDL Replication in Golden Gate

Till today, you have seen my all articles that show DML replication Golden Gate. I, U, D [Insert update and delete] three main operations which are replicated in Golden Gate. But, Golden Gate supports DDL replication too. It supports DDL synchronization from one database to another. Let us first see requirement and restrictions of DDL […]

Read More

Column Mapping and Transformation in Oracle Golden Gate

In general, any replication tool replicates data in similar objects. We need an identical copy of the source and target if we want to do replication. Column Mapping  Oracle Golden Gate is a strong tool which provides the capability to map columns between two dissimilarly structured database table. This feature can be implemented in Golden Gate […]

Read More