Shulou(Shulou.com)06/01 Report--

1. Introduction of RAC One Node

1. Rac one node database can be converted into RAC database, and the conversion process can be online without stopping the RAC one node database.

2. Rac one node can create multiple rac onde node databases and run on different nodes.

3. When the running node needs maintenance, such as patch, you can relocate and use online database relocate to reduce business interruption time.

4. Compared with RAC database, rac one node reduces the data transfer time between nodes and the waiting events of GC class.

5. Rac one node features have been available since 11.2.0.1, but only the linux platform is supported. All platforms are supported after 11.2.0.2.

Reference document: Oracle RACOne Node-Changes in 11.2.0.2 (document ID 1232802.1)?

Use DBCA to create RAC One Node

[oracle@jzh2 ~] $dbca

2.1 Select "Oracle RAC One Node database"

Later, the creation of the database is basically the same as that of the RAC database, and the process is omitted.

2.2.The basic information of RAC one database

$srvctl config database-d jzh

Database unique name: jzh

Database name: jzh

Oracle home: / u01/app/oracle/product/11.2.0/db_1

Oracle user: oracle

Spfile: + DATA/jzh/spfilejzh.ora

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: jzh

Database instances:

Disk Groups: DATA,ARCH

Mount point paths:

Services: jzhdb= "newly created Service

Type: RACOneNode= "database type is one node

Online relocation timeout: 30

Instance name prefix: jzh

Candidate servers: jzh2,jzh3

Database is administrator managed

2.3. Database configuration information

SQL > show parameter name

NAME TYPE VALUE

-

Db_file_name_convert string

Db_name string jzh

Db_unique_name string jzh

Global_names boolean FALSE

The "instance_name string jzh_1=" instance name, which is generally jzh2 in the RAC database, but with "_" in the RAC One Node.

Lock_name_space string

Log_file_name_convert string

Processor_group_name string

Service_names string jzhdb

2.4. Cluster information

SQL > show parameter cluster_database

NAME TYPE VALUE

-

Cluster_database boolean TRUE

Cluster_database_instances integer 2

2.5, RAC One Node handoff (relocate)

Query the operation of the current instance:

$crsctl stat res-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.ARCH.dg

ONLINE ONLINE jzh2

ONLINE ONLINE jzh3

Ora.DATA.dg

ONLINE ONLINE jzh2

ONLINE ONLINE jzh3

Ora.LISTENER.lsnr

ONLINE ONLINE jzh2

ONLINE ONLINE jzh3

Ora.VOTE.dg

ONLINE ONLINE jzh2

ONLINE ONLINE jzh3

Ora.asm

ONLINE ONLINE jzh2 Started

ONLINE ONLINE jzh3 Started

Ora.gsd

OFFLINE OFFLINE jzh2

OFFLINE OFFLINE jzh3

Ora.net1.network

ONLINE ONLINE jzh2

ONLINE ONLINE jzh3

Ora.ons

ONLINE ONLINE jzh2

ONLINE ONLINE jzh3

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE jzh3

Ora.cvu

1 OFFLINE OFFLINE

Ora.jzh.db

1 ONLINE ONLINE jzh2 Open

Ora.jzh.jzhdb.svc

1 ONLINE ONLINE jzh2

Ora.jzh2.vip

1 ONLINE ONLINE jzh2

Ora.jzh3.vip

1 ONLINE ONLINE jzh3

Ora.oc4j

1 ONLINE ONLINE jzh3

Ora.scan1.vip

1 ONLINE ONLINE jzh3

Both the database and service run on node 1 (jzh2)

2.6.Use relocate to cut the RAC One Node database to node 2 (jzh3)

$srvctl relocate database-d jzh-n jzh3

After relocate, query the operation of RAC One Node again:

$crsctl stat res-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.ARCH.dg

ONLINE ONLINE jzh2

ONLINE ONLINE jzh3

Ora.DATA.dg

ONLINE ONLINE jzh2

ONLINE ONLINE jzh3

Ora.LISTENER.lsnr

ONLINE ONLINE jzh2

ONLINE ONLINE jzh3

Ora.VOTE.dg

ONLINE ONLINE jzh2

ONLINE ONLINE jzh3

Ora.asm

ONLINE ONLINE jzh2 Started

ONLINE ONLINE jzh3 Started

Ora.gsd

OFFLINE OFFLINE jzh2

OFFLINE OFFLINE jzh3

