GoldenGate Directory structure
Successful installation of Oracle
GoldenGate 12c creates the directory structure. Use the
GGSCI SHOW command to display the instance directory
structure.
The
Goldengate dirprm directory
This directory is the default location for
parameter files associated with group names. When an object
created such as extract, data pump extract and replicat, a
parameter file is looked at for the group name. Using
non-default location is referenced by the parameter PARAMS
<parameter file>.
Regardless of the parameter file location, the
parameter file name and the group name must match.
The
Goldengate dirrpt directory
This directory is the default location for
reports and discarded records. Whenever a process ABENDED, a
report file is created on this directory. The report file
indicates the reasons for failure, and if the failure is
database related, it also indicate the Oracle error code.
Using non-default location is referenced by the parameter
REPORT <report file>.
The
Goldengate dirchk directory
This directory is for storing extract,
data pump and replicat checkpoint files. Depending on the
object type, a file is created using the group name with
proper a relevant extension. For extract process, the
checkpoint file name is <group name>.cpe. For replicat
process, the checkpoint file name is <group name>.cpr.
The
Goldengate dirpcs directory
This directory stores Oracle GoldenGate
process identifier (PID). It's the PID assigned by the
operating system to running program, which is associated
with an Oracle GoldenGate process. To obtain more details,
use the operating system command ps –edf | grep <group
name>.
The
Goldengate dirsql directory
This directory is default location to
store SQL Script used by Oracle GoldenGate.
The
Goldengate dirdef directory
This directory is used to store definition
files. Definition files are required when the source and the
target tables are not identical. Mostly used for
heterogeneous environment when mapping tables across
dissimilar platforms.
The
Goldengate dirdat directory
This directory is used to start trail
files. The trail files are identified by a two character
prefix, followed by 6 digits. An extract or replicat
processes trail files are designated by the parameter
EXTTRAIL followed by the trial file location and name. For
example, EXTTRAIL ./dirdat/sa.
The
Goldengate dirtmp directory
This directory is the default location for
Oracle GoldenGate temporary files due to capturing large
transactions that goes beyond default cache size used by the
extract process. The location and size is controlled by the
CACHEMGR sub-parameters CACHESIZE, CACHEDIRECTORY and
CACHEPAGEOUTSIZE. Also, it's always recommended to dedicate
a directory location to host the temporary files, avoiding
contention with other type of files.
To confirm the current Oracle GoldenGate
environment and subdirectories locations, use the GGSCI SHOW
command.
GGSCI (ggs-source) 12> show
Parameter settings:
SET SUBDIRS
ON
SET DEBUG
OFF
Current directory: /u01/app/oracle/ggs
Using subdirectories for all process
files
Editor:
vi
Reports (.rpt)
/u01/app/oracle/ggs/dirrpt
Parameters (.prm)
/u01/app/oracle/ggs/dirprm
Replicat Checkpoints (.cpr)
/u01/app/oracle/ggs/dirchk
Extract Checkpoints (.cpe)
/u01/app/oracle/ggs/dirchk
Process Status (.pcs)
/u01/app/oracle/ggs/dirpcs
SQL Scripts (.sql)
/u01/app/oracle/ggs/dirsql
Database Definitions (.def)
/u01/app/oracle/ggs/dirdef
Dump files (.dmp)
/u01/app/oracle/ggs/dirdmp
Masterkey wallet files (.wlt)
/u01/app/oracle/ggs/dirwlt
Credential store files (.crd)
/u01/app/oracle/ggs/dircrd
GGSCI (ggs-source) 13>
|
|
|
Oracle GoldenGate 12c
The above is an excerpt from the upcoming
12c book
Oracle GoldenGate 12c: A Hands-on Guide to Data
Replication & Integration using Oracle & SQL Server.
|
|
|
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
and include the URL for the page.
Copyright © 1996 - 2020
All rights reserved by
Burleson
Oracle ®
is the registered trademark of Oracle Corporation.
|
|