Re: time stamps with Data Guard

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Fri, 18 Dec 2015 07:06:12 -0600
Message-Id: <5AF2885F-5384-4A82-B298-E50F1139BD26_at_gmail.com>

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
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 18 2015 - 14:06:12 CET