Oracle Goldengate 11g Initial Load Using Direct Load Method.

This article focuses on initial synchronization of source and
target databases by using Golden Gate initial direct load method for the
purpose of zero downtime DML replication.


Prerequisites:

1) Target Tables should be empty. Otherwise you can get duplicate row errors.
2) Disable Foreign Key and Check Constraints. They can be enabled later on
   when the initial load is complete.
3) (Optional) Remove indexes from target tables as they may slow down the
   initial loading process.
4) To use handlecollisions function, each target table must have a
   primary or unique key. If that's not possible use the KEYCOLS 
   option of the TABLE and MAP parameters. Even if that is not possible
   then quiesce your database for the duration of intial load.

Read more >>

Delete or Remove Extract & Replicat Processes (Golden Gate 11g).

1)Stop extract/replicat.

kill extract group_name
kill replicat group_name

2)Delete extracat / replicat.

delete extract group_name
delete replicat group_name

3) Cleanup. 

cleanup extract group_name
cleanup replicat group_name

Read more >>

Oracle GoldenGate DDL Replication.

This post is built upon the previous post on Oracle GoldenGate DML replication.

Points to consider before implementing DDl replication.


1) Recyclebin feature should be turned off(Oracle 10g onwards).

Read more >>

Oracle GoldenGate Basic DML Replication.

Schema to be replicated "SCOTT".

SOURCE DATABASE.

OS - Red Hat Enterprise Linux Server release 5.4 

Hostname - canada

IP Address - 192.168.1.100

Database - Oracle 11g Release 2.

SID -  orcl

GoldenGate Version - 11.1.1.1.2

Sample "/etc/hosts" file.

# Do not remove the following line, or various programs
# that require network functionality will fail.

127.0.0.1                localhost.localdomain localhost

192.168.1.100   canada  canada
192.168.1.200   london  london

Read more >>

Oracle GoldenGate Basic Architecture.

Source Database - GoldenGate extracts the information from the source database.
The source database may be from any of the following vendors.

- Oracle Database
- TimesTen
- MySQL
- IBM DB2
- Microsoft SQL Server
- Teradata
- Sybase
- Enscribe
- SQL/MX

Read more >>

Oracle 11g GoldenGate Installation.

Download the GoldenGate software from Oracle Edelivery.

Select a Product Pack: Oracle Fusion Middleware
Platform: Linux X86

Download the Oracle GoldenGate media pack.

Read more >>