Oracle Golden Gate - quick notes



DIRDAT                 Location of the local trail files
DIRDMP               Location of the dump files and the DEFGEN files
DIRPRM               Contains extract/datapump process config files
DIRCHK                 Location of checkpoint files
DIRDEF                 Location for data definition files created by DEFGEN
DIRPCS                 Default location for status files, do not edit these files
DIRRPT                 Location of process report files and the discard file (.dsc)
DIRTMP                Default location for storing transaction data when the size exceeds the memory size, do not edit these files

The command show all will show the location of all the relevant files:

OBY files are used to store all the configuration details
The files will be name beginning with the name of the source system, e.g. abp_ ods_ cng_
dblogin.oby        Database login details
login.oby            Golden Gate login details
mgrport.oby      Details of where and on what port the manager process is running
ora_env.oby      Oracle environment variable settings
setup.oby           alters tables for supplemental logging and registers the GG processes
tables.oby          Lists the tables to be processed
trandata.oby     Adds trandata for the tables to be processed so that the process can get the transactional data for that table.
tables_x.oby      List the tables and columns to extract
ggserr.log           Logfile that is located in the OGG home directory.

Thanks to Russell W. for putting theses notes together :)

No comments:

Post a Comment