Home
Topics
Oracle database administration
Oracle database availability
Using RAC/Data Guard with third-party application

Ask the Expert

Using RAC/Data Guard with third-party application

We have a third-party application which is not RAC-enabled. My understanding is that we can still use RAC, or Data Guard since this is Oracle 10g, on the database itself and do a manual failover on the application. Is this true? Also, if we have 10g SE, can we just use a standby database to accomplish almost the same high availability that Data Guard offers?

Requires Free Membership to View

Login

By submitting you agree to receive email communications from
TechTarget and its partners. Privacy Policy Terms of Use.

Yes, if I understand your question correctly, you can still use RAC and direct all of your connections to one instance through the client TNS configuration, then manually reconfigure the application to connect to the surviving node in event of failover.

I've seen some people accomplish this by configuring the two-node cluster and leaving one side down, in effect running with a failed node as normal operations. However, I suspect by not being "RAC-enabled" your application uses some sort of connection pooling at startup that may require a restart of the application anyway when failing over from one node to another.

Also, you are correct that 10g SE does not come with the Data Guard option, but you can manually simulate this by copying your archive logs to the standby destination and issuing a "recover automatic standby database" command to apply them. Besides having to script this and closely monitor the process, you will lose the graceful switchover flexibility and have to rebuild your standby database again after activation.

Good luck.

Bill

More News and Tutorials

Articles

This was first published in October 2006

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

Data Management
Business Analytics
SAP
SQL Server
Java
Data Center
Content Management
Financial Applications

Data Management
- Events report: Information Builders Summit 2013, graph databases and more
  
  SearchDataManagement editors discuss the Information Builders user conference and two other events; topics include graph databases and 'data artists.'
- From 4GLs to HTML5 desktop apps: Bringing data to the masses
  
  Advocating wider access to data, speakers at the Information Builders Summit 2013 traced a journey from 4GL tools to HTML5 desktop apps and beyond.
- Enterprise data quality efforts in good company with MDM, governance
  
  Combining data quality initiatives with master data management and data governance programs can help ensure that data remains accurate and consistent.
Business Analytics
- No more shortcuts: Sound data quality strategy a must for BI success
  
  In the past, companies might have gotten away with not building data quality efforts into business intelligence programs. That's less likely now.
- Member Exclusive Downloads
  
  Member Exclusive Downloads from SearchBusinessAnalytics
- In-memory applications take on big data analytics challenge
  
  In-memory tools and big data can be a potent analytics mix. But before you put them together, read advice from experienced users and consultants.
SAP
- Food bank network delivers with SAP mobility
  
  The nation's largest network of food banks is cutting out labor-intensive paper-bound processes with the help of SAP mobile technology.
- SAP adds hybris to its SAP CRM tool set: More choices, or confusion?
  
  One expert calls SAP's purchase of hybris long overdue. Another wonders if SAP is confusing its own SAP CRM customers.
- Limit returns, SAP procurement expenses with a stability study
  
  Stability studies, which measure how different materials respond to various conditions, can save companies huge amounts of money, writes Jawad Akhtar.
SQL Server
- SQL Server 2014 'keeps up with the Joneses,' says analyst
  
  Ovum analyst Tony Baer says that most database platforms are moving toward in-memory features, and SQL Server 2014 is no different.
- SQL Server high availability: Natural enemy of virtualization?
  
  Do SQL Server high availability and virtualization go together or not? Find out if virtualization is a good option for you in this tip by Bob Sheldon.
- SQL Server 2014 due out in late 2013, in-memory OLTP a big feature
  
  Microsoft announced that the next version of its database, SQL Server 2014, will have in-memory features and be generally available in late 2013.
Java
- CamelOne 2013: Lockheed engineers explain Java and C++ messaging
  
  At CamelOne 2013, software engineers from Lockheed Martin explain how they use Camel with C++ for a flight scheduling app.
- Will the Red Hat model work for IaaS cloud computing with OpenStack?
  
  The Red Hat transition is to move their successful model to IaaS through OpenStack and cloud computing. But will this new move from the JBoss company work as well as RHEL did a decade ago?
- How Red Hat's Linux and OpenStack IaaS drives Intel's bottom line
  
  While a major protectorate of intellectual property, Red Hat Linux and OpenStack IaaS offerings provide the bonus of driving innovation, which leads to more chips being purchased, driving revenue at Intel's bottom line.
Data Center
- Battery monitoring service prevents outages, extends battery life
  
  The latest backup battery monitoring services can prevent outages and extend battery life. Plus, they take power monitoring off IT's task list.
- Red Hat Open Hybrid Cloud aids private, public cloud management
  
  Hardware, virtualization, public and private cloud are all converging and need to be managed as one environment. Enter Red Hat's Open Hybrid Cloud.
- Mainframe modernization takes on urgency
  
  A Red Hat Summit talk on database and mainframe modernization highlights urgency, need for agility in enterprise development teams.
Content Management
- Records management program aims to restore order to SharePoint system
  
  Mobile network operator Telenor Group is adopting information governance and records management standards to better control internal SharePoint use.
- Cloud collaboration software connects at networking company Enterasys
  
  Enterasys Networks ended up with more users than expected when it deployed a cloud-based collaboration system. But that turned out to be a good thing.
- Data value chain puts the focus on what matters most to a business
  
  In his career running data management systems for consumer goods companies, Richard Beaver has found a formula for success: the data value chain.
Financial Applications
- Fight fraud, fog and waste when processing business travel expenses
  
  Problems with business travel expenses have CFOs re-examining their processes for reimbursement, disbursement and audits.
- CFOs reap the benefits of BPM tools in efficiency, compliance
  
  BPM tools can help CFOs reduce errors and enhance the accuracy of reporting and forecasting, experts say.
- CFOs can seize opportunity to lead good governance over IT
  
  Get tips from experts on how to enact good IT governance by getting the right people to do the right processes.

All Rights Reserved,Copyright 2003 - 2013, TechTarget