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

This article mainly shows you "what are the basic start and stop commands in the daily operation of RAC". The content is simple and clear. I hope it can help you solve your doubts. Let me lead you to study and learn this article "what are the basic start and stop commands in the daily operation of RAC?"

Summary of some basic start and stop commands in the daily operation of RAC

Set cluster not to start automatically with the operating system

[root@rac01 u01] # crsctl disable crs

CRS-4621: Oracle High Availability Services autostart is disabled.

Set cluster to start automatically with the operating system. It starts by default.

[root@rac01 u01] # crsctl enable crs

CRS-4622: Oracle High Availability Services autostart is enabled.

Start cluster, and each node executes

[root@rac01 u01] # crsctl start crs

CRS-4123: Oracle High Availability Services has been started.

[root@rac02 u01] # crsctl start crs

CRS-4123: Oracle High Availability Services has been started.

View the status of cluster resources, which can be viewed on both nodes.

[root@rac01 U01] # crsctl status resource-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.DATA.dg

OFFLINE OFFLINE rac01

OFFLINE OFFLINE rac02

Ora.LISTENER.lsnr

ONLINE ONLINE rac01

ONLINE ONLINE rac02

Ora.OCR.dg

ONLINE ONLINE rac01

ONLINE ONLINE rac02

Ora.asm

ONLINE ONLINE rac01 Started

ONLINE ONLINE rac02 Started

Ora.eons

ONLINE ONLINE rac01

ONLINE ONLINE rac02

Ora.gsd

OFFLINE OFFLINE rac01

OFFLINE OFFLINE rac02

Ora.net1.network

ONLINE ONLINE rac01

ONLINE ONLINE rac02

Ora.ons

ONLINE ONLINE rac01

ONLINE ONLINE rac02

Ora.registry.acfs

ONLINE ONLINE rac01

ONLINE ONLINE rac02

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE rac01

Ora.oc4j

1 ONLINE ONLINE rac01

Ora.rac01.vip

1 ONLINE ONLINE rac01

Ora.rac02.vip

1 ONLINE ONLINE rac02

Ora.sap.db

1 OFFLINE OFFLINE

2 OFFLINE OFFLINE

Ora.scan1.vip

1 ONLINE ONLINE rac01

Start the database instance, whose name is sap, and execute it on one instance.

[root@rac01 U01] # srvctl start database-d sap

Check cluster resource status ora.sap.db status is open

[root@rac01 U01] # crsctl status resource-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.DATA.dg

ONLINE ONLINE rac01

ONLINE ONLINE rac02

Ora.LISTENER.lsnr

ONLINE ONLINE rac01

ONLINE ONLINE rac02

Ora.OCR.dg

ONLINE ONLINE rac01

ONLINE ONLINE rac02

Ora.asm

ONLINE ONLINE rac01 Started

ONLINE ONLINE rac02 Started

Ora.eons

ONLINE ONLINE rac01

ONLINE ONLINE rac02

Ora.gsd

OFFLINE OFFLINE rac01

OFFLINE OFFLINE rac02

Ora.net1.network

ONLINE ONLINE rac01

ONLINE ONLINE rac02

Ora.ons

ONLINE ONLINE rac01

ONLINE ONLINE rac02

Ora.registry.acfs

ONLINE ONLINE rac01

ONLINE ONLINE rac02

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE rac01

Ora.oc4j

1 ONLINE ONLINE rac01

Ora.rac01.vip

1 ONLINE ONLINE rac01

Ora.rac02.vip

1 ONLINE ONLINE rac02

Ora.sap.db

1 ONLINE ONLINE rac01 Open

2 ONLINE ONLINE rac02 Open

Ora.scan1.vip

1 ONLINE ONLINE rac01

View database instance status

[root@rac02 U01] # srvctl status database-d sap

Instance sap1 is running on node rac01

Instance sap2 is running on node rac02

View nodeapps resource status

[root@rac01 rac01] # srvctl status nodeapps

VIP rac01-vip is enabled

VIP rac01-vip is running on node: rac01

VIP rac02-vip is enabled

VIP rac02-vip is running on node: rac02

Network is enabled

Network is running on node: rac01

Network is running on node: rac02

GSD is disabled

GSD is not running on node: rac01

GSD is not running on node: rac02

ONS is enabled

ONS daemon is running on node: rac01

ONS daemon is running on node: rac02

EONS is enabled

EONS daemon is running on node: rac01

EONS daemon is running on node: rac02

View listener status

[root@rac01 rac01] # srvctl status listener

Listener LISTENER is enabled

Listener LISTENER is running on node (s): rac01,rac02

View ASM status

[root@rac01 rac01] # srvctl status asm

ASM is running on rac01,rac02

View scan status

[root@rac01 rac01] # srvctl status scan

SCAN VIP scan1 is enabled

SCAN VIP scan1 is running on node rac01

View ASM diskgroup status

[root@rac01 rac01] # srvctl status diskgroup

PRKO-2082: Missing mandatory option-g

[root@rac01 rac01] # srvctl status diskgroup-g data

Disk Group data is running on rac01,rac02

Stop a node of rac, such as rac02.

1. Stop the database instance first and use the following command

[root@rac01 rac01] # srvctl stop instance-d sap-n rac02-o immediate

You can also use the following command

[root@rac01 rac01] # srvctl stop instance-d sap-I sap2-o immediate

View voting disk

[root@rac01 rac01] # crsctl query css votedisk

# # STATE File Universal Id File Name Disk group

1. ONLINE aeeaa395bb2b4fe0bff37dd0eaafe2c1 (/ dev/disk/by-id/scsi-14f504e46494c4552667a507877412d6d616f452d63583051-part1) [OCR]

Located 1 voting disk (s).

View OCR

[root@rac01 rac01] # ocrcheck

Status of Oracle Cluster Registry is as follows:

Version: 3

Total space (kbytes): 262120

Used space (kbytes): 2700

Available space (kbytes): 259420

ID: 1248966756

Device/File Name: + OCR

Device/File integrity check succeeded

Device/File not configured

Device/File not configured

Device/File not configured

Device/File not configured

Cluster registry integrity check succeeded

Logical corruption check succeeded

The above is all the contents of the article "what are the basic start and stop commands in the daily operation of RAC". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.