从ocr磁盘里获取asm spfile和voting file
环境:
OS:Centos 7
DB:12.2.0.1
当Oracle ASM实例查找初始化参数文件时,会从GPnP profile文件中查找
获取spfile文件
[grid@rac01 ~]$ cd $ORACLE_HOME/gpnp/rac01/profiles/peer
[grid@rac01 peer]$ gpnptool getpval -asm_spf
Warning: some command line parameters were defaulted. Resulting command line:
/u01/grid/grid_home/12.2.0.1/bin/gpnptool.bin getpval -asm_spf -p=profile.xml -o-
+OCR/rac-cluster/ASMPARAMETERFILE/registry.253.1154785957
获取ocr磁盘路径
[grid@rac01 peer]$ gpnptool getpval -p=profile.xml -asm_dis -o-
/dev/mapper/*
1.从ocr磁盘里获取asm spfile文件内容
[grid@rac01 peer]$ kfed read /dev/mapper/ocrdisk01 | grep -E 'spf|ausize'
kfdhdb.ausize: 4194304 ; 0x0bc: 0x00400000
kfdhdb.spfile: 0 ; 0x0f4: 0x00000000
kfdhdb.spfflg: 0 ; 0x0f8: 0x00000000
[grid@rac01 peer]$ kfed read /dev/mapper/ocrdisk02 | grep -E 'spf|ausize'
kfdhdb.ausize: 4194304 ; 0x0bc: 0x00400000
kfdhdb.spfile: 0 ; 0x0f4: 0x00000000
kfdhdb.spfflg: 0 ; 0x0f8: 0x00000000
[grid@rac01 peer]$ kfed read /dev/mapper/ocrdisk03 | grep -E 'spf|ausize'
kfdhdb.ausize: 4194304 ; 0x0bc: 0x00400000
kfdhdb.spfile: 2177 ; 0x0f4: 0x00000881
kfdhdb.spfflg: 1 ; 0x0f8: 0x00000001
[grid@rac01 peer]$ kfed read /dev/mapper/ocrdisk04 | grep -E 'spf|ausize'
kfdhdb.ausize: 4194304 ; 0x0bc: 0x00400000
kfdhdb.spfile: 0 ; 0x0f4: 0x00000000
kfdhdb.spfflg: 0 ; 0x0f8: 0x00000000
这里spfile就存放在/dev/mapper/ocrdisk03
[grid@rac01 peer]$ dd if=/dev/mapper/ocrdisk03 of=/tmp/ASMspfile_copy.ora skip=2177 bs=4M count=1
1+0 records in
1+0 records out
4194304 bytes (4.2 MB) copied, 0.00781124 s, 537 MB/s
[grid@rac01 peer]$ strings /tmp/ASMspfile_copy.ora | more
+ASM1.__oracle_base='/u01/grid/grid_base'#ORACLE_BASE set from in memory value
+ASM2.__oracle_base='/u01/grid/grid_base'#ORACLE_BASE set from in memory value
*.asm_diskgroups='DATA','OCR','ARCH'#Manual Mount
*.asm_diskstring='/dev/mapper/*'
*.asm_power_limit=1
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'
2.获取voting file
同样的方式也可以查找voting file
[grid@rac01 peer]$ kfed read /dev/mapper/ocrdisk01 | grep vf
kfdhdb.vfstart: 0 ; 0x0ec: 0x00000000
kfdhdb.vfend: 0 ; 0x0f0: 0x00000000
[grid@rac01 peer]$ kfed read /dev/mapper/ocrdisk02 | grep vf
kfdhdb.vfstart: 0 ; 0x0ec: 0x00000000
kfdhdb.vfend: 0 ; 0x0f0: 0x00000000
[grid@rac01 peer]$ kfed read /dev/mapper/ocrdisk03 | grep vf
kfdhdb.vfstart: 0 ; 0x0ec: 0x00000000
kfdhdb.vfend: 0 ; 0x0f0: 0x00000000
[grid@rac01 peer]$ kfed read /dev/mapper/ocrdisk04 | grep vf
kfdhdb.vfstart: 24 ; 0x0ec: 0x00000018
kfdhdb.vfend: 32 ; 0x0f0: 0x00000020
这里voting file就存放在/dev/mapper/ocrdisk04,使用如下命令查询也是返回/dev/mapper/ocrdisk04
[grid@rac01 peer]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE e3d7ba56bf7f4fbfbffae07e1611e53a (/dev/mapper/ocrdisk04) [OCR]
Located 1 voting disk(s).
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· DeepSeek 开源周回顾「GitHub 热点速览」
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布:重大改进与新特性概览!
· AI与.NET技术实操系列(二):开始使用ML.NET
· 单线程的Redis速度为什么快?
2022-12-06 postgres-xl安装部署(9.5)
2021-12-06 部署安装redislive
2021-12-06 goldengate清理多个源的日志文件
2021-12-06 使用expdp和impdp进行goldengate初始化
2019-12-06 表空间数据文件迁移到另外的位置(backup as copy tablespace)
2019-12-06 pl/sql无法登录12c问题
2019-12-06 ORA-00845: MEMORY_TARGET not supported on this system