time stamps with Data Guard

  • From: "Terrian, Thomas J DLA CTR INFORMATION OPERATIONS" <Tom.Terrian.ctr@xxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 18 Dec 2015 12:29:14 +0000

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?



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


Other related posts: