Which command forces a running Extract to close the current trial and start writing to the
next trial sequence number?
A.
ALTER EXTTRAIL <trail name>, NEXTSEQNO
B.
ALTER EXTTRAIL <trail name>, ROLLOVER
C.
SEND EXTRACT <group>, ETROLLOVER
D.
SEND EXTRACT <group>, ROLLOVER
Explanation:
In reference guide, page 36:Syntax SEND EXTRACT <group name>, {CACHEMGR
{CACHESTATS | CACHEQUEUES | CACHEPOOL} |FORCESTOP |FORCETRANS <ID>
[THREAD <n>] [FORCE] |GETLAG |GETTCPSTATS |LOGEND |REPORT |ROLLOVER
|SHOWTRANS [<ID>] [THREAD <n>] [COUNT <n>][DURATION <duration><unit>]
[TABULAR][FILE <name> [DETAIL]] |SKIPTRANS <ID> [THREAD <n>] [FORCE]STATUS |STOP
|TLTRACE {DEBUG | OFF | <level>} [DDLINCLUDE | DDL[ONLY]] [FILE] <file name> |TRACE[2]
<tracefile> |TRACE[2] OFF |TRACEINIT |TRANLOGOPTIONS
{PURGEORPHANEDTRANSACTIONS | NOPURGEORPHANEDTRANSACTIONS}
|TRANLOGOPTIONS TRANSCLEANUPFREQUENCY <minutes> |VAMMESSAGE “<Teradata
command>” |VAMMESSAGE {“ARSTATS” | “INCLUDELIST [filter]” | “EXCLUDELIST [filter]”}|VAMMESSAGE “OPENTRANS”}
C – see page 127 of Oracle GoldenGate Windows and UNIX Reference Guide
Hi Gautam,
The parameter ETROLLOVER exists only for ALTER EXTRACT command. It’s not a valid option for SEND EXTRACT (page 26 of Oracle Goldengate Windows and UNIX Reference Guide, you may check for either 10.4 or 11.1)
And: D
Explanation with sample command: SEND EXTRACT , {
BR {BRINTERVAL |
BRSTART |
BRSTOP |
BRCHECKPOINT {IMMEDIATE | IN {H|M} | AT YYYY-MM-DD HH:MM[:SS]}} |
CACHEMGR {CACHESTATS | CACHEQUEUES | CACHEPOOL} |
ROLLOVER )
Answer is D since ETROLLOVER is used only with ALTER Extract
Agree. Answer D is correct
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf( Page 40 )
ROLLOVER: Causes Extract to increment to the next file in the trail when
restarting. For example, if the current file is ET000002, the
current file will be ET000003 after the command executes