Senior Oracle DBA Goldengate interview questions

Oracle DBA Goldengate interview questions:

1.       What are the important process in GG?

2.       What is difference between CSN, SCN?

3.       What is extract, replicat?

4.       What are the GG types or topologies?

5.       How to get log from source & target?

6.       Difference between classic & integral extract process?

7.       What are the pre-request for GG?

8.       Types of replication in GG?

9.       What are the areas monitoring required in GG?

10.   What is the difference between local trail / Remote Trail?

11.   What are the GG utilities used?

12.   How to define size for extract file?

13.   How to change GG writing extract file?

14.   How to purge extract file automatically?

15.   How to check how many extract file created per day?

16.   What to check, when replication steps in primary & target?

17.   How to start/stop, extract/replicat for source & target?

18.   How to sync target with source if we missed the trail file?

19.   What is the format for trail file?

20.   What is the default location for the trail file & can we change the trail file location?

21.   What is the datapump in GG?

22.   Is there any limit in extract groups / Replicat numbers?

23.   What are the GG views?

24.   What is GLOBAL file in GG & location?

25.   What are the directory in GG?

26.   What is credential store?

27.   What are the types of encryption supported by GG?

28.   What is obey usage?

29.   What is discard file & usage? Can we change from default location?

30.   How to switch writing to new trail file?

31.   What is the proper steps to shutdown GG database?

32.   How to automatically remove old trail file?

33.   How to enable automatic for replicat/ extract?

34.   What are the parameter file used by GG?

35.   What are the limitation for bidirectional GG?

36.   What is the use of REPERROR in GG?

37.   How to check latency between source & GG?

38.   What is utility used to open trail file in GG?

39.   How to check particular trail file needed or not?

40.   What are the various GG operational types?

41.   What is reverse utility?

42.   In unidirectional GG setup, steps to add a table for replication?

43.   Can we change the GG oracle DB without setting up in operating system level?

44.   What are the types extract check point positions?

45.   How to change the trail file size in GG?

46.   How to check all records processed in replicat? Info replicat group , it should return <EOF>

47.   How to calculate & allocate swap space for GG server?

48.   How to check last 5 recent extract checkpoints?

49.   How to control the checkpoint in extract & replicat?

50.   How to confirm extract in working file in GG?

51.   What are the recovery types in extract process?

52.   How to setup lag process time in GG?

53.   How to manager process to check extract/replicat lag?

54.   How to view GG error log & process report?

55.   How to check how many records processed in replication /extraction?

56.   What is discard file? How to check default location?
57. How to check ,how many updates/deletes happened on GG in particular time?
58. what is archive log only mode in GG?
59. what is the command to see the recovery status in GG?
60.what is the use of SOURCEISTABLE &SPECIALRUN keyword in GG?