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

本文涉及的产品
车辆物流识别,车辆物流识别 200次/月
文档理解,结构化解析 100页
教育场景识别,教育场景识别 200次/月
简介:

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

相关文章
|
12天前
|
存储 Oracle 关系型数据库
oracle数据恢复—oracle数据库执行错误truncate命令的数据恢复案例
oracle数据库误执行truncate命令导致数据丢失是一种常见情况。通常情况下,oracle数据库误操作删除数据只需要通过备份恢复数据即可。也会碰到一些特殊情况,例如数据库备份无法使用或者还原报错等。下面和大家分享一例oracle数据库误执行truncate命令导致数据丢失的数据库数据恢复过程。
|
10月前
|
运维 Oracle 前端开发
Oracle 11g RAC集群日常运维命令总结
Oracle 11g RAC集群日常运维命令总结
220 2
|
10月前
|
SQL 运维 Oracle
入门级Oracle 11g日常运维命令总结
入门级Oracle 11g日常运维命令总结
344 1
|
11月前
|
存储 Oracle 关系型数据库
关系型数据库Oracle运行RMAN脚本
【7月更文挑战第23天】
114 4
|
11月前
|
存储 负载均衡 Oracle
|
11月前
|
存储 负载均衡 Oracle
|
11月前
|
存储 Oracle 关系型数据库
|
10月前
|
Oracle 关系型数据库
分布式锁设计问题之Oracle RAC保证多个节点写入内存Page的一致性如何解决
分布式锁设计问题之Oracle RAC保证多个节点写入内存Page的一致性如何解决
135 0
|
SQL Oracle 关系型数据库
探索 Linux 命令 `db_archive`:Oracle 数据库归档日志的工具
探索 Linux 中的 `db_archive`,实际与 Oracle 数据库归档日志管理相关。在 Oracle 中,归档日志用于恢复,当在线重做日志满时自动归档。管理员可使用 SQL*Plus 查看归档模式,通过 `RMAN` 进行备份和恢复操作。管理归档日志需谨慎,避免数据丢失。了解归档管理对 Oracle 管理员至关重要,确保故障时能快速恢复数据库。
|
12月前
|
Oracle 关系型数据库 数据库
Oracle 11G数据库安装步骤及截图操作2
Oracle 11G数据库安装步骤及截图操作
111 0