Re: [Non-DoD Source] Re: time stamps with Data Guard
Date: Fri, 18 Dec 2015 08:15:13 -0600
Message-ID: <CAJvnOJYkQwbXCRanqm6t3dcwZJDE85kBEoODHcM0ytxvg9u-nw_at_mail.gmail.com>
If you set the time zone of the standby server at the os level to match the time zone of the primary server at the os level, then there wont be a problem. Also, check the exact data type you are storing. If you are storing time stamp with time zone, you dont have a problem to begin with.
On Fri, Dec 18, 2015 at 7:15 AM, Terrian, Thomas J DLA CTR INFORMATION OPERATIONS <Tom.Terrian.ctr_at_dla.mil> wrote:
> So, if I change the time zone of the standby, then (when we switchover) if
> we look at sysdate if won't be the same as the O/S time? Oracle will
> convert it over to whichever time zone I set it to?
>
> -----Original Message-----
> From: Andrew Kerber [mailto:andrew.kerber_at_gmail.com]
> Sent: Friday, December 18, 2015 8:06 AM
> To: Terrian, Thomas J DLA CTR INFORMATION OPERATIONS
> Cc: oracle-l_at_freelists.org
> Subject: [Non-DoD Source] Re: time stamps with Data Guard
>
> You can set the time zone of the standby server to match the primary.
>
> Sent from my iPhone
>
> > On Dec 18, 2015, at 6:29 AM, Terrian, Thomas J DLA CTR INFORMATION
> OPERATIONS <Tom.Terrian.ctr_at_dla.mil> wrote:
> >
> > We have a primary database in one time zone and a Data Guard copy in
> another time zone. I know just about nothing about nls parameters, time
> zones, etc. If we switch over to the stand-by copy its timestamp will be
> off by many hours (records will get inserted based on the local time).
> When we switch back any sorting on the timestamp fields will be out of
> order. Is there a parameter I can set at the database level to keep the
> timestamps in order when we switch back and forth?
> >
> >
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
>
>
>
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Fri Dec 18 2015 - 15:15:13 CET