How to move ASM spfile to a different disk group [ID 1082943.1] 适用于11R2 有两种方法:采用create pfile/spflie通过中间文件迁移;适用asmcmd自带的spcopy命令; 第一种方法比较简单,步骤如下 create pfile='/tmp/pfile+ASM.ora' from spfile; create spfile='+PLAY' from pfile='/tmp/pfile+ASM.ora'; crsctl stop has crsctl start has --重启验证 下面介绍一下spcopy命令 由于GPnP profile记录有spfile路径信息,因此需添加-u选项自动更新 1. Copy spfile with -u option - to update GPnP profile in RAC environment $ asmcmd spget +DATA/asm/asmparameterfile/registry.253.722601213 $ asmcmd lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Votin g_files Name MOUNTED EXTERN N 512 4096 1048576 14658 9814 0 9814 0 N DATA/ MOUNTED EXTERN N 512 4096 1048576 9772 8507 0 8507 0 N PLAY/ MOUNTED EXTERN N 512 4096 1048576 9772 9212 0 9212 0 N RECO/ $ asmcmd spcopy -u +DATA/asm/asmparameterfile/registry.253.722601213 +PLAY/spfileASM.ora 2. Restart the HA stack to verify that ASM starts up fine with copiedspfile $ crsctl stop has CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on '<server>' ... CRS-4133: Oracle High Availability Services has been stopped. $ crsctl start has CRS-4123: Oracle High Availability Services has been started. $ asmcmd spget +PLAY/spfileASM.ora 3. Remove the original spfile $ asmcmd ls -l +DATA/asm/asmparameterfile Type Redund Striped Time Sys Name ASMPARAMETERFILE UNPROT COARSE JUN 25 10:00:00 Y REGISTRY.253.722601213 $ asmcmd rm +DATA/asm/asmparameterfile/registry.253.722601213 NOTE: The disk group that holds ASM spfile has to have COMPATIBLE.ASM value of 11.2 or higher.
ASM下迁移spfile
来源:这里教程网
时间:2026-03-03 11:41:33
作者:
编辑推荐:
- 在word自选图形中怎么使用特定的图片填充颜色03-03
- ASM下迁移spfile03-03
- word2010图片组合怎么对组合后的图形对象进行移动修改03-03
- 11G RAC+DG搭建03-03
- word2010如何查找替换字体字号颜色等格式03-03
- 如何在打开该Word文档时自动更新时间03-03
- Word2010文档如何添加设置默认打印机03-03
- word文档下划线怎么打下划线怎么输入03-03
下一篇:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- Oracle 11gASM新特性总结
Oracle 11gASM新特性总结
26-03-03 - RAC进程详解
RAC进程详解
26-03-03 - ORA-00257:archive log error.connect internal only,until freed.
- Oracle查看历史TOP SQL
Oracle查看历史TOP SQL
26-03-03 - oracle sql优化之基数反馈(Cardinality feedback)问题
- APEX 动态操作案例学习
APEX 动态操作案例学习
26-03-03 - PostgreSQL通过mysql_fdw连通MySQL实战
PostgreSQL通过mysql_fdw连通MySQL实战
26-03-03 - Ubiquiti 推出 Wi-Fi 7 接入点 Unifi U7 Mesh:BE5000,兼容室内外环境
- Redis数据存储原理和结构解读
Redis数据存储原理和结构解读
26-03-03 - MySQL主从复制过滤配置的完整方案
MySQL主从复制过滤配置的完整方案
26-03-03
