Home > oracle-install > RAC One Node Database–11.2.0.2

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

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

Step1)Performing relocation: 


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

Initiate online relocation of the RAC One Node database.

Usage: srvctl relocate database -d {[-n ] [-w ] | -a [-r]} [-v]
    -d       Unique name of database to relocate
    -n               Target node to which to relocate database
    -w              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*:/home/oracle=>srvctl relocate database -d racone -n racnode2


Status during Relocation:



*racnode1*:/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*:/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 -c RAC [-n ]


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

To convert a database from RAC to RACOne:

command: srvctl convert database -d -c RACONENODE -i -w

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







Advertisements
Categories: oracle-install
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: