When running golden gate extract in RAC environment extract processes may abend with message asking to rollover extract because of SCN issue, following THREADOPTIONS parameters can be used in extract parameter file
TRANLOGOPTIONS ASMUSER sys@asm, ASMPASSWORD oracle
THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 45000 IOLATENCY 90000
COMMENT MAXCOMMITPROPAGATIONDELAY must be greater than 0 and less than 90000 milliseconds.
COMMENT IOLATENCY must be between 0 and 180000 milliseconds (3 minutes).
PLEASE NOTE :- You will still have to perform ETROLLOVER for starting extract.
TRANLOGOPTIONS ASMUSER sys@asm, ASMPASSWORD oracle
THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 45000 IOLATENCY 90000
COMMENT MAXCOMMITPROPAGATIONDELAY must be greater than 0 and less than 90000 milliseconds.
COMMENT IOLATENCY must be between 0 and 180000 milliseconds (3 minutes).
PLEASE NOTE :- You will still have to perform ETROLLOVER for starting extract.
No comments:
Post a Comment