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

相关文章
|
SQL 开发框架 Oracle
Oracle数据库面试题总结
1、SQL语句分类 DQL(数据查询语言)select DML(数据操作语言)insert、delete、update DDL(数据定义语言)create、drop、alter DCL(数据控制语言)grant:把权限授予用户、revoke:把权限从用户收回 TPL(TCL,事务控制语言):commit、rollback
129 0
|
Oracle 关系型数据库 BI
Oracle-分析函数_总结
Oracle-分析函数_总结
|
SQL Oracle 算法
Oracle总结【SQL细节、多表查询、分组查询、分页】下
在之前已经大概了解过Mysql数据库和学过相关的Oracle知识点,但是太久没用过Oracle了,就基本忘了…印象中就只有基本的SQL语句和相关一些概念….写下本博文的原因就是记载着Oracle一些以前没注意到的知识点…以后或许会有用… 实例与数据库概念
203 0
Oracle总结【SQL细节、多表查询、分组查询、分页】下
|
SQL Oracle 关系型数据库
Oracle总结【SQL细节、多表查询、分组查询、分页】上
在之前已经大概了解过Mysql数据库和学过相关的Oracle知识点,但是太久没用过Oracle了,就基本忘了…印象中就只有基本的SQL语句和相关一些概念….写下本博文的原因就是记载着Oracle一些以前没注意到的知识点…以后或许会有用… 实例与数据库概念
93 0
Oracle总结【SQL细节、多表查询、分组查询、分页】上
|
SQL 存储 Oracle
Oracle总结【视图、索引、事务、用户权限、批量操作】三
在Oracle总结的第一篇中,我们已经总结了一些常用的SQL相关的知识点了…那么本篇主要总结关于Oralce视图、序列、事务的一些内容… 在数据库中,我们可以把各种的SQL语句分为四大类… (1)DML(数据操纵语言):select,insert,update,delete (2)DDL(数据定义语言):create table,alter table,drop table,truncate table (3)DCL(数据控制语言):grant select any table to scott/revoke select any table from scott (4)TCL(事务
114 0
Oracle总结【视图、索引、事务、用户权限、批量操作】三
|
SQL Oracle 关系型数据库
Oracle总结【视图、索引、事务、用户权限、批量操作】二
在Oracle总结的第一篇中,我们已经总结了一些常用的SQL相关的知识点了…那么本篇主要总结关于Oralce视图、序列、事务的一些内容… 在数据库中,我们可以把各种的SQL语句分为四大类… (1)DML(数据操纵语言):select,insert,update,delete (2)DDL(数据定义语言):create table,alter table,drop table,truncate table (3)DCL(数据控制语言):grant select any table to scott/revoke select any table from scott (4)TCL(事务
115 0
Oracle总结【视图、索引、事务、用户权限、批量操作】二
|
SQL 存储 Oracle
Oracle总结【视图、索引、事务、用户权限、批量操作】 一
在Oracle总结的第一篇中,我们已经总结了一些常用的SQL相关的知识点了…那么本篇主要总结关于Oralce视图、序列、事务的一些内容… 在数据库中,我们可以把各种的SQL语句分为四大类… (1)DML(数据操纵语言):select,insert,update,delete (2)DDL(数据定义语言):create table,alter table,drop table,truncate table (3)DCL(数据控制语言):grant select any table to scott/revoke select any table from scott (4)TCL(事务
104 0
Oracle总结【视图、索引、事务、用户权限、批量操作】 一
|
存储 SQL Oracle
|
存储 Oracle Java
|
SQL Oracle 关系型数据库
推荐文章
更多