Top 50 real-time Oracle GoldenGate (OGG) Interview Questions And answers 2023

OGG (Oracle Golden Gate) Interview Questions for experienced Part2

26. Why is Supplemental logging required for Replication in Golden Gate? is it mandatory?

Answer:

The process of adding these additional columns into redo log files is called supplemental logging.

Supplemental logging makes sure that enough information is captured, into the redo log file, during the update that can be used by any method based on log miner technology.

Supplemental logging can be enabled at the table level or at the Database level.

27. Does DDLs are supported by OGG ?
Answer:

28. List the minimum parameters that can be used to create the OGG extract process?
Answer:

29. What parameters can be used to configure Oracle GoldenGate to extract data from Archived Redo log files only?
Answer:

30. What type of Encryption is supported in OGG?
Answer:

31. What were some of the new features of GoldenGate (OGG) 19c/21c?
Answer:

32. What is a Credential Store in OGG 12c? How to configure Credential Store in OGG 12c?
Answer:

33. How do the Replicat works in a Coordinated Mode?
Answer:

34. What is the advantage of the collector process (in classic architecture)?
Answer:

35. List a few parameters which you used to improve the OGG replicat process performance?
Answer:

36. How do you see the contents of trail files ?
Answer:

37. What is the use of the DEFGEN utility?
Answer:

38. What is the best practice to delete old extract files in OGG?
Answer:

39. Is SCN and CSN are same ?

Answer:
Yes, they are the same

40. What is the difference between classic architecture and MA (Microservices Architecture) of OGG ?
Answer:

41. What is Oracle GoldenGate Microservice Architecture (MA)  (OGG 12c Release 3 onwards)?
Answer:

42. What is Admin client (after Golden Gate 12.3) ?
Answer:

43. What is OGG Service Manager (from 12c Release 3)?

Answer:

44. How to find out the overhead of Supplemental logging ?

Answer:

45. What is the difference between Supplemental logging of Min/UI/PK/FK/ALL ?

Answer:

At the least, minimal database-level supplemental logging must be enabled for any Change Data Capture source database.

46. Why is force logging required for Replication in OGG? is it mandatory?

Answer:

47. How to do a bidirectional Golden Gate setup ?

Answer:

48. How you will check whether replication is bidirectional (active-active setup) or not?
Answer:

49. 

50.

Related Oracle Interview Articles: Oracle GoldenGate (OGG) Interview Questions/FAQs Part1