共享磁盘均损坏:
/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;