How to move ASM spfile to a different disk group

最新推荐文章于 2024-08-18 16:51:31 发布
最新推荐文章于 2024-08-18 16:51:31 发布
阅读量1.4k 收藏
点赞数
CC 4.0 BY-SA版权
分类专栏： Oracle Oracle RAC Oracle ASM 文章标签： oracle Oracle ORACLE Oracle ASM oracle rac Oracle RAC
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/staricqxyz/article/details/8538384
本文介绍如何在Oracle RAC环境中使用ASM命令将spfile从一个磁盘组迁移到另一个磁盘组，并更新GPnP配置文件。文章包括具体步骤，如复制spfile、重启HA堆栈验证更改、移除原始spfile等。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

Copy spfile with -u option - to update GPnP profile in RAC environment

[grid@zhongwc1 ~]$ asmcmd lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576      5120     4716                0            4716              0             Y  CRS/
MOUNTED  NORMAL  N         512   4096  1048576     61440    56882                0           28441              0             N  DATADG/
MOUNTED  NORMAL  N         512   4096  1048576     51200    48726                0           24363              0             N  FRADG/
[grid@zhongwc1 ~]$ 
[grid@zhongwc1 ~]$ 
[grid@zhongwc1 ~]$ asmcmd spget
+CRS/cluster/asmparameterfile/registry.253.805303687
[grid@zhongwc1 ~]$ 
[grid@zhongwc1 ~]$ 
[grid@zhongwc1 ~]$ asmcmd spcopy -u +CRS/cluster/asmparameterfile/registry.253.805303687 +DATADG/spfileASM.ora
[grid@zhongwc1 ~]$ 
[grid@zhongwc1 ~]$ asmcmd
ASMCMD> ls -l
State    Type    Rebal  Name
MOUNTED  EXTERN  N      CRS/
MOUNTED  NORMAL  N      DATADG/
MOUNTED  NORMAL  N      FRADG/
ASMCMD> cd datadg
ASMCMD> ls -l
Type              Redund  Striped  Time             Sys  Name
                                                    Y    ZHONGWC/
                                                    Y    cluster/
                                                    N    spfileASM.ora => +DATADG/cluster/ASMPARAMETERFILE/REGISTRY.253.805563565

Restart the HA stack to verify that ASM starts up fine with copiedspfile

