12 ORACLE
R2对存放在asm磁盘中的spfile迁移
ASMCMD>
spmove
+OCR_VOTE/rac12c-cluster/ASMPARAMETERFILE/registry.253.940153205
+DATA/rac12c-cluster/ASMPARAMETERFILE/spfileASM.ora
ORA-15032:
not all alterations performed
ORA-15028:
ASM file
'+OCR_VOTE/rac12c-cluster/ASMPARAMETERFILE/registry.253.940153205'
not dropped; currently being accessed (DBD ERROR:
OCIStmtExecute)
重启has后
[grid@rac12c1 ~]$ sqlplus / as sysdba
SQL*Plus:
Release 12.2.0.1.0 Production on Tue Apr 4 08:54:28 2017
Copyright
(c) 1982, 2016, Oracle. All rights
reserved.
Connected
to:
Oracle
Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit
Production
SQL>
show parameter spfile
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
spfile string +DATA/rac12c-cluster/ASMPARAME
TERFILE/spfileasm.ora
[grid@rac12c1 ~]$ asmcmd
ASMCMD> spget
+DATA/rac12c-cluster/ASMPARAMETERFILE/spfileASM.ora
ASMCMD>
可以看到spfile已经迁移完毕,真方便