Golden Gate and Timezone
853038Aug 1 2011 — edited Aug 5 2011Hi all,
This may sound like one sort of typical question, we are using OGG for active active, between two data centers which are at different timezones, my question here is, can we able to replicat data according to local time zone on Data centers?
I mean 1st data center should have timestamps of EST even what OGG replicats and on 2nd Data center it should have all records in PST timestamp?
May be sound like a typical question, does it work that way in OGG, where we can change all the data which is been replicating should convert the timestamp columns to local timezone?
Or only solution is to maintain all Data centers in one time zone?
If so we need to change timezone at server level or else Database level will be fine?
We are using Sun sparc servers and oracle 11.1.0.7 DB version.
Thank You