| 修改时间 02-NOV-2011 类型 PROBLEM 状态 PUBLISHED | |||
In this Document
Symptoms
Cause
Solution
Applies to:
Oracle Server - Enterprise Edition - Version: 11.2.0.0 to 11.2.0.2 - Release: 11.2 to 11.2Information in this document applies to any platform.
Symptoms
1) On ASM 11gR2 the ASM spfile initialization parameter file is
now stored in the first created diskgroup (e.g. DATA).
Example:
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option
SQL> show parameter instance_type
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_type string asm
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/asm/asmparameterfile/registry.253.697740955
2) If for any reason the ASM spfile is missing, you will
not be able to start the ASM instance.
Cause
ASM spfile initialization parameter file is now stored in the first created diskgroup (e.g. DATA) so if the ASM instance is not started and the diskgroup is not mounted you cannot recreate the spfile.
Solution
But you can use the next procedure to solve the problem:
1) Create a temporary pfile using the minimum parameters:
+ASM.asm_diskgroups='OLTP','FRA'
*.asm_diskstring='ORCL:*'
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/oracle'
*.instance_type='asm'
*.large_pool_size=12M
#*.local_listener='LISTENER_+ASM'
*.remote_login_passwordfile='EXCLUSIVE'
2) Startup the ASM instance using the new pfile:
SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 16 16:53:57 2009
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option
SQL> startup pfile=asm.ora
3) Then recreate the ASM spfile as follow:
File created.
4) Check the new spfile thru ASMCMD as well:
ASMCMD> cd +DATA/asm/asmparameterfile/
ASMCMD> ls
REGISTRY.253.697740955
5) Restart the ASM instance using the new spfile:
SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 16 16:53:57 2009
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option
SQL> startup
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
spfile string
+DATA/asm/asmparameterfile/registry.253.697740955
|
产品
| ||
相关内容
返回页首