Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 3rd, 2009, 10:26 AM
Registered User
Join Date: Mar 2009
Posts: 2
Thanks: 1
Thanked 0 Times in 0 Posts
Default High database availability solution

Please I need a solution in this my chalange. I have my database server (A) running in my office. I have a backup database sever (B) somewhere else. My challange is how to swicth to the backup server (B) when my main database sever (A) goes down. Also this swict has to be down in a small time frame.
Old March 5th, 2009, 05:19 AM
Authorized User
Join Date: Nov 2006
Posts: 31
Thanks: 0
Thanked 3 Times in 3 Posts
Send a message via ICQ to debasisdas Send a message via AIM to debasisdas

That depends on how your servers are configured.

You might need to do all that manually.
Old March 6th, 2009, 05:43 AM
Friend of Wrox
Join Date: May 2005
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default High database availability solution

Prolifik4life: Your challenge is rather vague. What happens when you have a schedule outage, i.e. take the system down to upgrade Oracle.? There should already exist a Backup/Restore Procedure as part of ones Business Continuity Plan and/or Disaster Recovery Plan. When you say the Backup server (B) is external to your office, does that mean in the same building, on the same network or external to the facility? Is server B used as a virtual server or mirror image of Server A? What do you do when you have to change the Oracle DB Password? Upgrades and password changes are scheduled outages that includes testing the Oracle DB once restored by testng all applications effected.

Hope this helps.
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.
The Following User Says Thank You to peace95 For This Useful Post:
Prolifik4life (March 6th, 2009)

Similar Threads
Thread Thread Starter Forum Replies Last Post
Check availability limpep Excel VBA 0 March 2nd, 2007 07:46 PM
How to check Domain Name Availability itHighway Classic ASP Databases 4 October 13th, 2005 01:33 AM
Availability of VS.NET 2005 boksi General .NET 7 April 7th, 2005 07:32 PM
Professional JSP availability dhanda_2000 Wrox Book Feedback 5 January 14th, 2005 01:26 PM
Non availability of code at the site pankajrv All Other Wrox Books 4 March 7th, 2004 06:38 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.