： *.asm_power_limit=1 *.diagnostic_dest='/u01/app/grid/11.2.0/log' *.instance_type='asm' *.large_pool_size=12M *.remote_login_passwordfile='EXCLUSIVE'
2).创建SPFILE文件： [root@rac2 ~]# su - grid [grid@rac2 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 9 00:03:22 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Real Application Clusters and Automatic Storage Management options
SQL> create spfile='+OCR' from pfile='/tmp/asm_pfile.txt';
File created.
SQL> show parameter spfile
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string
3).重启HAS服务，验证SPFILE参数： [root@rac2 ~]# cd /u01/app/grid/11.2.0/bin [root@rac2 bin]# ./crsctl stop has ...... CRS-4133: Oracle High Availability Services has been stopped. [root@rac2 bin]# ./crsctl start has CRS-4123: Oracle High Availability Services has been started. [root@rac2 bin]# ./crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online [root@rac2 bin]# su - grid [grid@rac2 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 9 00:32:25 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Real Application Clusters and Automatic Storage Management options
SQL> show parameter spfile
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string +OCR/wstcluster/asmparameterfile/registry.253.798854653
SPFILE被成功配置。
整个过程参考文章：
How to Restore OCR After the 1st ASM Diskgroup is Lost on Windows [ID 1294915.1]
修改时间:2012-3-6
 类型:HOWTO
状态:PUBLISHED
优先级:3
In this Document
Goal
Solution
References
Applies to: Oracle Server - Enterprise Edition - Version: 11.2.0.1 to 11.2.0.2 [Release: 11.2 to 11.2]
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)
Goal The goal of this document is to provide the steps necessary to restore the OCR after the 1st ASM diskgroup, which contains the OCR, Voting Disks, and ASM SPFILE is lost.
The general process of restoring the OCR from backup is documented here: Restoring Oracle Cluster Repository.
Solution When using an ASM disk group for CRS there are typically 3 different types of files located in the disk group that potentially need to be restored/recreated:
- The Oracle Cluster Registry file (OCR)
- The Voting file(s)
- The shared SPFILE for the ASM instance(s)
1. Locate the latest automatic OCR backup
When using a non-shared CRS home, automatic OCR backups can be located on any node of the cluster, consequently all nodes need to be checked for the most recent backup:
$CRS_HOME\bin\ocrconfig -showbackup
PROT-26: Oracle Cluster Registry backup locations were retrieved from a local copy
RACNODE01 2010/08/20 12:25:00 C:\app\11.2.0\grid\cdata\cluster_name\backup00.ocr
RACNODE01 2010/08/20 08:24:58 C:\app\11.2.0\grid\cdata\cluster_name\backup01.ocr
RACNODE01 2010/08/20 04:24:55 C:\app\11.2.0\grid\cdata\cluster_name\backup02.ocr
RACNODE01 2010/08/19 04:24:41 C:\app\11.2.0\grid\cdata\cluster_name\day.ocr
RACNODE01 2010/08/09 04:22:07 C:\app\11.2.0\grid\cdata\cluster |