11g rac rebuilding the SPFILE of the ASM instance
1. Prerequisites
You need to know the following information:
1) number of nodes
2) the location of the disk included in the ASM disk group
3) There are several disk groups for the instance.
2. Steps and reconstruction scripts
1) Successful scripts:
*. Cluster_database_instances = 2
+ ASM1.instance _ name = '+ ASM1'
+ ASM1.instance _ name = '+ ASM2'
+ ASM1.asm _ diskgroups = 'ocr ', 'arc', 'data' # Manual Mount
+ ASM2.asm _ diskgroups = 'ocr ', 'arc', 'data' # Manual Mount
*. Asm_diskstring = '/dev/raw /*'
*. Asm_power_limit = 1
*. Diagnostic_dest = '/Oracle/app/crs_base'
*. Instance_type = 'asm'
*. Large_pool_size = 12 M
*. Remote_login_passwordfile = 'clusive'
2) SQL> startup pfile = asm_init.ora
ASM instance started
Total System Global Area 283930624 bytes
Fixed Size 2212656 bytes
Variable Size 256552144 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
ASM diskgroups volume enabled
3) SQL> create spfile = '+ data' from pfile ='/home/oracle/asm_init.ora ';
File created.
4) restart the ASM instance.
Shutdown --- startup
5) view the current SPFILE location
SQL> show parameter spfile;
Relationship between the server parameter file (SPFILE) in the Oracle 11g parameter file and instance startup
Use RMAN automatic backup to dump SPFILE
11.2 how to access the environment ASM instance SPFILE In the ASM disk group
Notes for transferring SPFILE and pfile in RAC Environment
Oracle startup and SPFILE files