Which three describe a valid OGG Event Action?
A. Stop the process
B. Write a checkpoint before and/or after writing the record to the trail.
C. Run a shell command
D. Purge old trail files
A,B,C
In reference guide, page 312,Syntax EVENTACTIONS ([STOP| ABORT | FORCESTOP][IGNORE
[TRANSACTION
[INCLUDEVENT]][DISCARD][LOG
[INFO
|
WARNING]][REPORT][ROLLOVER][SHELL<command>][TRACE <trace file> [TRANSACTION] [PURGE |
APPEND]][CHECKPOINT[BEFORE | AFTER | BOTH]][, ...])
You have discovered that an OGG checkpoint table has become corrupted. What is you best strategy
to recover From this?
A
What is the default format for a GoldenGate trail?
A
Which parameters) would be used for one-time initial replicat?
E
What file must be configured in order to use custom encryption keys?
A
Nicole is preparing initial data load Extract task EINI_HR using the parameter DBOPTIONS
FECHBATCHSIZE 2000. What is likely to happen if one of her source tables includes LOB data?
A
What Oracle GoldenGate feature provides recoverability without loss of transactions?
A
Which three types of information are stored in the GoldenGate trial header?
A,B,C
When would you use the PASSTHRU parameter?
A
Ideally which process should be configured purge old trial files?
A