NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
spfile string
+OCR_VOTE/rac-cluster/asmparameterfile/registry.253.866325101
[grid@rac2 ~]$ asmcmd spget
+OCR_VOTE/rac-cluster/ASMPARAMETERFILE/REGISTRY.253.866325101
+++3) 备份spfile,删除旧的spfile
ASMCMD> cd +OCR_VOTE/rac-cluster/ASMPARAMETERFILE/
ASMCMD> ls
REGISTRY.253.866325101
ASMCMD> rm REGISTRY.253.866325101
ORA-15032: not all alterations performed
ORA-15028: ASM file '+OCR_VOTE/rac-cluster/ASMPARAMETERFILE/REGISTRY.253.866325101' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
ASMCMD> spcopy +OCR_VOTE/rac-cluster/ASMPARAMETERFILE/REGISTRY.253.866325101 /home/grid
ASMCMD> spset /home/grid/REGISTRY.253.866325101
ASMCMD> shutdown --abort
ASM instance shutdown
Connected to an idle instance.
ASMCMD> 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
ASMCMD> spget
/home/grid/REGISTRY.253.866325101 <<<<<已经生效
ASMCMD> rm REGISTRY.253.866325101
ORA-15032: not all alterations performed
ORA-15028: ASM file '+OCR_VOTE/rac-cluster/ASMPARAMETERFILE/REGISTRY.253.866325101' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
<<<<<<提示不让删除,因为有实例在占用.关闭实例1即可
[grid@rac1 ~]$ asmcmd
ASMCMD> shutdown --abort
ASM instance shutdown
Connected to an idle instance.
ASMCMD> exit
[grid@rac1 ~]$ ps -ef | grep pmon
grid 5793 5674 0 10:50 pts/0 00:00:00 grep pmon
+++4) 重建spfile:
SQL> create spfile='+OCR_VOTE/rac-cluster/spfilecss.ora' from pfile='/tmp/css.ora';
File created.
[grid@rac2 ~]$ asmcmd spget
+OCR_VOTE/rac-cluster/spfilecss.ora <<<<<<<<<<<<<<<<自动修改了gpnp profile配置
[grid@rac2 ~]$ asmcmd ls -l +OCR_VOTE/rac-cluster/spfilecss.ora
Type Redund Striped Time Sys Name
N spfilecss.ora => +OCR_VOTE/rac-cluster/ASMPARAMETERFILE/REGISTRY.253.866371967
<<<<<<<<<<<<<我们手工创建的spfile实际上还是指向了+OCR_VOTE/rac-cluster/ASMPARAMETERFILE/REGISTRY.253.866371967
以下尝试创建pfile,而后指向我们手工创建的路径,看看数据库能否顺利打开: