ORACLE 11g RAC日常运行中一些基本启停等命令总结

简介:

RAC日常运行中一些基本启停命令总结

设置cluster不随着操作系统自动启动

[root@rac01 u01]# crsctl disable crs

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

设置cluster随着操作系统自动启动,默认是启动的

[root@rac01 u01]# crsctl enable crs

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

启动cluster,两个节点分别执行

[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.

查看cluster资源状态,在两个节点都可以查看。

[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

启动数据库实例,数据库实例名字为sap,在一个实例上执行即可

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

查看cluster资源状态ora.sap.db状态为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

查看数据库实例状态

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

Instance sap1 is running on node rac01

Instance sap2 is running on node rac02

查看nodeapps资源状态

[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

查看listener状态

[root@rac01 rac01]# srvctl status listener

Listener LISTENER is enabled

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

查看ASM状态

[root@rac01 rac01]# srvctl status asm

ASM is running on rac01,rac02

查看scan状态

[root@rac01 rac01]# srvctl status scan

SCAN VIP scan1 is enabled

SCAN VIP scan1 is running on node rac01

查看ASM diskgroup状态

[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

停掉rac一个节点,例如停掉rac02

1、先停掉数据库实例,使用以下命令

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

也可以使用以下命令,

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

查看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).

查看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

本文转自ICT时空 dbasdk博客,原文链接:ORACLE 11g RAC日常运行中一些基本启停等命令总结 ,如需转载请自行联系原博主。

相关文章
|
1月前
|
Oracle 关系型数据库 分布式数据库
PolarDB常见问题之PolarDB(Oracle兼容版) 执行命令报错如何解决
PolarDB是阿里云推出的下一代关系型数据库,具有高性能、高可用性和弹性伸缩能力,适用于大规模数据处理场景。本汇总囊括了PolarDB使用中用户可能遭遇的一系列常见问题及解答,旨在为数据库管理员和开发者提供全面的问题指导,确保数据库平稳运行和优化使用体验。
|
1月前
|
Oracle 关系型数据库 数据库
|
1月前
|
存储 运维 Oracle
Oracle系列十八:Oracle RAC
Oracle系列十八:Oracle RAC
|
2月前
|
Oracle 关系型数据库
oracle Hanganalyze no RAC
oracle Hanganalyze no RAC
15 0
|
2月前
|
Oracle 关系型数据库
oracle rac 手工安装补丁,不适用auto
oracle rac 手工安装补丁,不适用auto
25 3
|
2月前
|
Oracle 关系型数据库
oracle 19c 搭建dataguard 简要命令
通过service 完成dg 搭建。
50 0
|
3月前
|
SQL Oracle 关系型数据库
Linux环境下oracle切换用户并查询数据库命令
Linux环境下oracle切换用户并查询数据库命令
|
4月前
|
SQL Oracle 关系型数据库
Oracle 常用命令大全
Oracle 常用命令大全
|
6月前
|
Oracle 关系型数据库 Java
分享一个 Oracle RAC 模式下客户端建立JDBC初始连接时因ONS造成应用启动时卡顿30秒问题的排查分析案例
分享一个 Oracle RAC 模式下客户端建立JDBC初始连接时因ONS造成应用启动时卡顿30秒问题的排查分析案例
|
14天前
|
SQL Oracle 关系型数据库
【Oracle】玩转Oracle数据库(一):装上去,飞起来!
【Oracle】玩转Oracle数据库(一):装上去,飞起来!
56 7