RAC One Node Database--11.2.0.2

Oracle Real Application Clusters One Node (Oracle RAC One Node) is a single instance of an Oracle Real Application Clusters (Oracle RAC) database that runs on one node in a cluster.


 Major Changes in 11.2.0.2 database version:

 1)OUI has a new option to select RAC One Installation.
 2)DBCA is now capable of configuring RAC One database.
  SRVCTL is capable of configuring and administering RAC One database. (In 11.2.0.1 this was  performed using scripts like "Omotion”, “raconestatus” etc).
 3)DBUA is RAC One aware.

 Administrating a RAC One Database:

Verifying an existing RAC One database:
 
*racnode1*<oracle:racone>:/home/oracle=>srvctl config database -d racone
Database unique name: racone
Database name: racone
Oracle home: /u01/app/oracle/product/11.2.0.2/db_1
Oracle user: oracle
Spfile: +DATA01/racone/spfileracone.ora
Domain: ukatru.com
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racone
Database instances:
Disk Groups: DATA01
Mount point paths: /u01/app/oracle
Services: onedv.ukatru.com
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: racone
Candidate servers: racnode1,racnode2
Database is administrator managed
*racnode1*<oracle:racone>:/home/oracle=>srvctl status database -d racone
Instance racone_1 is running on node racnode1
Online relocation: INACTIVE

*racnode1*<oracle:racone>:/home/oracle=>srvctl status database -d racone
Instance racone_1 is running on node racnode1
Online relocation: INACTIVE

Step1)Performing relocation: 


*racnode1*<oracle:racone>:/home/oracle=>srvctl relocate database -h

Initiate online relocation of the RAC One Node database.

Usage: srvctl relocate database -d <db_unique_name> {[-n <target>] [-w <timeout>] | -a [-r]} [-v]
    -d <db_unique_name>      Unique name of database to relocate
    -n <target>              Target node to which to relocate database
    -w <timeout>             Online relocation timeout in minutes
    -a                       Abort failed online relocation
    -r                       Remove target node of failed online relocation request from the candidate server list of administrator-managed RAC One Node database
    -v                       Verbose output
    -h                       Print usage


*racnode1*<oracle:racone>:/home/oracle=>srvctl relocate database -d racone -n racnode2

Status during Relocation:

*racnode1*<oracle:racone>:/home/oracle=>srvctl status database -d racone
Instance racone_1 is running on node racnode1
Instance racone_2 is running on node racnode2
Online relocation: ACTIVE
Source instance: racone_1 on racnode1
Destination instance: racone_2 on racnode2


Once the migration is completed, we should see the sessions moved to the remote instance.

*racnode1*<oracle:racone>:/home/oracle=>srvctl status database -d racone
Instance racone_2 is running on node racnode2
Online relocation: INACTIVE


Step2:)Converting a RAC One database to RAC or vice versa

Example commands : 


srvctl convert database -d <db_unique_name> -c RAC [-n <node>]


srvctl convert database -d racone -c RAC -n racnode1

To convert a database from RAC to RACOne:

command: srvctl convert database -d <db_unique_name> -c RACONENODE -i <inst prefix> -w <timeout>

Eg:  srvctl convert database -d racone -c RACONENODE -w 30 -i racone