Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about how 12c operates the conversion between rac and rac one node in the cluster. Many people may not know much about it. In order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

-- first stop the instance of No.2 node in the cluster

[oracle@host01 app] $srvctl stop instance-d racdb-I racdb_2

-- check the type of rac, which is currently displayed as (Type: RAC)

[oracle@host01 app] $srvctl config database-d racdb

Database unique name: racdb

Database name: racdb

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

Oracle user: oracle

Spfile: + DATA/RACDB/PARAMETERFILE/spfile.288.960026421

Password file: + DATA/RACDB/PASSWORD/pwdracdb.276.960026013

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: racdbpool

Disk Groups: FRA,DATA

Mount point paths:

Services: RACDBACN

Type: RAC

Start concurrency:

Stop concurrency:

OSDBA group: dba

OSOPER group: oper

Database instances:

Configured nodes:

Database is policy managed

-- convert to rac one node type

[oracle@host01 app] $srvctl convert database-d racdb-c RACONENODE

-- check the type of rac again, which displays (Type: RACOneNode)

[oracle@host01 app] $srvctl config database-d racdb

Database unique name: racdb

Database name: racdb

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

Oracle user: oracle

Spfile: + DATA/RACDB/PARAMETERFILE/spfile.288.960026421

Password file: + DATA/RACDB/PASSWORD/pwdracdb.276.960026013

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: racdbpool

Disk Groups: FRA,DATA

Mount point paths:

Services: RACDBACN

Type: RACOneNode

Online relocation timeout: 30

Instance name prefix: racdb

Candidate servers:

OSDBA group: dba

OSOPER group: oper

Database instances:

Database is policy managed

-- try to convert back to rac type again

[oracle@host01 app] $srvctl convert database-d racdb-c RAC

-- check the type of rac, which has become rac, and the instances on both nodes have been picked up

[oracle@host01 app] $srvctl config database-d racdb

Database unique name: racdb

Database name: racdb

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

Oracle user: oracle

Spfile: + DATA/RACDB/PARAMETERFILE/spfile.288.960026421

Password file: + DATA/RACDB/PASSWORD/pwdracdb.276.960026013

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: racdbpool

Disk Groups: FRA,DATA

Mount point paths:

Services: RACDBACN

Type: RAC

Start concurrency:

Stop concurrency:

OSDBA group: dba

OSOPER group: oper

Database instances:

Configured nodes:

Database is policy managed

-- then switch back to rac one node

[oracle@host01 app] $srvctl convert database-d racdb-c RACONENODE

PRCD-1154: Failed to convert the configuration of cluster database racdb into its equivalent RAC One Node database configuration because cluster database is running on more than one server [host02, host01]

-- prompt that there are two nodes running. Turn off Node 2.

[oracle@host01 app] $srvctl stop instance-d racdb-I racdb_2

PRCD-1315: failed to stop instances for database racdb

PRCR-1014: Failed to stop resource ora.racdb.db

PRCR-1065: Failed to stop resource ora.racdb.db

CRS-2529: Unable to act on 'ora.racdb.db' because that would require stopping or relocating' ora.racdb.racserv.svc', but the force option was not specified

-- prompt to close the service of racserv before shutting down Node 2 instance

[oracle@host01 app] $srvctl stop service-d RACDB-s racserv

-- close the instance again

[oracle@host01 app] $srvctl stop instance-d racdb-I racdb_2

-- convert rac to rac one node

[oracle@host01 app] $srvctl convert database-d racdb-c RACONENODE

-- check the status. The transition is successful.

[oracle@host01 app] $srvctl config database-d racdb

Database unique name: racdb

Database name: racdb

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

Oracle user: oracle

Spfile: + DATA/RACDB/PARAMETERFILE/spfile.288.960026421

Password file: + DATA/RACDB/PASSWORD/pwdracdb.276.960026013

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: racdbpool

Disk Groups: FRA,DATA

Mount point paths:

Services: RACDBACN

Type: RACOneNode

Online relocation timeout: 30

Instance name prefix: racdb

Candidate servers:

OSDBA group: dba

OSOPER group: oper

Database instances:

Database is policy managed

After reading the above, do you have any further understanding of how 12c converts rac to rac one node in the cluster? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

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.