Ora.net1.network

ONLINE ONLINE jzh2

ONLINE ONLINE jzh3

Ora.ons

ONLINE ONLINE jzh2

ONLINE ONLINE jzh3

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE jzh3

Ora.cvu

1 OFFLINE OFFLINE

Ora.jzh.db

2 ONLINE ONLINE jzh3 Open

Ora.jzh.jzhdb.svc

1 ONLINE ONLINE jzh3

Ora.jzh2.vip

1 ONLINE ONLINE jzh2

Ora.jzh3.vip

1 ONLINE ONLINE jzh3

Ora.oc4j

1 ONLINE ONLINE jzh3

Ora.scan1.vip

1 ONLINE ONLINE jzh3

At this point, the database and service switch to node 2 (jzh3).

2.7. View database configuration information

[grid@jzh2] $srvctl config service-d jzh

Service name: jzhdb

Service is enabled

Server pool: jzh

Cardinality: 1

Disconnect: false

Service role: PRIMARY

Management policy: AUTOMATIC

DTP transaction: false

AQ HA notifications: false

Failover type: NONE

Failover method: NONE

TAF failover retries: 0

TAF failover delay: 0

Connection Load Balancing Goal: LONG

Runtime Load Balancing Goal: NONE

TAF policy specification: BASIC

Edition:

Preferred instances: jzh_2

Available instances:

2.8convert RAC One Node to RAC

Note: execute the following command as the RAC One Node database owner:

$su-oracle

$srvctl convert database-d jzh-c RAC-n jzh2

$srvctl config database-d jzh

Database unique name: jzh

Database name: jzh

Oracle home: / u01/app/oracle/product/11.2.0/db_1

Oracle user: oracle

Spfile: + DATA/jzh/spfilejzh.ora

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: jzh

Database instances: jzh_1

Disk Groups: DATA,ARCH

Mount point paths:

Services: jzhdb

Type: RAC

Database is administrator managed

We can see that the Type type becomes RAC.

2.9. add Node 2 (jzh3) instance

$srvctl add instance-d jzh-I jzh_2-n jzh3

$srvctl config database-d jzh

Database unique name: jzh

Database name: jzh

Oracle home: / u01/app/oracle/product/11.2.0/db_1

Oracle user: oracle

Spfile: + DATA/jzh/spfilejzh.ora

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: jzh

Database instances: jzh_1,jzh_2

Disk Groups: DATA,ARCH

Mount point paths:

Services: jzhdb

Type: RAC

Database is administrator managed

Here we see the addition of jzh_2.

$srvctl start database-d jzh

$crsctl stat res-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.ARCH.dg

ONLINE ONLINE jzh2

ONLINE ONLINE jzh3

Ora.DATA.dg

ONLINE ONLINE jzh2

ONLINE ONLINE jzh3

Ora.LISTENER.lsnr

ONLINE ONLINE jzh2

ONLINE ONLINE jzh3

Ora.VOTE.dg

ONLINE ONLINE jzh2

ONLINE ONLINE jzh3

Ora.asm

ONLINE ONLINE jzh2 Started

ONLINE ONLINE jzh3 Started

Ora.gsd

OFFLINE OFFLINE jzh2

OFFLINE OFFLINE jzh3

Ora.net1.network

ONLINE ONLINE jzh2

ONLINE ONLINE jzh3

Ora.ons

ONLINE ONLINE jzh2

ONLINE ONLINE jzh3

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE jzh3

Ora.cvu

1 OFFLINE OFFLINE

Ora.jzh.db

1 ONLINE ONLINE jzh2 Open

2 ONLINE ONLINE jzh3 Open

Ora.jzh.jzhdb.svc

1 ONLINE ONLINE jzh2

Ora.jzh2.vip

1 ONLINE ONLINE jzh2

Ora.jzh3.vip

1 ONLINE ONLINE jzh3

Ora.oc4j

1 ONLINE ONLINE jzh3

Ora.scan1.vip

1 ONLINE ONLINE jzh3

Here you can see that DB is running on jzh2,jzh3.

2.10. Reconfigure the service

$srvctl stop service-d jzh-s jzhdb

$srvctl remove service-d jzh-s jzhdb

$srvctl add service-d jzh-s jzhdb-r jzh_1,jzh_2-P BASIC

$srvctl start service-d jzh-s jzhdb

At this point, the RAC One Node configuration is complete!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.