Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Have oracle RAC production system. Two nodes in the primary, two nodes in the secondary. Getting a test system.Can we have two nodes in the primary and one in the secondary? Or to put it another way - can you have a one node cluster in standard oracle RAC?

share|improve this question

migrated from stackoverflow.com Sep 21 '11 at 6:47

This question came from our site for professional and enthusiast programmers.

From the documentation:

Oracle RAC One Node is a new option available with Oracle Database 11g Release 2. Oracle RAC One Node is a single instance of an Oracle RAC enabled database running on one node in a cluster. This option adds to the flexibility that Oracle offers for database consolidation while reducing management overhead by providing a standard deployment for Oracle Databases in the enterprise.

This is a means to have a multi-node RAC, one which one database can only run on one node at a time, so it allows you to (more cheaply) use RAC for active-passive clustering, which saves on having both RAC and another clustering product such as VCS. Or are you asking if it is possible to have a RAC system entirely on one physical host, running Clusterware, ASM, etc and a database? Yep, that is possible too, the standard installer can do this for you.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.