Sunday, June 8, 2014

Replicat process abends with OGG-01091 Unable to open file... (Error 2, no such file or directory)

After abnormal crash of server , all databases has been restarted and existing goldengate replicat processes abended with below error,

 ERROR   OGG-01091  Oracle GoldenGate Delivery for Oracle, RANK1.prm:  Unable to open file <trail_file> (error 2, No such file or directory)

Whenever start of replicat process everytime same error occured. Although trail file exists in related directory, process could not start. To fix this error , related replicat process has been altered to begin with specific trail file which seems absent.

alter replicat <REPLICAT_NAME>,extseqno <trail file seq no> ,extrba 0

trail file seq no is absent file no


After this changement replicat process began successfully.

No comments:

Post a Comment