oracle pdb spfile,oracle 12C 迁移spfile

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已经迁移完毕，真方便