Sign up ×
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.

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 Sep 21 '11 at 6:47

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

1 Answer 1

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


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