[root@zhongwc1 ~]# /u01/app/11.2.0/grid/bin/crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'zhongwc1'
CRS-2673: Attempting to stop 'ora.crsd' on 'zhongwc1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'zhongwc1'
CRS-2673: Attempting to stop 'ora.cvu' on 'zhongwc1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'zhongwc1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'zhongwc1'
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'zhongwc1'
CRS-2673: Attempting to stop 'ora.zhongwc.db' on 'zhongwc1'
CRS-2673: Attempting to stop 'ora.oc4j' on 'zhongwc1'
CRS-2677: Stop of 'ora.cvu' on 'zhongwc1' succeeded
CRS-2672: Attempting to start 'ora.cvu' on 'zhongwc2'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'zhongwc1' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'zhongwc1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'zhongwc1' succeeded
CRS-2673: Attempting to stop 'ora.zhongwc1.vip' on 'zhongwc1'
CRS-2677: Stop of 'ora.scan1.vip' on 'zhongwc1' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'zhongwc2'
CRS-2677: Stop of 'ora.zhongwc1.vip' on 'zhongwc1' succeeded
CRS-2672: Attempting to start 'ora.zhongwc1.vip' on 'zhongwc2'
CRS-2676: Start of 'ora.cvu' on 'zhongwc2' succeeded
CRS-2677: Stop of 'ora.zhongwc.db' on 'zhongwc1' succeeded
CRS-2673: Attempting to stop 'ora.DATADG.dg' on 'zhongwc1'
CRS-2673: Attempting to stop 'ora.FRADG.dg' on 'zhongwc1'
CRS-2676: Start of 'ora.zhongwc1.vip' on 'zhongwc2' succeeded
CRS-2677: Stop of 'ora.DATADG.dg' on 'zhongwc1' succeeded
CRS-2677: Stop of 'ora.FRADG.dg' on 'zhongwc1' succeeded
CRS-2676: Start of 'ora.scan1.vip' on 'zhongwc2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'zhongwc2'
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'zhongwc2' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'zhongwc1' succeeded
CRS-2672: Attempting to start 'ora.oc4j' on 'zhongwc2'
CRS-2676: Start of 'ora.oc4j' on 'zhongwc2' succeeded
CRS-2677: Stop of 'ora.CRS.dg' on 'zhongwc1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'zhongwc1'
CRS-2677: Stop of 'ora.asm' on 'zhongwc1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'zhongwc1'
CRS-2677: Stop of 'ora.ons' on 'zhongwc1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'zhongwc1'
CRS-2677: Stop of 'ora.net1.network' on 'zhongwc1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'zhongwc1' has completed
CRS-2677: Stop of 'ora.crsd' on 'zhongwc1' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'zhongwc1'
CRS-2673: Attempting to stop 'ora.crf' on 'zhongwc1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'zhongwc1'
CRS-2673: Attempting to stop 'ora.evmd' on 'zhongwc1'
CRS-2673: Attempting to stop 'ora.asm' on 'zhongwc1'
CRS-2677: Stop of 'ora.mdnsd' on 'zhongwc1' succeeded
CRS-2677: Stop of 'ora.crf' on 'zhongwc1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'zhongwc1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'zhongwc1' succeeded
CRS-2677: Stop of 'ora.asm' on 'zhongwc1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'zhongwc1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'zhongwc1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'zhongwc1'
CRS-2677: Stop of 'ora.cssd' on 'zhongwc1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'zhongwc1'
CRS-2677: Stop of 'ora.gipcd' on 'zhongwc1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'zhongwc1'
CRS-2677: Stop of 'ora.gpnpd' on 'zhongwc1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'zhongwc1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@zhongwc2 ~]# /u01/app/11.2.0/grid/bin/crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'zhongwc2'
CRS-2673: Attempting to stop 'ora.crsd' on 'zhongwc2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'zhongwc2'
CRS-2673: Attempting to stop 'ora.zhongwc2.vip' on 'zhongwc2'
CRS-2673: Attempting to stop 'ora.oc4j' on 'zhongwc2'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'zhongwc2'
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'zhongwc2'
CRS-2673: Attempting to stop 'ora.zhongwc.db' on 'zhongwc2'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'zhongwc2'
CRS-2673: Attempting to stop 'ora.cvu' on 'zhongwc2'
CRS-2677: Stop of 'ora.zhongwc2.vip' on 'zhongwc2' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'zhongwc2' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'zhongwc2'
CRS-2677: Stop of 'ora.scan1.vip' on 'zhongwc2' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'zhongwc2' succeeded
CRS-2673: Attempting to stop 'ora.zhongwc1.vip' on 'zhongwc2'
CRS-2677: Stop of 'ora.zhongwc1.vip' on 'zhongwc2' succeeded
CRS-2677: Stop of 'ora.zhongwc.db' on 'zhongwc2' succeeded
CRS-2673: Attempting to stop 'ora.DATADG.dg' on 'zhongwc2'
CRS-2673: Attempting to stop 'ora.FRADG.dg' on 'zhongwc2'
CRS-2677: Stop of 'ora.DATADG.dg' on 'zhongwc2' succeeded
CRS-2677: Stop of 'ora.FRADG.dg' on 'zhongwc2' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'zhongwc2' succeeded
CRS-2677: Stop of 'ora.cvu' on 'zhongwc2' succeeded
CRS-2677: Stop of 'ora.CRS.dg' on 'zhongwc2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'zhongwc2'
CRS-2677: Stop of 'ora.asm' on 'zhongwc2' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'zhongwc2'
CRS-2677: Stop of 'ora.ons' on 'zhongwc2' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'zhongwc2'
CRS-2677: Stop of 'ora.net1.network' on 'zhongwc2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'zhongwc2' has completed
CRS-2677: Stop of 'ora.crsd' on 'zhongwc2' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'zhongwc2'
CRS-2673: Attempting to stop 'ora.evmd' on 'zhongwc2'
CRS-2673: Attempting to stop 'ora.asm' on 'zhongwc2'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'zhongwc2'
CRS-2677: Stop of 'ora.evmd' on 'zhongwc2' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'zhongwc2' succeeded
CRS-2677: Stop of 'ora.asm' on 'zhongwc2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'zhongwc2'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'zhongwc2' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'zhongwc2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'zhongwc2'
CRS-2677: Stop of 'ora.cssd' on 'zhongwc2' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'zhongwc2'
CRS-2677: Stop of 'ora.crf' on 'zhongwc2' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'zhongwc2'
CRS-2677: Stop of 'ora.gipcd' on 'zhongwc2' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'zhongwc2'
CRS-2677: Stop of 'ora.gpnpd' on 'zhongwc2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'zhongwc2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@zhongwc1 ~]# /u01/app/11.2.0/grid/bin/crsctl start has
CRS-4123: Oracle High Availability Services has been started.
[root@zhongwc2 ~]# /u01/app/11.2.0/grid/bin/crsctl start has
CRS-4123: Oracle High Availability Services has been started.
[grid@zhongwc1 ~]$ asmcmd spget
+DATADG/spfileASM.ora


 Remove the original spfile
