Oracle 11gR2 RAC环境重建ASM spfile

有关Oracle 11gR2 ASM spfile说明可以看 http://www.linuxidc.com/Linux/2015-01/112535.htm以下粘出spfile重启过程:+++1）当前集群资源运行状态[grid@rac2 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.LISTENER.lsnr
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.OCR_VOTE.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.asm
ONLINE ONLINE rac1 Started
ONLINE ONLINE rac2 Started
ora.gsd
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.net1.network
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.ons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.registry.acfs
ONLINE ONLINE rac1
ONLINE ONLINE rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1
ora.cvu
1 ONLINE ONLINE rac2
ora.luyan.db
1 ONLINE ONLINE rac2 Open
2 ONLINE ONLINE rac1 Open
ora.oc4j
1 ONLINE ONLINE rac2
ora.rac1.vip
1 ONLINE ONLINE rac1
ora.rac2.vip
1 ONLINE ONLINE rac2
ora.scan1.vip
1 ONLINE ONLINE rac1+++2）当前ASM spfile配置[root@rac2 ~]# su - grid
s[grid@rac2 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 15 10:43:25 2014Copyright （c） 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management optionsSQL> show parameter spfile;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,删除旧的spfileASMCMD> 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 startedTotal 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,而后指向我们手工创建的路径,看看数据库能否顺利打开:[grid@rac2 ~]$ cd $GRID_HOME/dbs
[grid@rac2 dbs]$ ps -ef | grep pmon
grid 5850 1 0 10:46 ？ 00:00:00 asm_pmon_+ASM1
oracle 6216 1 0 10:46 ？ 00:00:00 ora_pmon_luyan1
grid 6990 5516 0 10:55 pts/0 00:00:00 grep pmon
[grid@rac2 dbs]$ cat > init+ASM1.ora <<EOF
> spfile="+OCR_VOTE/rac-cluster/spfilecss.ora"
> EOF
[grid@rac2 dbs]$ cat init+ASM1.ora
spfile="+OCR_VOTE/rac-cluster/spfilecss.ora" <<<<<<<<<<<<<<<<<pfile内容指定了spfile为我们手工创建的路径重启ASM...SQL> show parameter spfile; NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
spfile string
/home/grid/REGISTRY.253.866325101
SQL> shutdown abort;
ASM instance shutdown
SQL> startup pfile="？/dbs/init+ASM1.ora"; <<<<<<<<<以pfile启动
ASM instance startedTotal 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/spfilecss.ora[grid@rac2 dbs]$ asmcmd spget
+OCR_VOTE/rac-cluster/spfilecss.ora
[grid@rac2 dbs]$ 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
[grid@rac2 dbs]$ asmcmd shutdown --abort
ASM instance shutdown
[grid@rac2 dbs]$ sqlplus / as sysasmSQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 15 11:21:09 2014Copyright （c） 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL> startup
ASM instance startedTotal 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/spfilecs
s.ora节点一启动也能正常启动:
[grid@rac1 ~]$ ps -ef | grep pmon
grid 5793 5674 0 10:50 pts/0 00:00:00 grep pmon
[grid@rac1 ~]$
[grid@rac1 ~]$
[grid@rac1 ~]$ sqlplus / as sysasmSQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 15 11:21:56 2014Copyright （c） 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL> startup
ASM instance startedTotal 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/spfilecss.ora <<<<<<<<<<<<<<<<以正确的SPFILE路径启动实例
+++5）替换手工创建的spfile至链接路径（可选）[grid@rac2 dbs]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.LISTENER.lsnr
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.OCR_VOTE.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.asm
ONLINE ONLINE rac1 Started
ONLINE ONLINE rac2 Started
ora.gsd
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.net1.network
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.ons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.registry.acfs
ONLINE ONLINE rac1
ONLINE ONLINE rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1
ora.cvu
1 ONLINE ONLINE rac2
ora.luyan.db
1 ONLINE ONLINE rac2 Open
2 ONLINE ONLINE rac1 Open
ora.oc4j
1 ONLINE ONLINE rac2
ora.rac1.vip
1 ONLINE ONLINE rac1
ora.rac2.vip
1 ONLINE ONLINE rac2
ora.scan1.vip
1 ONLINE ONLINE rac1
[grid@rac2 dbs]$ asmcmd spget
+OCR_VOTE/rac-cluster/spfilecss.ora
[grid@rac2 dbs]$ 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
[grid@rac2 dbs]$ asmcmd spset +OCR_VOTE/rac-cluster/ASMPARAMETERFILE/REGISTRY.253.866371967
[grid@rac2 dbs]$ asmcmd shutdown --abort
ASM instance shutdown
[grid@rac2 dbs]$ sqlplus / as sysasmSQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 15 11:43:26 2014Copyright （c） 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL> startup
ASM instance startedTotal 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.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 sysasmSQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 15 11:44:24 2014Copyright （c） 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL> startup
ASM instance startedTotal 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.86637196711G RAC重建ASM实例的SPFILE http://www.linuxidc.com/Linux/2014-06/103381.htmOracle 11gR2 RAC中修改数据库的SPFILE文件位置 http://www.linuxidc.com/Linux/2012-09/70718.htm在CentOS 6.4下安装Oracle 11gR2（x64） http://www.linuxidc.com/Linux/2014-02/97374.htmOracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htmDebian 下安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htmOracle性能优化之共享池 http://www.linuxidc.com/Linux/2012-02/54062.htm更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址