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 […]
Monthly Archives: March 2019
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 [oracle@dbatesting ~]$ export ORACLE_SID=orcl [oracle@dbatesting ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Wed Dec 19 21:44:57 2018 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle […]
List of Publication
I am listing here 55 articles which I write and are published on the different Oracle Technology Network (OTN), different Oracle User Group (OUG) and ToadWorld. OTN Spanish Oracle Cloud: Creación de Configuración Oracle RAC en Cloud Oracle Cloud: Creando base de datos en la nube en base a “backup” existente (Parte I) Oracle Cloud: […]
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 […]
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 […]
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 […]
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. map hr.table1 , target hr.table2; Data Selection with WHERE clause : Where () clause is […]
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 […]
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 […]
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 […]