Q
Problem solve Get help with specific problems with your technologies, process and projects.

Installing a database on two servers

Can I install the DB on two servers? I want the application to update the DB in both servers. The reason I want to do this is in case one server goes down, I have the other one to use.

Can I install the DB on two servers? I want the application to update the DB in both servers. The reason I want to do this is in case one server goes down, I have the other one to use.
If you are using Oracle Enterprise Edition, you might want to investigate Data Guard for a function such as this. Data Guard (which used to be called Oracle Standby) provides a number of options to keep additional databases synchronized with the primary production database. If the production database becomes unavailable, you can switch to one of the standby databases with very little downtime.

If you are not using Enterprise Edition, this can be accomplished in a more "manual" fashion but with more effort. The second database remains in recovery mode and logs are applied to this instance until it is needed. If the primary database fails, you can switch over to the secondary database. As mentioned, this approach requires more intervention and management, whereas Data Guard handles most of this for you.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close