11gR2 RAC环境重建ASM SPFILE

最新推荐文章于 2022-09-05 19:20:51 发布
最新推荐文章于 2022-09-05 19:20:51 发布
阅读量1k 收藏
点赞数
分类专栏： 故障处理 文章标签： asm 重建spfile
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/robo23/article/details/41942141
版权

有关11gR2 ASM spfile说明可以看

http://blog.csdn.net/robo23/article/details/41930051

 

以下粘出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 sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 15 10:43:25 2014

Copyright (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 options

SQL> 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,删除旧的spfile

ASMCMD> 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 started

Total 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 started

Total 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 sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 15 11:21:09 2014

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

Connected to an idle instance.

SQL> startup
ASM instance started

Total 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 sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 15 11:21:56 2014

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

Connected to an idle instance.

SQL> startup
ASM instance started

Total 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 sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 15 11:43:26 2014

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

Connected to an idle instance.

SQL> startup
ASM instance started

Total 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 sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 15 11:44:24 2014

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

Connected to an idle instance.

SQL> startup
ASM instance started

Total 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.866371967

 

-------------------------------------------------------------------------------------------------

本文来自于我的技术博客 http://blog.csdn.net/robo23

转载请标注源文链接,否则追究法律责任！

 

宋小荣
关注
专栏目录
ASM下修改并重建spfile
cuansiye8661的博客
05-10 594
今天遇到一个问题，回来后做了个实验，在ASM下，修改参数文件后，模拟数据无法启动到mount状态，并进行还原参数，使其重新启动。 一、实验环境 服务器环境： [oracle@LINUX1...
11G RAC重建ASM实例的SPFILE
ITer-Tony
05-16 1276
参考链接：https://forums.oracle.com/forums/thread.jspa?messageID=7432269 1、前提条件 需要知道以下信息：   1）、节点数量   2）、ASM磁盘组包括的磁盘所在位置   3）、实例有那几个磁盘组 2、步骤及重建脚本   1）成功的脚本： *.cluster_database_instances=2 +ASM1.in
Oracle12C重启asm实例,11G RAC重建ASM实例的SPFILE
weixin_42326020的博客
04-02 513
1、前提条件 需要知道以下信息： 1)、节点数量 2)、ASM磁盘组包括的磁盘所在位置 3)、实例有那几个磁盘组 2、步骤及重建1、前提条件需要知道以下信息：1)、节点数量2)、ASM磁盘组包括的磁盘所在位置3)、实例有那几个磁盘组2、步骤及重建脚本1)成功的脚本：*.cluster_database_instances=2+ASM1.instance_name='+ASM1'+ASM1.inst...
RAC环境下，创建spfile导致节点间数据库参数不一致的问题
网站开发初中级代码参考-转载
03-07 177
初接触RAC，创建spfile的时候，需要制定位置例如： create spfile='xxxxx' from pfile ; 一般$ORACLE_HOME/dbs/init$ORACLE_SID.ora 里面的内容都只是共享磁盘中spfile的信息。 例如： [oracle@rac1 dbs]$strings initdex1.ora SPFILE='+BACKUPS/dex/s...
2008 r2环境下的oracle 11g rac+asm,Oracle 11gR2 RAC环境重建ASM spfile
weixin_32386693的博客
04-02 474
以下粘出spfile重启过程:+++1)当前集群资源运行状态[grid@rac2 ~]$ crsctl stat res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER ...
Oracle-11g-R2-RAC-with-ASM存储迁移-手记.docx
10-29
Oracle 11g R2 RAC with ASM 存储迁移手记 本文详细介绍了如何将 Oracle RAC 的数据库数据迁移到新的存储设备上，并提供了详细的迁移步骤和图文说明。整个迁移过程中，使用了 ASM DISKGROUP 的方式来完成存储迁移，...
Oracle 11gR2迁移升级至12cR2 RAC
03-26
### Oracle 11gR2迁移升级至12cR2 RAC #### 概述 本文档旨在详细介绍如何从Oracle 11.2.0.4单机环境迁移到Oracle 12cR2 RAC环境的过程。该迁移不仅涉及物理硬件的变化，还包含了数据库版本的升级。通过这种方式，...
使用Oracle ASM管理11gR2 RAC集群中的存储
## 介绍Oracle ASM和11gR2 RAC集群 Oracle ASM（Automatic Storage Management）是Oracle数据库管理系统中的一项功能强大的技术，用于管理存储设备和存储分配。它可以提供高度可靠和高性能的存储解决方案，特别适用...
Oracle11GR2 RAC for AIX6.1.4完美安装攻略
06-24
创建ASM磁盘组 DBCA创建数据库 安装完成后 备份root.sh 重新编译全部PL/SQL modules 备份spfile文件 RAC集群系统维护命令 启动和关闭集群系统命令 启动集群件和集群数据库 关闭RAC集群数据库和集群件
RAC中创建spfile
12-25
RAC中创建spfile的各种方法，有截图，说明，对新人帮助很大
RAC下使用pfile创建spfile
cnxfytscp521955115的博客
01-09 443
之前曾查看advice来修改了sga到建议值，结果因为32位win系统导致sga不能超过1.7无法启动，周末接到电话，客户正在检查，要求紧急处理，在家里远程了一下，查了下CRSE:\oracle\product\10.2.0\c...
oracle asm spfile丢失,在ASM下创建spfile
weixin_28957683的博客
04-08 247
Applies to:Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7This problem can occur on any platform.SymptomsOn 10.2.0.1 in Production:-- Suppose that the database instance name is "osm...
rac环境中的spfile
12-04 121
在RAC环境中,我们经常发现一些类似于以下的参数:rac1.instance_number=2rac2.instance_number=1*.db_block_size=8192*.db_cache_size=25165824这...
ORACLE RAC下创建SPFILE和PFILE注意事项
chairrat的专栏
09-05 4861
RAC下的spfile和pfile
linux 11Gasm启动crs,11GR2重建CRS
weixin_29229989的博客
05-14 186
1.停止crs[root@node1 ~]# /u01/app/grid/11.2.0/bin/crsctl stop crs -f[root@node2 ~]# /u01/app/grid/11.2.0/bin/crsctl stop crs -f停不掉的情况下可以禁用开机启动,然后重启机器/u01/app/grid/11.2.0.4/bin/crsctl disable has2.删除crs节...
oracle-添加 controlfile 以及重建spfile
03-11 443
添加controlfile,重新创建spfile 1.编辑init.ora文件 指定需要添加的控制文件的路径 control_files=("/oracle/product/10.1.0/oradata/orcl/co...
11g RAC中pfile和spfile的使用总结
DATA
08-22 6038
RAC中的spfile和pfile的使用和单实例的有些区别，下面以11g linux环境测试，作个总结。 RAC中参数文件主要用dbs目录下的pfileSID、spfileSID和共享存储ASM下的spfileDB. 数据库启动时默认只去找pfile,不会直接找dbs下spfileSID和共享存储ASM下的spfileDB。pfile指向ASM共享的spfileDB，所以一般使用ASM共享的s
Oracle 运维篇+RAC下ASM的spfile迁移指导手册
ZZT_2009
04-05 799
说明：本文为Oracle RAC ASM-spfile迁移指导手册 注意：ASM-spfile是ASM实例的二进制参数文件，而不是Oracle RAC数据库实例的spfile，新手容易弄混 温馨提示：如果您发现本文哪里写的有问题或者有更好的写法请留言或私信我进行修改优化 【步骤简述】 --查看当前ASM-spfile位置 --复制当前ASM-spfile到本地磁盘作为临时中转文件 --移动临时中...
Oracle 11gR2 RAC安装教程：KVM与VirtualBox环境
"本教程详细介绍了如何在KVM和VirtualBox环境下安装Oracle 11gR2 RAC集群，包括虚拟机配置、网络规划、磁盘布局以及共享存储的设置方法。" 在安装Oracle 11gR2 Real Application Clusters (RAC)时，我们需要在多个...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值