[grid@zhongwc1 ~]$ asmcmd ls -l +CRS/cluster/asmparameterfile
Type              Redund  Striped  Time             Sys  Name
ASMPARAMETERFILE  UNPROT  COARSE   JAN 21 15:00:00  Y    REGISTRY.253.805303687
[grid@zhongwc1 ~]$ asmcmd rm +CRS/cluster/asmparameterfile/REGISTRY.253.805303687

Verify that the new spfile is being used 

[grid@zhongwc1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 24 16:04:11 2013

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> set line 200
SQL> show parameter spfile

NAME				     TYPE		    VALUE
------------------------------------ ---------------------- ------------------------------
spfile				     string		    +DATADG/spfileasm.ora
SQL> select name,state from v$asm_diskgroup;

NAME							     STATE
------------------------------------------------------------ ----------------------
CRS							     MOUNTED
DATADG							     MOUNTED
FRADG							     MOUNTED


MOS:How to move ASM spfile to a different disk group [ID 1082943.1]

更改ASM实例的spfile路径方法
Samdy_Chan的专栏
09-23 5108
经测试，在ASM实例中，执行 createspfile from pfile;重新创建 spfile 文件时，会报如下错误： SQL> createspfile='+CRS/rac-cluster/ASMPARAMETERFILE/REGISTRY.253.858642645' frompfile='/home/grid/tmp/pfile1.ora'; createspfile='+C
创建ASM磁盘：Unable to instantiate disk "DATA1"
huangliang0703的专栏
10-17 1294
  在节点一创建了asm磁盘 ，下面是查到的asm磁盘：   [root@EAS-DB-RAC01 ~]# oracleasm listdisks ARCH DATA1 DATA2 DATA3 DATA4 VOT 在节点二上扫面的时候报错： [root@EAS-DB-RAC02 ~]# oracleasm scandisks Reloading disk partitions: don...
How to move ASM spfile to a different disk group [ID 1082943.1]
PrudentWoo 的个人空间
04-18 891
How to move ASM spfile to a different disk group [ID 1082943.1] Goal The goal is to move ASM spfile from one disk group to another. During initial ASM setup the spfile might have been created in
How To Move The Database To Different Diskgroup (Change Diskgroup Redundancy)
rede
04-03 194
Automatic Storage Management (ASM) is an integrated file system and volume manager expressly built for Oracle database files. This note is applicable : 1. If you wish to move to different A...
HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another No
小麦苗DBA宝典
07-18 363
How To Restore RMAN Disk backups of RAC Database to Single Instance On Anothe...
How To Move The Database To Different Diskgroup [ID 438580.1]
05-06 127
Applies to: Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.1.0.7 [Release 10.1 to 11.1]Oracle Dat...
asm指定路径对pfile和spfile相互创建
11-02
CREATE SPFILE FROM PFILE='/path/to/your/pfile.ora'; ``` 这会根据PFILE中的参数创建一个SPFILE。 5. **移动SPFILE到ASM**：一旦SPFILE创建成功，你可以将其移动到ASM磁盘组内的一个适当的目录，然后更新...
11G RAC重建ASM实例的SPFILE
白及
05-21 1345
环境： oracle rac 11.2.0.3  rhel 5  1、前提条件 需要知道以下信息：   1）、节点数量   2）、ASM磁盘组包括的磁盘所在位置   3）、实例有那几个磁盘组 2、步骤及重建脚本   1）成功的脚本： *.cluster_database_instances=2 +ASM1.instance_name='+ASM1'
ASM ClassReader failed to parse class
最新发布
平安喜乐
08-18 1687
全面测试并支持在长期支持（LTS）版本的 JDK 上运行 Spring，目前包括 JDK 8、JDK 11、JDK 17 和 JDK 21。此外，我们对中间版本（如 JDK 18、19、20）提供最佳努力支持，接受 bug 报告并尽可能解决这些问题，但不提供任何服务级别保证。Spring Framework 5.1 需要 JDK 8 或更高版本，并首次专门支持 JDK 11。最后建议，springboot版本在6.0.0以上的，最低选择jdk 17，17最低支持5.3.x。Spring wiki介绍。
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (一)
热门推荐
Zhong Weicheng Study Notes
12-28 1万+
有关于Oracle Linux 6的安装可以参考Oracle Linux 6 Installation。安装两台OL6分配两个网卡内存均为3G,hostname分别为node1和node2。 OS版本你也可以选择CentOS6或者是RHEL6,建议初次安装选择CentOS6/RHEL6。选择Oracle Linux6可以使用OL6提供的oracle-rdbms-server-11gR2-prei
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (四)
Zhong Weicheng Study Notes
12-29 1万+
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (一) 使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (二) 使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (三) 将安装介质上传到node1,解压准备安装grid infrast
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (三)
Zhong Weicheng Study Notes
12-28 1万+
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (一) 使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (二) 配置共享磁盘,本次实验环境是基于VMware ESXi 5搭建。 和vbox配置差不多,具体过程略,关闭node1,node2,说明一下需要注意的地方 SCSI
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (二)
Zhong Weicheng Study Notes
12-28 1万+
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (一) 在所有node上创建oracle,grid用户,创建相关目录 [root@node2 ~]# groupadd -g 1000 oinstall [root@node2 ~]# groupadd -g 1200 asmadmin [root@node2 ~]# groupadd
Add a Node to Oracle RAC 11gR2(11.2.0.3) on Oracle Linux 6
Zhong Weicheng Study Notes
01-05 1万+
Delete a Node from Oracle RAC 11gR2(11.2.0.3) on Oracle Linux 6 This guide shows how to add a node to an existing 11gR2(11.2.0.3) Oracle RAC cluster. It is assumed that the node in question is
Delete a Node from Oracle RAC 11gR2(11.2.0.3) on Oracle Linux 6
Zhong Weicheng Study Notes
01-05 1万+
Add a Node to Oracle RAC 11gR2(11.2.0.3) on Oracle Linux 6 This guide shows how to remove a node from an existing 11gR2 Oracle RAC cluster. It is assumed that the node in question is available an
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (五)
Zhong Weicheng Study Notes
12-29 9043
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (一) 使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (二) 使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (三) 使用UDEV在Oracle Linux 6上安装Oracle 11g R
查询Oracle RAC Cache Fusion通信的私有网络
Zhong Weicheng Study Notes
01-22 6911
[oracle@zhongwc1 ~]$ cat /etc/redhat-release Red Hat Enterprise Linux Server release 5.7 (Tikanga) [oracle@zhongwc1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Tue Jan 22 15:1
GoldenGate将Oracle数据同步到GreenPlum
Zhong Weicheng Study Notes
02-16 6835
源端 Oracle 11.2.0.4 RAC 2-Nodes Oracle Linux 5.8 x86_64 目标端 Greenplum Database 4.2.6.1 4-Nodes CentOS 5.7 x86_64 ====================================================== 源端配置 --本例是将OGG安
从asm spfile启数据库实例
05-28
您可以按照以下步骤使用 ASM SPFILE 启动数据库实例： 1. 确保 ASM 实例已经启动并且数据库实例的 SPFILE 文件已经存储在 ASM 中。 2. 在数据库实例的 $ORACLE_HOME/dbs 目录下创建一个文本文件，命名为 init<ORACLE_SID>.ora，其中 <ORACLE_SID> 是要启动的数据库实例的 SID。 3. 在 init<ORACLE_SID>.ora 文件中添加以下参数： ``` SPFILE='+ASM/<DATABASE_SID>/spfile<DATABASE_SID>.ora' ``` 其中，<DATABASE_SID> 是要启动的数据库实例的 SID。 4. 打开终端，以 Oracle 软件所有者的身份登录，切换到 ORACLE_HOME/bin 目录。 5. 运行以下命令以启动数据库实例： ``` sqlplus / as sysdba startup ``` 如果一切正常，数据库实例应该会启动并且使用 ASM 中的 SPFILE 文件。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值