Oracle Golden Gate Files

There are different types of golden gate files commonly know as:

• Log files
• Parameter files 
• report files

Parameter files:

    There are two types of parameter files they are 

1. GLOBALS 
2. Run time parameter files

• GLOBALS: The GLOBALS file stores parameters that relate to the Oracle Golden Gate instance as a whole. This is in contrast to runtime parameters,

Note: if a parameter is declared in Global file and as well as run time parameter individual file then golden gate considers the parameter values declared in run time parameters file.

•  Run Time Parameter Files: Run time parameter files give control over various accepts of sync and also specific to some process like Extract, pump, Replicat and manager processes 

The default location of Run time parameter files is: : <golden_gate_home_directory>/dirprm

The File extensions of run time parameter files are: : ".prm"

Some of the run time parameter files example:

Extract process parameter file:

#Extract group name

EXTRACT EEXTTEST

setenv NLS_CHARACTERSET="WE8ISO8859P1"

setenv NLS_LANG="AMERICAN_AMERICA.WE8ISO8859P1"

setenv ORACLE_SID="database"

#Extract database user login, with alias to credentials in the credential store.

USERID ggs_dba, PASSWORD ******

#trail file location

EXTTRAIL /backup/fra/ogg/dirdat/ez

#need to know

DISCARDFILE /backup/fra/ogg/dirrpt/EEXTTEST.dsc, APPEND

REPORTCOUNT EVERY 5000 RECORDS, RATE

LOGALLSUPCOLS

#filters

DDL INCLUDE MAPPED

DDLOPTIONS REPORT

#on which data is to be extracted 

table SCHEMA1.*;

Pump process parameter file:

#Extract pump group name

EXTRACT PEXTTEST

setenv NLS_CHARACTERSET="WE8ISO8859P1"

setenv NLS_LANG="AMERICAN_AMERICA.WE8ISO8859P1"

PASSTHRU

#remote server details

RMTHOST service.ca, MGRPORT 12000

#remote trail file location

RMTTRAIL /backup/fra/ogg/dirdat/pz

#need to know

DDL INCLUDE  MAPPED

DDLOPTIONS REPORT

#on which data is to be extracted 

table SCHEMA1.*;

Replicat process parameter file:

#Replicat group name

REPLICAT RREPTEST

setenv NLS_CHARACTERSET="WE8ISO8859P1"

setenv NLS_LANG="AMERICAN_AMERICA.WE8ISO8859P1"

#target database login details

USERID c##ggs_dba@database, PASSWORD *****

#need to know 

DISCARDFILE /backup/UAMOI/ogg19.1/dirrpt/RREPTEST.dsc, APPEND, MEGABYTES 1024

REPORTCOUNT EVERY 5000 RECORDS, RATE

PRESERVETARGETTIMEZONE

#if the names need to changed we use map keyword

MAP SCHEMA1.*, TARGET SCHEMA2.*;

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Error log files:

For monitoring:

Oracle Golden Gate is integrated with syslog messaging system in Linux/UNIX and Windows Event Viewer for events logging in windows.

Mainly there are three files which are managing the run time errors in the golden gate tool they are:

1. ggserr.log – Is for logging currently running instance activities,
2. tcperr – Defines rules for handling TCP/IP errors and actions
3. ggMessage.dat – Stores Golden Gate error messages specific to the instance version
4. report file

• All these log files are located at golden gate home directory
• By default, ggserr.log file writes all level of messages like any process start or stop status …. etc.

We can keep filters to these messages by defining a parameter named syslog in GLOBALS file or mgr.prm file, the syslog can be defined by any one of these ALL, INFO, NONE, WARN, ERROR