从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).

 

posted @   slnngk  阅读(82)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 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
点击右上角即可分享
微信分享提示