ITPub博客

首页 > 数据库 > Oracle > Asm实例损坏后恢复(在进行asm修改配置时,事先要备份asmspfile)

Asm实例损坏后恢复(在进行asm修改配置时,事先要备份asmspfile)

Oracle 作者:abc1234__ 时间:2014-03-06 18:08:24 0 删除 编辑


事先备份好asmspfile

[grid@rac2 ~]$asmcmd

ASMCMD> spget

+ocr/rac/asmparameterfile/REGISTRY.253.840115871

ASMCMD> spcopy +ocr/rac/asmparameterfile/REGISTRY.253.840115871 /home/grid/asm.ora

ASMCMD> exit

创建pfile

[grid@rac2 ~]$ cat asmpfile.ora

#spfile=+ocr/rac/asmparameterfile/REGISTRY.253.840115871

spfile=/home/grid/asm.ora

利用pfile启动

[grid@rac2 ~]$ sqlplus / as sysasm

 

SQL*Plus: Release 11.2.0.1.0 Production on Wed Mar 5 18:24:52 2014

 

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

 

SQL> shutdown abort

ASM instance shutdown

SQL> startup pfile=/home/grid/asmpfile.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

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

查看spget确认spfile路径

[grid@rac2 ~]$ asmcmd

ASMCMD> spget

/home/grid/asm.ora

ASMCMD> exit

修改spfile路径

[grid@rac2 ~]$ cat asmpfile.ora

#spfile=+ocr/rac/asmparameterfile/REGISTRY.253.840115871

spfile=/home/grid/asm.ora

[grid@rac2 ~]$ asmcmd

ASMCMD> spset +ocr/rac/asmparameterfile/REGISTRY.253.840115871           

ASMCMD> exit

[grid@rac2 ~]$ sqlplus / as sysasm

 

SQL*Plus: Release 11.2.0.1.0 Production on Wed Mar 5 18:27:58 2014

 

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

 

SQL> shutdown immediate;

ASM diskgroups volume disabled

ASM diskgroups dismounted

ASM instance shutdown

SQL> startup

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

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

确认路径正确

[grid@rac2 ~]$ asmcmd

ASMCMD> spget

+ocr/rac/asmparameterfile/REGISTRY.253.840115871

ASMCMD> exit

恢复完成。

<!-- 正文结束 -->

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22076183/viewspace-1114994/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2009-07-09