Extract and Replicat processes take care the data from the point of setup of the processes. To setup a replication using Goldengate, We need to make sure that existing data are properly copied from Source to Target and this is called Initial Load. There are different types of Initial Load available in Oracle GoldenGate as well as a few possible methods outside the GoldenGate for performing data synchronization between Source and Target databases. Initial Load: Using RMAN Oracle Export and Import (Data PUMP) Oracle Transportable Tablespace ETL Tools SQL Loader – Useful for heterogeneous enviro ..read more

In this article, I will show how to enable DDL replication for a table or schema which is the part of  goldengate replication. To enable the DDL, first need to execute below mentioned scripts on source database. 1. Scripts Execute. marker_setup ddl_setup role_setup.sql ddl_enable.sql 2. Update Extract and PUMP parameter to include DDL (DDL INCLUDE ALL) 3. Validation 4. Enable DDL at Table Level Execute marker_setup script: SQL> @marker_setup.sql Marker setup script You will be prompted for the name of a schema for the Oracle GoldenGate database objects. NOTE: The schema must ..read more

CREDENTIALSTORE: Creates a credentials store (wallet) that stores encrypted database user credentials. The CREDENTIALSTORE is a new feature in Oracle GoldenGate 12c and the default location of the credential store is “$GG_HOME/dircrd”. Existing Setup: GGSCI (orclprd.localdomain) 2> INFO CREDENTIALSTORE Reading from credential store: ERROR: Unable to open credential store. GGSCI (orclprd.localdomain) 3> ADD CREDENTIALSTORE Credential store created. GGSCI (orclprd.localdomain) 4> INFO CREDENTIALSTORE Reading from credential store: No information found in credential store. Step ..read more

To configure Oracle GoldenGate replication, we need to create below processes. In this article, I will use Oracle Database as source and target. High level steps: Install Oracle GoldenGate on source and target databases. Setup prerequisites. Setup connectivity. Create an user Credential. Configure Manager process on source and target databases. Initial Load. Configure Extract process on source database. Configure Pump process on source database. Configure Replicat process on target database. Source DB Details: Host Name: orcl19c.localdomain IP: 192.168.56.10 Database Name: orclprd Database ..read more

Oracle GoldenGate is a comprehensive software solution provided by Oracle for real-time data integration and replication in heterogeneous IT environments. It enables the exchange and manipulation of data at the transaction level among multiple, diverse platforms across the enterprise Use of GoldenGate: Data Replication: GoldenGate is often used to replicate data between different databases in real-time. This is valuable for maintaining consistent and up-to-date information across multiple systems. Data Migration: During system upgrades or migrations, GoldenGate can be employed to ensure a ..read more

In this article, I will show how to create a filesystem and mount it on Linux. Existing filesystem: [root@orclprd Packages]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_orclprd-lv_root 13G 4.7G 7.4G 39% / tmpfs 2.8G 76K 2.8G 1% /dev/shm /dev/sda1 477M 67M 381M 15% /boot /dev/sr0 3.6G 3.6G 0 100% /media/OL6.6 x86_64 Disc 1 20141018 [root@orclprd ~]# cd /dev [root@orclprd dev]# ls sd* sda sda1 sda2 sdb Create a logical partition: [root@orclprd dev]# fdisk sdb Device contains n ..read more

Sometimes DBA needs to create database creation script from existing database. Oracle provides the “alter database backup controlfile to trace” command to copy the create database syntax into a trace file. SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE as '/u01/backup/contril_file_bk.ctl'; Database altered. SQL> ! ls -lrt /u01/backup/contril_file_bk.ctl -rw-r--r--. 1 oracle oinstall 6101 Nov 13 13:16 /u01/backup/contril_file_bk.ctl SQL> ! cat /u01/backup/contril_file_bk.ctl -- The following are current System-scope REDO Log Archival related -- parameters and can be included ..read more

RMAN’s improvement in incremental backup performance is facilitated by its change tracking feature, which records altered blocks in a designated file. Enabling change tracking allows RMAN to efficiently identify changed blocks for incremental backups without the necessity of scanning every block in the datafile. Upon activating change tracking, it’s important to note that the initial level 0 incremental backup must still scan the entire datafile. This is because the change tracking file does not immediately reflect the block status. However, subsequent incremental backups that utilize this ini ..read more

CONNECT command: Connect command used to establish a connection between RMAN and a target, auxiliary, or recovery catalog database. Target DB Catalog DB Auxiliary DB RMAN> CONNECT TARGET / RMAN> CONNECT TARGET user_name@target_db_tns; RMAN> CONNECT CATALOG rman/pwd@catdb_tns; RMAN> CONNECT AUXILIARY rman/pwd@auxdb_tns ..read more

In this article, I will demonstrate how to install Oracle GoldenGate 19c on Linux Server. We will follow these Steps: Download GoldenGate Binary Installation Pre-Task Installation with GUI Mode Download GoldenGate Binary: Oracle URL to download the Software: https://edelivery.oracle.com/osdc/faces/SoftwareDelivery Choose the OS you are looking for: Choose the right software you needed and download: Move the software to server (can use WinSCP) [oracle@orcl19c goldengate]$ ls -lrt V983658-01.zip -rw-r--r--. 1 oracle oinstall 556240981 Nov 10 12:53 V983658-01.zip [oracle@orcl19c goldengate ..read more