Oracle Goldengate Interview Questions & Answers

Oracle Goldengate Interview Questions & Answers

Q. What database does GoldenGate support for replication?

-Oracle Database
-TimesTen
-MySQL
-IBM DB2
-Microsoft SQL Server
-Informix
-Teradata
-Sybase
-Enscribe
-SQL/MX
-NOSQL
-INFORMIX

Q. What transaction types does GoldenGate support for Replication?

GoldenGate supports both DML and DDL Replication from the source to target. DDL and DML could be enabled separately without enabling the other transaction types.

Q. What are the GoldenGate setup pre-requisites?

Source:
The following supplemental logging is required. -
Database supplemental logging
Object level supplemental logging (ADD TRANDATA)
Database level GoldenGate user with GoldenGate level privileges for extraction of data from
source database.
Target:
Database level GoldenGate user with GoldenGate level privileges for replication of data to target
database.

Q. Why is Supplemental logging required for Replication?

When a transaction is committed on the source database, only new data is written to the Redo
log. However for Oracle to apply these transactions on the destination database, the before image
key values are required to identify the effected rows. This data is also placed in the trail file and
used to identify the rows on the destination, using the key value the transactions are executed
against them. So to say in few words, to uniquely identify the row Supplemental logging is required.

Q. Why are the Parameter files in GoldenGate?

Parameter files are heartbeat of GoldenGate. GoldenGate process works based on Parameters defined in Parameter files. Every Process in GoldenGate has its own Parameter file.

Q. What is the location of Report files?

The report file for each process is written inside dirrpt. GoldenGate stored 10 latest report file for each process in dirrpt.

Q. Which Parameter id used to housekeep the trail Files of GoldenGate?

PURGEOLDEXTRACTS is used in manager parameter file to housekeep the trail files.

Q. I want to view description regarding a particular Parameter. Is there any parameter in GoldenGate?

From 12.2 onwards u can use parameter INFO PARAM <PARAMETER NAME> in GGSCI.
GGSCI> info param<PARAMETER NAME>

Q. What is data pump process in GoldenGate?

The Data Pump (not to be confused with the Oracle Export Import Data Pump) is an optional secondary Extract group that is created on the source system. When Data Pump is not used, the Extract process writes to a remote trail that is located on the target system using TCP/IP. When Data Pump is configured, the Extract process writes to a local trail and from here Data Pump will read the trail and write the data over the network to the remote trail located on the target system. The advantages of this be it protects against a network failure as in the absence of a storage device on the local system, the Extract process writes data into memory before the same is sent over the network. Any failures in the network could then cause the Extract process to abort (abend). Also, if we are doing any complex data transformation or filtering, the same can be performed by the Data Pump. It will also be useful when we are consolidating data from several sources into one central target where data pump on each individual source system can write to one common trail file on the target.

Q. Where can filtering of data for a column be configured?

Filtering of the columns of a table can be set at the Extract, Pump or Replicat level.

Q. Is it a requirement to configure a PUMP extract process in OGG replication?

PUMP extract is an option, but it is highly recommended to use this to safe guard against network failures. Normally it is configured when you are setting up OGG replication across the network.

Q. List the minimum parameters that can be used to create the extract process?

The following are the minimum required parameters which must be defined in the extract
parameter file.
EXTRACT NAME
USERID
EXTTRAIL
TABLE

Q. What is the command line utility in GoldenGate (or) what is ggsci?

GoldenGate Command Line Interface essential commands – GGSCI
GGSCI — (Oracle) GoldenGate Software Command Interpreter

Q. What type of Encryption is supported in GoldenGate?

Oracle GoldenGate provides 3 types of Encryption.

-Data Encryption using Blow fish.
-Password Encryption in dircrd
-Network Encryption.

Q. What are the different password encryption options available with OGG?
You can encrypt a password in OGG using Blowfish algorithm and Advance Encryption Standard (AES) algorithm

Q. Is there a way to check the syntax of the commands in the parameter file without running the GoldenGate process?

Yes, you can place the SHOWSYNTAX parameter in the parameter file and try starting. If there is any error, you will see it.

Q. What information can you expect when there us data in the discard file?

When data is discarded, the discard file can contain:
Discard row details
Database Errors
Trail file number

Q. What command can be used to switch writing the trail data to a new trail file?

You can use the following command to write the trail data to a new trail file.
SEND EXTRACT ext_name, ROLLOVER

Q. How can you determine if the parameters for a process was recently changed?
Whenever a process is started, the parameters in the.prm file for the process is written to the process REPORT. You can look at the older process reports to view the parameters which were used to start up the process. By comparing the older and the current reports you can identify the changes in the parameters.