ORACLE GOLDENGATE SUBDIRECTORIES

ORACLE GOLDENGATE SUBDIRECTORIES

In this article we will see the sub-directories of Oracle GoldenGate

we have totally 11 subdirs available in Oracle GoldenGate.

List of directories :

dirdat –> Extract data files
dirchk –> Checkpoint file
dirtmp –> Temporary files
dirrpt –> Report file
dirdef –> Database definitions files
dirpcs –> Process status files
dirtmp –> Temporary files

dirsql –> SQL script files
dircrd –> Credential store files
dirwlt –> Master key wallet files
dirdmp –> Dump files

Note : In all 11 subdirs we should focus on below subdirs

dirdat :

  1. The default location for Oracle GoldenGate trail files that are created by Extract processes to store extracted data for further processing by the Replicat process
  2. Written in internal Oracle Golden Gate format.
  3. File name format is a user-defined two-character prefix followed by either a six digit sequence number (trail files)
  4. Do not edit these files.
  5. Examples:

et000000

et000001

rt000000

rt000001

dirchk :

  1. The default location for Oracle GoldenGate checkpoint files created by Extract and Replicat processes, which store current read and write positions to support data accuracy and fault tolerance.
  2. Written in internal Oracle GoldenGate format
  3. File name format is <group name><sequence number>.<ext> where <sequence number> is a sequential number appended to aged files and <ext> is either cpe for Extract checkpoint files or cpr for Replicat checkpoint files.
  4. Do not edit these files
  5. Examples:

ext1.cpe (extract)

rep1.cpr (replicat)

 

dirprm :

  1. The default location for Oracle GoldenGate parameter files created by Oracle GoldenGate users to store run-time parameters for Oracle GoldenGate process groups.
  2. Written in external ASCII format.
  3. File name format is <group name/user-defined name>.prm or mgr.prm.
  4. These files may be edited to change Oracle GoldenGate parameter values after stopping the process. They can be edited directly from a text editor or by using the EDIT PARAMS command in GGSCI.
  5. Examples:

defgen.prm

finance.prm

dirrpt :

  1. The default location for process report files created by Extract, Replicat, and Manager Processes to report statistical information relating to a processing run.
  2. Written in external ASCII format
  3. File name format is <group name><sequence number>.rpt where <sequence number> is a sequential number appended to aged files.
  4. Do not edit these files.
  5. Examples:

fin2.rpt

mgr4.rpt

dirdef :

  1. The default location for data definitions files created by the DEFGEN utility to contain source or target data definitions used in a heterogeneous synchronization environment.
  2. Written in external ASCII.
  3. File name format is a user-defined name specified in the DEFGEN parameter file.
  4. These files may be edited to add definitions for newly created tables.
  5. Example:

defs.dat

dirpcs :

  1. Default location for process status files.
  2. File name format is <group>.<extension> where <group> is the name of the group and <extension> is either pce (Extract), pcr (Replicat), or pcm (Manager). These files are only created while a process is running. The file shows the program name, the process name, the port number, and the process ID.
  3. Do not edit these files.
  4. Examples:

mgr.pcm

ext.pce

 

dirtmp :

  1. The default location for storing transaction data when the size exceeds the memory size that is allocated for the cache manager.
  2. Do not edit these files.

 

 

Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Add Comment