Unknown

GoldenGate Step by Step:





Source Database :

Check of all name from source database

Db_Name Hostname Db_Unique_Name Service_Name

SQL> SELECT NAME FROM v$database;

SQL> SELECT UTL_INADDR.get_host_name FROM dual;

SQL> SELECT UTL_INADDR.get_host_address from dual;

SQL> show parameter db_unique_name;

SQL> select value from v$parameter where name like '%service_name%';

# Target Server:

Check of all name from source database

Db_Name - GG Hostname - ORACLEGG Db_Unique_Name - GG Service_Name - GG

SQL> SELECT NAME FROM v$database;

SQL> SELECT UTL_INADDR.get_host_name FROM dual;

SQL> SELECT UTL_INADDR.get_host_address from dual;

SQL> show parameter db_unique_name;

SQL> select value from v$parameter where name like '%service_name%';

#Enable force logging from both database:

SQL>

If Force logging not enable :

SQL>

Alter switch the logfile for both database:

SQL>





# Enable Supplement loging for both database

SQL>

# If Supplement loging not enable:





SQL>

Configure Network for Source database

GG=

(DESCRIPTION=

(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.3)(PORT=1521))

(CONNECT_DATA=

(SERVER=DEDICATED)

(SERVICE_NAME=GG)

)

)

Now start the listener for Source database:

Linux$ > lsnrctl start

Now verify the connection for Target database using Source Server:

Linux$ > Sqlplus system/***@GG

Configure Network for Target database:

ORCL=

(DESCRIPTION=

(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.92)(PORT=1521))

(CONNECT_DATA=

(SERVER=DEDICATED)

(SERVICE_NAME=ORCL)

)

)

Now start the listener for Target database:

Linux$ > lsnrctl start

Now verify the connection for Source database using Target Server:

Linux$ > Sqlplus system/***@GG

Configure GoldenGate:

Download GG software

Create ggadmin account on both Server

Create Same directory on both Server

Configure Environment variable on both Server

Create User and Tablespace on both Server

Create Subdirectories on both Server

Set Global Parameters on both Server

Set Manager on both Server

Configure Extract Parameter and data pump parameter on Source Server

Create Check Point Table & Replication process on Target Server

Configure GoldenGate to add supplemental log data on Source Server

Add the Extract Process on Source Server

Add Replication Process on Target Server

Start Manager on both Server

Start the all Extract Process on Source Server

Start the Replication Process on Target Server

Finally Enable GoldenGate on both Server

# DownLoad GG software:

Download GG software version matching the release of the RDBMS.

# Create “GGADMIN” account :

# Create Same directory on Both Server:

Linux$ >

# Copy the download file to new directory on both Sever & Unzip the file

Linux$ >

# Configure Environment variable on Source Server

Linux$ >

cd /home/Oracle

Linux$ >

ls –altr

inux$ >

vi /.bash_profile

Copy and Paste :

# Configure Environment variable on Target Server

Linux$ >

cd /home/Oracle

Linux$ >

ls –altr

Linux$ >

vi /.bash_profile

Copy and Paste :

# Create User & Tablespace on both server:

SQL >

SQL >

# Give user privilege and role:

SQL >

SQL >

SQL >

SQL >

SQL >

SQL >

SQL >

SQL>

SQL >

SQL >

SQL >

# Create Subdirectory for both server using GoldenGate:

GGSCI >

# Set Global parameters on both server using GOldenGate:

GGSCI >

# And add the following entry on both server:

GGSCI >

# Set Manager parameters on both server using GOldenGate;

GGSCI >

# And add the following entry on both server using GOldenGate:

GGSCI >

GGSCI >

GGSCI >

GGSCI >

# Now start Manager on both server using GOldenGate:

GGSCI >

# Configure Extract parameter on Source Server using GOldenGate:

GGSCI >

# And add the following entry on Source Server using GOldenGate

GGSCI >

GGSCI >

GGSCI >

# Configure DataPump parameter on Source Server using GOldenGate:

GGSCI >

# And add the following entry on Source Server using GOldenGate

GGSCI >

GGSCI >

GGSCI >

GGSCI >

# Create Check point table on Target Server using GOldenGate:

GGSCI >

GGSCI >

# Again Modify Global parameter on Target Server:

GGSCI >

# And add the following entry on Target Server using GOldenGate:

GGSCI >

# Create Replication process on Target Server:

GGSCI >

# And add the following entry on Target Server using GOldenGate:

GGSCI >

GGSCI >

GGSCI >

GGSCI >

# Now Configure to add Supplemental Logging for Replicated the Source Tables on Source Server:

GGSCI >

GGSCI >

# Add the Extract_Process , Extract_Trail , Data_Pump_Process & Data_Pump_Trail on Source Server:

GGSCI >

GGSCI >

GGSCI >

GGSCI >

# Add Replication Process on Target Server:

GGSCI >

# Start manager from Source & Target Server

GGSCI >

# Start all the Extract process on Source Server

GGSCI >

GGSCI >

GGSCI >

GGSCI >

# Now start the replication process on Target Server

GGSCI >

GGSCI >

*****Enable Golden gate on both server*****

SQL>

*************Thank You*************

Reactions:

Account_Name = ggadminGroup = DbaDefault Shell = Ksh