Walkthrough: Setting up Oracle RAC One Node
This walkthrough describes how to start using BMC Database Automation (BDA). It contains the following sections:
Beginning with BDA 8.7, you can create a RAC One Node database on all the nodes that are part of a cluster. One advantage of this feature is that, for a planned migration, a RAC One Node environment works effectively because it enables you to continue work without impacting the business by relocating the instance from one node to another while moving the sessions along with it.
Deviations from other database types
Introduced in Oracle version 188.8.131.52 databases, Oracle RAC One Node differs from an Oracle RAC database in that a full RAC database operates as an Active-Active solution where all the nodes in the cluster are active and can accept connections as a single unit. RAC One Node, on the other hand, works as an Active-Passive solution where only one node can be active at a time, and the other nodes are available to accept the workload in the case of a planned or an unplanned downtime related to the first node.
Most of the properties of the RAC One Database are similar to those of a typical RAC database. One of the differences is the ability to configure candidate servers, which are nodes on which you can relocate a RAC One Node database. Only during a planned online database relocation is a second instance of an Oracle RAC One Node database created, so that any database sessions can continue while the database is relocated to a new node.
As the following walkthrough demonstrates, BDA does not require you to add RAC One Node databases using a new wizard. In the GUI, the existing wizard can be used and you can choose RAC One Node as the database type on the Configuration page of the same wizard.
The following table details terms and definitions related to Oracle RAC One Node.
|Oracle RAC||A database clustering solution that allows more than one instance to mount and open an Oracle database|
|RAC One Node Database||A single instance of an Oracle RAC-enabled database running on one node in a cluster|
|A set of memory structures and background processes that manage an Oracle database|
Before you get started
This example assumes that you have performed all of the steps outlined in the following table:
|Plan your deployment.||Planning all aspects of your deployment, including system requirements and security, ensures a successful implementation. When planning access control, note that RAC One Node capabilities have been mapped to existing Oracle capabilities, and no new ones are required.|
|Download the installation files, including the Additional Utilities folder.||The installation program for the latest service pack or patch also includes the full installation of the product. To install the product for the first time or apply product updates, select the Additional Products tab and download the latest service pack or patch. You can find the latest information about service packs and patches under Release notes.|
|Carefully review the system requirements for your platform and other tasks necessary for preparing for installation.||You must perform these tasks before you launch the installation program.|
If you are performing a first-time installation, see Performing the installation.
If you are installing a service pack or patches, see Applying maintenance, patches, or fixes.
Download the ORA-Relocate-RON-DB Action and import it into your Action Repository.
|The ORA-Relocate-RON-DB Action is used to relocate the active instance of a RAC One Node database to an available candidate server. The Action can be downloaded from a BDA ZipKit available on the BDA Community at https://communities.bmc.com/docs/DOC-36130.|
How to set up for RAC One Node
- For this walkthrough, you log on as a BDA Administrator.
- In this example an Oracle Cluster Ready Services (CRS) cluster is running and currently managed by BDA, and the node meets all of the Oracle database prerequisites.
Add a database to an Oracle cluster.
Add a candidate server to the database.
Relocate the database active instance.
Where to go from here
For additional details of the procedures demonstrated in this walkthrough, including explicit details of the options in each wizard page, see the following topics: