Golden Gate

Golden Gate abends due to zeroed out records in trail file...

Submitted by dave on Wed, 02/06/2019 - 16:10

If you are getting odd abends on your Golden Gate replicats due to trail file corruption, make sure you visit your filesystem options for the filesystem where the manager process writes the trail files.

Long story short is that we were finding large swaths of Zeroes appearing in our trail files. Using logdump I could see the header of the trail file was OK, but somewhere down the line a valid record would be followed by straight up zeroes. Lots of them. I verified this using logdump and a hex editor.

Tags: 
Golden Gate
NFS

OS User role separation for Golden Gate administration...

Submitted by dave on Tue, 06/26/2012 - 17:31

We have many fingers in the pie where I work. Silos, silos everywhere. The DBA Group is responsible for operations and performance. ETL Admins are responsible for data movement. For a number of reasons we cannot allow the ETL Admins to log in directory as Oracle user. This is what I came up with to make everyone happy.

What is an ETL admin?

Our ETL Admins are users who do not need DBA or ROOT type access, they just need to run ggsci, start stop processes, edit config files, and check status of how things run.

Tags: 
linux
unix
Golden Gate

Golden Gate - OS User Permissions on *nix - DBA vs ETL Admin

Submitted by dave on Mon, 11/14/2011 - 13:11

Seems like Golden Gate is following me around. I used their tools in 2005 to replicate from OLTP databases to a central reporting database for my previous employer. Now that Oracle bought them the buzz in my current company is to leave Oracle's multiple and complicated incarnations of replication technologies in the dust and try moving forward with GG. Fine with me, I like the product, not a fan of the licensing as I think Oracle has been on the lagging side of vendor supplied replication tools, but hey what do I know, I just arrange zeroes and ones for a living.

Tags: 
permissions
Golden Gate

Need to audit changes? Can't change source database at all? This may work...

Submitted by dave on Mon, 04/12/2010 - 12:42

If you want to record copies of changed records on a target system you can do this with Golden Gate Software and not incur much in the way of source side resource drain.

Tags: 
Golden Gate
Auditing
Subscribe to Golden Gate