aix小机rac仲裁盘故障处理

文章详细描述了在OracleGrid环境中修复共享磁盘损坏的问题,通过NFS临时共享作为仲裁盘,并执行dd操作复制数据。文章还涉及了CRS投票盘的管理、磁盘组的创建与故障处理,以及ASM参数配置和OracleClusterRegistry的状态检查。
摘要由CSDN通过智能技术生成

共享磁盘均损坏:

/dev/rhdisk22

/dev/rhdisk23

/dev/rhdisk24

不能正常dd去读写。

临时本地nfs共享做仲裁盘,配置nfs服务端

root@ptdb2:/# vi /etc/exports

/grid/ocr -rw

exportfs -a

# more /etc/exports

/grid/ocr -rw

如果没有/etc/exports文件,使用mknfs命令之后,nfsd、rpc.mounted进程不会启动,需要添加一个空的此文件。

/usr/sbin/mknfsexp -d '/grid/ocr/' -t 'rw' -c '192.168.80.82',-r '192.168.80.82'

dd几块盘:

dd if=/dev/zero of=/grid/ocr/ocrvote bs=1M count=1024

dd if=/dev/zero of=/grid/ocr/ocrvote1 bs=1M count=1024

dd if=/dev/zero of=/grid/ocr/ocrvote2 bs=1M count=1024

# mknfs -N

检查nfs是否启动

# lssrc -g nfs

# startsrc -g nfs

# lssrc -g nfs

# stopsrc -g nfs

在客户端检查进程 portmap是否启动正常

# lssrc -s portmap (状态为active即可)

客户端挂载:

mount -o rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,noac,vers=3,timeo=600,actimeo=0 192.168.80.82:/grid/ocr /home/grid/ocr

独占模式启动

# crsctl start crs -excl -nocrs

尝试创建并删除磁盘组:

alter diskgroup CRSVOTEDISK add disk '/home/grid/ocr/ocrvote1','/home/grid/ocr/ocrvote2';

drop diskgroup CRSVOTEDISK;

创建仲裁盘磁盘组:

create diskgroup CRS normal redundancy disk '/home/grid/ocr/ocrvote','/home/grid/ocr/ocrvote1','/home/grid/ocr/ocrvote2' attribute 'compatible.asm'='11.2.0.0.0';

grid@ptdb2:/grid/product/11.2.0/cdata/ptdb-scan$ls

backup00.ocr backup01.ocr backup02.ocr day.ocr day_.ocr week.ocr week_.ocr

/grid/product/11.2.0/bin/ocrconfig -add CRS

--ocr必须同名

/grid/product/11.2.0/bin/ocrconfig -restore /grid/product/11.2.0/cdata/ptdb-scan/backup00.ocr

asm参数文件配置:

vi /tmp/asm.ora

+ASM1.__oracle_base='/oracle/gridbase'

+ASM2.__oracle_base='/oracle/gridbase'

*.asm_diskgroups='ORAARCH','ORADATA'

*.asm_diskstring='/home/grid/ocr/*','/dev/*'

*.remote_login_passwordfile='EXCLUSIVE'

恢复参数文件:

SQL> create spfile='+CRS' from pfile='/tmp/asm.ora';

File created.

仲裁更新:

root@ptdb2:/# crsctl replace votedisk +CRS

Successful addition of voting disk afdb3b18fe1f4f85bf37550a823d97ad.

Successful addition of voting disk 5a69013ca02d4f9fbfc259f7d9c16fa5.

Successful addition of voting disk 6174d51a9e7a4fcabf901ccb12caf750.

Successfully replaced voting disk group with +CRS.

CRS-4266: Voting file(s) successfully replaced

ocr检测:

root@ptdb2:/# ocrcheck

Status of Oracle Cluster Registry is as follows :

Version : 3

Total space (kbytes) : 262120

Used space (kbytes) : 3052

Available space (kbytes) : 259068

ID : 310012129

Device/File Name : +CRS

Device/File integrity check succeeded

Device/File not configured

Device/File not configured

Device/File not configured

Device/File not configured

Cluster registry integrity check succeeded

Logical corruption check succeeded

仲裁盘检测:

root@ptdb2:/# crsctl query css votedisk

## STATE File Universal Id File Name Disk group

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

1. ONLINE afdb3b18fe1f4f85bf37550a823d97ad (/home/grid/ocr/ocrvote) [CRS]

2. ONLINE 5a69013ca02d4f9fbfc259f7d9c16fa5 (/home/grid/ocr/ocrvote1) [CRS]

3. ONLINE 6174d51a9e7a4fcabf901ccb12caf750 (/home/grid/ocr/ocrvote2) [CRS]

如果磁盘组不能起来:

[crsd(47710632)]CRS-2807:Resource 'ora.ORAARCH.dg' failed to start automatically.

2022-05-19 14:36:24.630:

[crsd(47710632)]CRS-2807:Resource 'ora.ORADATA.dg' failed to start automatically.

2022-05-19 14:36:24.631:

[crsd(47710632)]CRS-2807:Resource 'ora.portaldb.db' failed to start automatically.

检测配置:

SQL> show parameter asm

NAME TYPE

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

VALUE

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

asm_diskgroups string

asm_diskstring string

/home/grid/ocr/*

asm_power_limit integer

1

asm_preferred_read_failure_groups string

SQL> alter system set asm_diskgroups='ORAARCH','ORADATA';

System altered.

SQL> alter system set asm_diskstring='/home/grid/ocr/*','/dev/*';

$ kfod di=all

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

Disk Size Path User Group

================================================================================

1: 315392 Mb /dev/rhdisk10 grid asmadmin

2: 315392 Mb /dev/rhdisk11 grid asmadmin

3: 315392 Mb /dev/rhdisk12 grid asmadmin

4: 315392 Mb /dev/rhdisk13 grid asmadmin

5: 315392 Mb /dev/rhdisk14 grid asmadmin

6: 315392 Mb /dev/rhdisk15 grid asmadmin

7: 315392 Mb /dev/rhdisk16 grid asmadmin

8: 315392 Mb /dev/rhdisk17 grid asmadmin

9: 315392 Mb /dev/rhdisk18 grid asmadmin

10: 315392 Mb /dev/rhdisk19 grid asmadmin

11: 315392 Mb /dev/rhdisk2 grid asmadmin

12: 315392 Mb /dev/rhdisk20 grid asmadmin

13: 315392 Mb /dev/rhdisk21 grid asmadmin

14: 1024 Mb /dev/rhdisk22 grid asmadmin

15: 1024 Mb /dev/rhdisk23 grid asmadmin

16: 1024 Mb /dev/rhdisk24 grid asmadmin

17: 315392 Mb /dev/rhdisk3 grid asmadmin

18: 315392 Mb /dev/rhdisk4 grid asmadmin

19: 315392 Mb /dev/rhdisk5 grid asmadmin

20: 315392 Mb /dev/rhdisk6 grid asmadmin

21: 315392 Mb /dev/rhdisk7 grid asmadmin

22: 315392 Mb /dev/rhdisk8 grid asmadmin

23: 315392 Mb /dev/rhdisk9 grid asmadmin

24: 2048 Mb /home/grid/ocr/ocrvote grid asmadmin

25: 2048 Mb /home/grid/ocr/ocrvote1 grid asmadmin

26: 2048 Mb /home/grid/ocr/ocrvote2 grid asmadmin

然后在mout起来:

alter diskgroup ORAARCH mount;

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值