oraclerac常用的命令(十一)

2014-11-24 15:08:37 · 作者: · 浏览: 8
ct/10.2.0/db_1/jlib/netcfg.jar:/u01/app/oracle/product/10.2.0/db_1/jdk/jre/lib/rt.jar:/u01/app/oracle/product/10.2.0/db_1/jdk/jre/lib/i18n.jar:/u01/app/oracle/product/10.2.0/db_1/jlib/srvm.jar:/u01/app/oracle/product/10.2.0/db_1/jlib/srvmhas.jar:/u01/app/oracle/product/10.2.0/db_1/jlib/srvmasm.jar:/u01/app/oracle/product/10.2.0/db_1/srvm/jlib/srvctl.jar -DTRACING.ENABLED=true -DTRACING.LEVEL=2 oracle.ops.opsctl.OPSCTLDriver config database -d racdb
[main] [16:1:30:670] [OPSCTLDriver.setInternalDebugLevel:165] tracing is true at level 2 to file null
[main] [16:1:30:705] [OPSCTLDriver.:95] Security manager is set
[main] [16:1:30:716] [CommandLineParser.parse:173] parsing cmdline args
[main] [16:1:30:717] [CommandLineParser.parse2WordCommandOptions:940] parsing 2-word cmdline
[main] [16:1:30:718] [OPSCTLDriver.execute:174] executing srvctl command
[main] [16:1:30:718] [OPSCTLDriver.execute:199] executing 2-word command verb=10 noun=101
[main] [16:1:30:729] [Action.getOPSConfig:162] get db config for: racdb
[main] [16:1:30:730] [CommandLineParser.obtainOPSConfig:1410] srvctl: get db config for: racdb
[main] [16:1:30:745] [GetActiveNodes.create:213] Going into GetActiveNodes constructor...
[main] [16:1:30:750] [HASContext.getInstance:190] Module init : 16
[main] [16:1:30:751] [HASContext.getInstance:214] Local Module init : 19
[main] [16:1:30:770] [Library.getInstance:95] Created instance of Library.
[main] [16:1:30:771] [Library.load:195] Loading libsrvmhas10.so...
[main] [16:1:30:771] [Library.load:201] oracleHome null
E.DATABASES.racdb.INSTANCE.racdb1)


......


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
[root@rac2 bin]# ./srvctl add asm -n racdb1 -i +ASM1 -o /u01/app/oracle/admin/RACDB
[root@rac2 bin]# ./srvctl add asm -n racdb2 -i +ASM2 -o /u01/app/oracle/admin/RACDB
4.4.8 启动ASM
./srvctl start asm -n rac1
./srvctl start asm -n rac2
// 若在启动时报ORA-27550错误,是因为RAC无法确定使用哪个网卡作为PRIVATE INTERCONNECT,解决方法:在两个ASM的pfile文件里加入参数:
+ASM1.cluster_interconnects='192.168.90.3'
+ASM2.cluster_interconnects='192.168.90.6'
/* ORA-27550: Target ID protocol check failed. tid vers=number, type=number, remote instance number=number, local instance number=number
Cause: The local Oracle Real Application Cluster instance and remote instance are running with incompatible implementation of the inter-instance IPC protocol library. A misconfiguration or installation error occurred.
Action: Check additional error messages in the alert log and the process trace file. */

4.4.9 手工向OCR中添加DATABASE对象。
./srvctl add database -d racdb -o /u01/app/oracle/admin/RACDB
4.4.10 添加2个实例对象
./srvctl add instance -d racdb -i racdb1 -n rac1
./srvctl add instance -d racdb -i racdb2 -n rac2
4.4.11 修改实例和ASM实例的依赖关系
./srvctl modify instance -d racdb -i racdb1 -s +ASM1
./srvctl modify instance -d racdb -i racdb2 -s +ASM2
4.4.12 启