Sitemap

Amicuk Programming Answers

Standby atabase in different time zone than Primary databse

-0001-11-30   Views:3

Advertisement

I am curious to know, If my primary database is in NY and I am planning to have my DR in London. Is this configuration possible by having primary and standby host box having different time(as their time zones) I am thinking issues about how oracle wi

I am curious to know, If my primary database is in NY and I am planning to have my DR in London.
Is this configuration possible by having primary and standby host box having different time(as their time zones) I am thinking issues about how oracle will cordinate shipment of archive logs which are in different time zones.
I know one way to configure it....
even If box is in London, Box will be having time of NY timezone on host..

The replay answer
Advertisement
I would expect, though, without having had a chance to test it, that you might run into problems using various time-based DataGuard configurations and settings. For example, if you configured your standby to wait X minutes before applying logs from the production server, I would tend to suspect that you'd have issues.
In the event of a failover, you might also have application-level issues related to "duplicate" dates. If your application runs continuously across daylight savings time switches, you're probably fine, but a lot of apps aren't doing anything in that one hour a year that the clocks fall back an hour and discover that they're not quite as bulletproof as they'd expect.
Justin

Go to See the other 3 answers

Standby atabase in different time zone than Primary databse

Category:DefaultRelease time:-0001-11-30Views:130

I am curious to know, If my primary database is in NY and I am planning to have my DR in London. Is this configuration possible by having primary and standby host box having different time(as their time zones) I am thinking issues about how oracle wi[More]

Creating Standby From RMAN Compressed backup taken on Primary ....

Category:DefaultRelease time:-0001-11-30Views:130

I am creating a Standby from RMAN Compressed backup taken on Primary. On Primary, I have taken Compressed backup as follows: RMAN> run allocate channel c1 type disk; allocate channel c2 type disk; allocate channel c3 type disk; BACKUP AS COMPRESSED B[More]

Standby not in sync because test on primary of transportable tablespace etc

Category:DefaultRelease time:2015-10-11Views:130

This environment is new build environment , have not in use yet. db version is 11.2.0.3 in linux, both primary/standby are configured in RAC two nodes and storage are in ASM storage. primary db had tested by migration data using transportable tablesp[More]

Standby server time zone - sync-up with primary

Category:DefaultRelease time:-0001-11-30Views:130

As we are running our database with physical standby database - Oracle 10.2.0.3, O/S RHEL4 ES now the primary database server time zone is set to EST Time Zone and Standby database server is set to PST time Zone We would need to Sync-up standby time[More]

Logical standby and Primary keys

Category:DefaultRelease time:2015-10-11Views:130

Hi All, Why primary keys are essential for creating logical standby database? I have created a logical standby database on testing basis without having primary keys on most of the tables and it's working fine. I have not event put my main DB in force[More]

Not able to get data of primary in standby database (configured dataguard)

Category:DefaultRelease time:2015-10-11Views:130

Hi all, I configured dataguard in my local system, i ve a few qsns (as i am new, ve patience) 1) scn differs wrt primary in standby (i checked, 1day difference), how to make scn same? 2)i created a table in primary, its not refelecting in standby, (b[More]

Switching between Primary and Standby database

Category:DefaultRelease time:2015-10-11Views:130

Hi, I managed to setup a standby database that is updated by the primary db either when doing a log file switch or when changing the role of the primary db to standby. Now I want to put the standby database (that was in primary role for a short perio[More]

Restored standby database from primary; now no logs are shipped

Category:DefaultRelease time:2015-10-11Views:130

Hi We recently had a major network/SAN issue and had to restore our standby database from a backup of the primary. To do this, we restored the database to the standby, created a standby controlfile on the primary, copied this across to the control fi[More]

Where is STANDBY and PRIMARY

Category:DefaultRelease time:2015-10-11Views:130

Hi, in 10g R2 , dataguard on unix HP when connected to standby ,how can we find where is primary server ? or : when connected to primary ,how can we find where is standby server ? Thank you.from the primary; look athe parameter log_archive_dest_x you[More]

Dataguard Config - Primary ASM - Standby Non ASM

Category:DefaultRelease time:2015-10-11Views:130

Hi, I'm having an issue with a new configuration of dataguard. Primary Standby OS Win2008 R2 Win2008 R2 DB 11.2.0.2 11.2.0.2 Storage ASM NTFS I have created standby logs on the standby and on the primary. I have configured real time apply(maximum ava[More]

Require 9i Primary and Standby redo logs files same size?

Category:DefaultRelease time:2015-10-11Views:130

Hi, We have 9.2.0.6 Oracle RAC (2 node) and configured data guard (physical standby). I want to increase redo log files size, but i can't this do same time primary and standby side. Is there a rule, primary and standby database instances have same si[More]

Hot
I have an iPhone 4 with iOS5 whilst my old iPod Touch Mk1 still runs on iOS3. My old iPod now rests in the handbag of my wife who will use the installed apps if she is near a wifi she can use. There is however an increasing problem in that wheras it [More]
Hello, I am experiencing some difficulties on skype using with my iphone. My problem is that whenever I use skype to make phone calls on my iphone, it always quits the skype and goes to the iphone home page when I type more than 6 digits. I can't eve [More]
We're trying to set up a SAML integration with our Flex/BlazeDS app.  It is not going well.  By not going well I mean we can't figure out how to get the @#%@# thing to work.  We're very experienced with Flex, REST, SOAP, etc. but SAML is something we [More]
Help! I'm at my wits end! I installed BIP 11g on Linux and went through the security set up for eBusiness Suite - created the XMLP% responsibilities, assigned the responsibilities to users, shutdown the BIP server, restarted it with the expectation t [More]
I have a JTable in which selecting a new row which represents a single item, should cause other rows to be dynamically added and removed. These other rows represent details of the selected item. Only one item can be selected at a time, and subsequent [More]
Hi I attached my TIME.VI. another vi is sub vi. Sub vi is read real time using second unit. I just try to read time for acquiring data. When I pressed acquire data button, I hope time can begin from 0 then written in file. Right now , my program is n [More]
I would like to copy the bookmarks on my desktop to my galaxy s4I had a similar problem and tried Sync. It didn't help much. So I experimented. This works pc to phone, I don't know the other direction. 1. On your desktop computer save all your bookma [More]
I'm trying to learn Flash by using the Adobe Flash "Classroom in a Book" and I'm stumped. The book is telling me to draw two overlapping rectangles for masking but every time that I do it doesn't come out right. If I use only one, things are fin [More]
1)In a layout am having a text say "posisdvnsdb" in dutch language i know the form name print prog name and the window name. how can i find whether it is hardcoded or getting the text from print program by looking at the script editor solution r [More]
I upgraded to Mavericks, MacBook Air. I need help sorting out what is going on with Tags. I have a screen shot, but uploading it to this post is another problem I have run into with Mavericks.  I click on the camera icon, click on upload file, and th [More]