关于oracle rac的操作命令 — 开发人员熟悉版本
rac的备份不只是数据的备份,也要对ocr以及voting进行备份,所以rac的备份概念和传统的数据库概念并不一样
这篇文档主要讲解oracle RAC的操作文档和实际的备份以及恢复概念,
1.环境
公司的oracle RAC
铁甲人linux 5.5版本
oracle 10201 database
oracle cluster 10201
节点:
node1 ip 231
node2 ip 232
主机:
windows xp sp3 241
2.确定oracle rac服务状态的命令
主要分为4种
crsctl gsdctl onsctl srvctl
(1)crsctl —- 谨慎操作,一般情况不允许做这个操作,除非crs出问题需要重启
这个命令主要用来启动和关闭集群服务
示例:
[root@node1 ~]# crsctl stop crs
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
[root@node1 ~]# crsctl start crs
Attempting to start CRS stack
测试crs,确定集群服务运行健康状态:
ORACLE@node1:/oracle/product/10.2.0/db_1/dbs>crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
(2)crs_ 系列
这系列的命令可以在CRS_HOME中找到,在公司的环境中我没有设置CRS_HOME变量,具体路径为:
/oracle/product/10.2.0/crs/bin
实例:
一:crs_stat -t的命令主要确定oracle rac的全部服务状态
ORACLE@node1:/home/oracle>crs_stat -t
Name Type Target State Host
————————————————————
ora.ldrac.db application ONLINE ONLINE node1
ora….c1.inst application ONLINE ONLINE node1
ora….c2.inst application ONLINE ONLINE node2
ora….SM1.asm application ONLINE ONLINE node1
ora….E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora….SM2.asm application ONLINE ONLINE node2
ora….E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
ORACLE@node1:/home/oracle>crs_stat -help
Usage: crs_stat [resource_name […]] [-v] [-l] [-q] [-c cluster_member]
crs_stat [resource_name […]] -t [-v] [-q] [-c cluster_member]
crs_stat -p [resource_name […]] [-q]
crs_stat [-a] application -g
crs_stat [-a] application -r [-c cluster_member]
crs_stat -f [resource_name […]] [-q] [-c cluster_member]
crs_stat -ls [resource_name […]] [-q]
示例
ORACLE@node1:/home/oracle>crs_stat -ls
Name Owner Primary PrivGrp Permission
—————————————————————–
ora.ldrac.db oracle oinstall rwxrwxr–
ora….c1.inst oracle oinstall rwxrwxr–
ora….c2.inst oracle oinstall rwxrwxr–
ora….SM1.asm oracle oinstall rwxrwxr–
ora….E1.lsnr oracle oinstall rwxrwxr–
ora.node1.gsd oracle oinstall rwxr-xr–
ora.node1.ons oracle oinstall rwxr-xr–
ora.node1.vip root oinstall rwxr-xr–
ora….SM2.asm oracle oinstall rwxrwxr–
ora….E2.lsnr oracle oinstall rwxrwxr–
ora.node2.gsd oracle oinstall rwxr-xr–
ora.node2.ons oracle oinstall rwxr-xr–
ora.node2.vip root oinstall rwxr-xr–
二: crs_start 这个命令和crsctl start crs 是一样的功能
crs_start 是用来启动集群所有服务的
,命令格式 :
crs_start -all 启动全部服务
crsctl start/stop resources 启动和关闭资源服务
三 gsdctl gsd控制器 The Global Services Daemon = GSD
关闭 gsdctl stop
PS : 关闭服务可以参考一下命令
[oracle@node1 ~]$ crs_stop ora.ORCL.ORATEST.cs
Attempting to stop `ora.ORCL.ORATEST.cs` on member `node2`
Stop of `ora.ORCL.ORATEST.cs` on member `node2` succeeded.
[oracle@node1 ~]$ crs_stop ora.node1.ASM1.asm
Attempting to stop `ora.node1.ASM1.asm` on member `node1`
Stop of `ora.node1.ASM1.asm` on member `node1` succeeded.
[oracle@node1 ~]$ crs_stop ora.node1.LISTENER_node1.lsnr
Attempting to stop `ora.node1.LISTENER_node1.lsnr` on member `node1`
Stop of `ora.node1.LISTENER_node1.lsnr` on member `node1` succeeded.
[oracle@node1 ~]$ crs_stop ora.node1.ons
Attempting to stop `ora.node1.ons` on member `node1`
Stop of `ora.node1.ons` on member `node1` succeeded.
[oracle@node1 ~]$ crs_stop ora.node1.vip
Attempting to stop `ora.node1.vip` on member `node1`
Stop of `ora.node1.vip` on member `node1` succeeded.
[oracle@node1 ~]$ crs_stop ora.node2.gsd
Attempting to stop `ora.node2.gsd` on member `node2`
Stop of `ora.node2.gsd` on member `node2` succeeded.
[oracle@node1 ~]$ crs_stop ora.node2.ons
Attempting to stop `ora.node2.ons` on member `node2`
Stop of `ora.node2.ons` on member `node2` succeeded.
[oracle@node1 ~]$ crs_stop ora.node1.gsd
Attempting to stop `ora.node1.gsd` on member `node1`
Stop of `ora.node1.gsd` on member `node1` succeeded.
相反启动服务可以用 crs_start 如上只需要把stop改成start就可以了。
四: ASM的使用
在orcale用户下输入
asmcmd
就可以进入asm的介质管理平台
输入help就可以列出一系列操作解释
下一篇: srvctl 的使用 —- 这个是rac常用的管理工具