NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
spfile string
+OCR_VOTE/rac-cluster/asmparameterfile/registry.253.86637196
7
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[grid@rac2 dbs]$ asmcmd spget
+OCR_VOTE/rac-cluster/ASMPARAMETERFILE/REGISTRY.253.866371967
远程节点也重启,自动生效:
[grid@rac1 ~]$ asmcmd shutdown --abort
ASM instance shutdown
[grid@rac1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 15 11:44:24 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ASM instance started
Total System Global Area 1135747072 bytes
Fixed Size 2260728 bytes
Variable Size 1108320520 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
ASM diskgroups volume enabled
SQL> show parameter spfile;
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
spfile string
+OCR_VOTE/rac-cluster/asmparameterfile/registry.253.866371967
至此,spfile重建完毕:
旧spfile:
+OCR_VOTE/rac-cluster/asmparameterfile/registry.253.866325101
新spfile:
+OCR_VOTE/rac-cluster/asmparameterfile/registry.253.866371967
Oracle 11gR2 RAC中修改数据库的SPFILE文件位置
在CentOS 6.4下安装Oracle 11gR2(x64)