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日常运行中一些基本启停等命令总结 ,如需转载请自行联系原博主。

相关文章
|
运维 Oracle 前端开发
Oracle 11g RAC集群日常运维命令总结
Oracle 11g RAC集群日常运维命令总结
821 2
|
存储 Oracle 关系型数据库
关系型数据库Oracle运行RMAN脚本
【7月更文挑战第23天】
434 4
|
存储 负载均衡 Oracle
|
存储 Oracle 关系型数据库
|
Oracle 关系型数据库
分布式锁设计问题之Oracle RAC保证多个节点写入内存Page的一致性如何解决
分布式锁设计问题之Oracle RAC保证多个节点写入内存Page的一致性如何解决
490 0
|
关系型数据库 Oracle
RAC_Oracle集群服务安装RAC(案例)
2015-01-23 Created By BaoXinjian           Thanks and RegardsERP技术讨论群: 288307890 技术交流,技术讨论,欢迎加入 Technology Blog Created By Oracle ERP - 鲍新建
988 0
|
Oracle 关系型数据库
oracle rac 手工安装补丁,不适用auto
oracle rac 手工安装补丁,不适用auto
361 3
|
存储 Oracle 关系型数据库
Oracle RAC:数据库集群的舞动乐章
【4月更文挑战第19天】Oracle RAC是Oracle提供的高可用性数据库解决方案,允许多个实例共享同一数据库,确保业务连续性和数据完整性。通过集群件和全局缓存服务实现服务器间的协调和通信。RAC提供高可用性,通过故障转移应对故障,同时提升性能,多个实例并行处理请求。作为数据管理员,理解RAC的架构和管理至关重要,以发挥其在数据管理中的最大价值。
|
存储 运维 Oracle
Oracle系列十八:Oracle RAC
Oracle系列十八:Oracle RAC
3322 0

推荐镜像

更多