Saturday, January 12, 2013
Goldengate replication on RAC and timezone change
I was troubleshooting a goldengate issue in a 2node RAC on RHEL8 i ran into a issue
where extract was not writing to trail log .
We recently changed the timezone of the server to GMT from PST to match with other target server residing on different continent while setting up the environment. and we did our regular approach of bringging down the cluster and database using crsctl/srvctl way. however i was surprised to see that the redo log timestamp was still on PST . Which means the golden gate extract begin now was not finding any latest change from the redo log threads . no matter how many times I brought up brought down the database using srvctl didnt change the online redo log timestamp. so i did a manual restart of database instances after that the redo started showing the timestamp on GMT . and bouncing the manager resolved the extract issue .
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment