Tuesday, June 14, 2016

GoldenGate subdirectories Usage 12c/11g

# GoldenGate subdirectories and Usage # 

GGSCI (z1p12c.ffdc.sbc.com) 3> create subdirs
Creating subdirectories under current directory /home/goldengate_home
Parameter files                /home/goldengate_home/dirprm: created
Report files                   /home/goldengate_home/dirrpt: created
Checkpoint files               /home/goldengate_home/dirchk: created
Process status files           /home/goldengate_home/dirpcs: created
SQL script files               /home/goldengate_home/dirsql: created
Database definitions files     /home/goldengate_home/dirdef: created
Extract data files             /home/goldengate_home/dirdat: created
Temporary files                /home/goldengate_home/dirtmp: created
Credential store files         /home/goldengate_home/dircrd: created
Masterkey wallet files         /home/goldengate_home/dirwlt: created
Dump files                     /home/goldengate_home/dirdmp: created

dirprm # Goldengate use dirprm directory to store goldengate parameter files and also we can also store prm that to create definitions for tables in goldengate
dirrpt # Goldengate process creates report files in dirprm directory. when ever goldengate process is stopped, started it writes process information to the report files 
dirchk # checkpoint files are created when ever we create goldengate process. GoldenGate updates the timestamp and scn of the database to the checkpoint file. GoldenGate process any transaction it updates the checkpoint file. If the goldengate process is abended, gg process uses checkpoint file  to start from where it is abended 
dirpcs #  when goldengate process  is up and running file is created with extension ( .pce , .pcr, .pcm ) 
dirsql # stores the sql scripts 
dirdef # definition files are created by defgen utility to store source and target definitions. All the definition files are written in ASCII format
dirdat # goldengate stores the local trail and remote trail created by pump and extract process 
dirtmp # it stores large transactions in the dirtmp directory 
discrd # used to store credential for encrypted user’s id and also store password ( I see this is new in 12c ) 
dirwlt # Wallet that stores master key 
dirdmp # It stores trace and dump files created on dirdmp directory 

--Nikhil Tatineni--
--12c Oracle GoldenGate--

Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...