Oracle RAC 常用维护工具和命令(十)

2014-11-24 13:09:13 · 作者: · 浏览: 19
ActiveNodes constructor...
... ...
4.4 恢复
假设OCR磁盘和Votedisk磁盘全部破坏,并且都没有备份,该如何恢复, 这时最简单的方法就是重新初始话OCR和Votedisk, 具体操作如下:
4.4.1 停止所有节点的Clusterware Stack
Crsctl stop crs;
4.4.2 分别在每个节点用root用户执行$CRS_HOME/install/rootdelete.sh脚本
4.4.3 在任意一个节点上用root用户执行$CRS_HOME/install/rootinstall.sh 脚本
4.4.4 在和上一步同一个节点上用root执行$CRS_HOME/root.sh脚本
4.4.5 在其他节点用root执行行$CRS_HOME/root.sh脚本
4.4.6 用netca 命令重新配置监听,确认注册到Clusterware中
#crs_stat -t -v
到目前为止,只有Listener,ONS,GSD,VIP 注册到OCR中,还需要把ASM, 数据库都注册到OCR中。
4.4.7 向OCR中添加ASM
#srvctl add asm -n rac1 -i +ASM1 -o /u01/app/product/database
#srvctl add asm -n rac2 -i +ASM2 -o /u01/app/product/database
4.4.8 启动ASM
#srvctl start asm -n rac1
#srvctl start asm -n rac2
若在启动时报ORA-27550错误。是因为RAC无法确定使用哪个网卡作为Private Interconnect,解决方法:在两个ASM的pfile文件里添加如下参数:
+ASM1.cluster_interconnects='10.85.10.119'
+ASM2.cluster_interconnects='10.85.10.121'
4.4.9 手工向OCR中添加Database对象。
#srvctl add database -d raw -o /u01/app/product/database
4.4.10 添加2个实例对象
#srvctl add instance -d raw -i raw1 -n raw1
#srvctl add instance -d raw -i raw2 -n raw2
4.4.11 修改实例和ASM实例的依赖关系
#srvctl modify instance -d raw -i raw1 -s +ASM1
#srvctl modify instance -d raw -i raw2 -s +ASM2
4.4.12 启动数据库
#srvctl start database-d raw
若也出现ORA-27550错误。也是因为RAC无法确定使用哪个网卡作为Private Interconnect,修改pfile参数在重启动即可解决。
SQL>alter system set cluster_interconnects='10.85.10.119' scope=spfile sid='raw1';
SQL>alter system set cluster_interconnects='10.85.10.121' scope=spfile sid='raw2';
Srvctl 命令的用法还有很多,下面是在线文档的一个目录,感兴趣的可以自己研究下。

http://download-west.oracle.com/docs/cd/B19306_01/rac.102/b14197/toc.htm

srvctl add
srvctl add database
srvctl add instance
srvctl add service
srvctl add nodeapps
srvctl add asm

srvctl config
srvctl config database
srvctl config service
srvctl config nodeapps
srvctl config asm
srvctl config listener

srvctl enable
srvctl enable database
srvctl enable instance
srvctl enable service
srvctl enable asm

srvctl disable
srvctl disable database
srvctl disable instance
srvctl disable service
srvctl disable asm

srvctl start
srvctl start database
srvctl start instance
srvctl start service
srvctl start nodeapps
srvctl start asm
srvctl start listener

srvctl stop
srvctl stop database
srvctl stop instance
srvctl stop service
srvctl stop nodeapps
srvctl stop asm
srvctl stop listener

srvctl modify
srvctl modify database
srvctl modify instance
srvctl modify service
srvctl modify nodeapps

srvctl relocate
srvctl relocate service

srvctl status
srvctl status database
srvctl status instance
srvctl status service
srvctl status nodeapps
srvctl status asm

srvctl getenv
srvctl getenv database
srvctl getenv instance
srvctl getenv service
srvctl getenv nodeapps

srvctl setenv and unsetenv
srvctl setenv database
srvctl setenv instance
srvctl setenv service
srvctl setenv nodeapps
srvctl unsetenv database
srvctl unsetenv instance
srvctl unsetenv service
srvctl unsetenv nodeapps

srvctl remove
srvctl remove database
srvctl remove instance
srvctl remove service
srvctl remove nodeapps
srvctl remove asm

注:本文整理自<大话Oracle RAC>