2019-08-27
oracle 10g rac 存储问题
数据库为 oracle 10.2.0.4.0
操作系统为 hp-ux
由于断电导致部分磁盘阵列故障,在mount磁盘组的时候 报磁盘丢失
SQL> alter diskgroup datadg mount ; alter diskgroup datadg mount * ERROR at line 1: ORA-15032: not all alterations performed ORA-15040: diskgroup is incomplete ORA-15042: ASM disk "47" is missing ORA-15042: ASM disk "46" is missing ORA-15042: ASM disk "45" is missing ORA-15042: ASM disk "44" is missing ORA-15042: ASM disk "43" is missing ORA-15042: ASM disk "42" is missing ORA-15042: ASM disk "41" is missing ORA-15042: ASM disk "40" is missing ORA-15042: ASM disk "39" is missing ORA-15042: ASM disk "38" is missing ORA-15042: ASM disk "31" is missing
如果容许一定数据丢失,如何处理?
共享磁盘采用裸设备绑定方式
$ /usr/sbin/ioscan -fun -C disk Class I H/W Path Driver S/W State H/W Type Description ======================================================================= disk 0 0/0/0/2/0.6.0 sdisk CLAIMED DEVICE HP 146 GST3146855LC /dev/dsk/c0t6d0 /dev/dsk/c0t6d0s2 /dev/rdsk/c0t6d0 /dev/rdsk/c0t6d0s2 /dev/dsk/c0t6d0s1 /dev/dsk/c0t6d0s3 /dev/rdsk/c0t6d0s1 /dev/rdsk/c0t6d0s3 disk 1 0/0/0/2/1.2.0 sdisk CLAIMED DEVICE Optiarc DVD RW AD-5200A /dev/dsk/c1t2d0 /dev/rdsk/c1t2d0 disk 2 0/0/0/3/0.6.0 sdisk CLAIMED DEVICE HP 146 GST3146855LC /dev/dsk/c2t6d0 /dev/dsk/c2t6d0s2 /dev/rdsk/c2t6d0 /dev/rdsk/c2t6d0s2 /dev/dsk/c2t6d0s1 /dev/dsk/c2t6d0s3 /dev/rdsk/c2t6d0s1 /dev/rdsk/c2t6d0s3 disk 386 0/0/1/1/0.1.0.0.0.0.1 sdisk CLAIMED DEVICE HP HSV300 /dev/dsk/c28t0d1 /dev/rdsk/c28t0d1 disk 387 0/0/1/1/0.1.0.0.0.0.2 sdisk CLAIMED DEVICE HP HSV300 /dev/dsk/c28t0d2 /dev/rdsk/c28t0d2 disk 388 0/0/1/1/0.1.0.0.0.0.3 sdisk CLAIMED DEVICE HP HSV300 /dev/dsk/c28t0d3 /dev/rdsk/c28t0d3 disk 389 0/0/1/1/0.1.0.0.0.0.4 sdisk CLAIMED DEVICE HP HSV300 /dev/dsk/c28t0d4 /dev/rdsk/c28t0d4 disk 390 0/0/1/1/0.1.0.0.0.0.5 sdisk CLAIMED DEVICE HP HSV300 /dev/dsk/c28t0d5 /dev/rdsk/c28t0d5 disk 391 0/0/1/1/0.1.0.0.0.0.6 sdisk CLAIMED DEVICE HP HSV300 /dev/dsk/c28t0d6 /dev/rdsk/c28t0d6 disk 392 0/0/1/1/0.1.0.0.0.0.7 sdisk CLAIMED DEVICE HP HSV300 /dev/dsk/c28t0d7 /dev/rdsk/c28t0d7 disk 393 0/0/1/1/0.1.0.0.0.1.0 sdisk CLAIMED DEVICE HP HSV300 /dev/dsk/c28t1d0 /dev/rdsk/c28t1d0 disk 394 0/0/1/1/0.1.0.0.0.1.1 sdisk CLAIMED DEVICE HP HSV300 /dev/dsk/c28t1d1 /dev/rdsk/c28t1d1 disk 395 0/0/1/1/0.1.0.0.0.1.2 sdisk CLAIMED DEVICE HP HSV300 /dev/dsk/c28t1d2 /dev/rdsk/c28t1d2 # ioscan -m dsf Persistent DSF Legacy DSF(s) ======================================== /dev/rtape/tape1_BEST /dev/rmt/c4t1d0BEST /dev/rtape/tape1_BESTn /dev/rmt/c4t1d0BESTn /dev/rtape/tape1_BESTb /dev/rmt/c4t1d0BESTb /dev/rtape/tape1_BESTnb /dev/rmt/c4t1d0BESTnb /dev/rdisk/disk3 /dev/rdsk/c0t6d0 /dev/rdisk/disk3_p1 /dev/rdsk/c0t6d0s1 /dev/rdisk/disk3_p2 /dev/rdsk/c0t6d0s2 /dev/rdisk/disk3_p3 /dev/rdsk/c0t6d0s3 /dev/rdisk/disk4 /dev/rdsk/c1t2d0 /dev/rdisk/disk5 /dev/rdsk/c2t6d0 /dev/rdisk/disk5_p1 /dev/rdsk/c2t6d0s1 /dev/rdisk/disk5_p2 /dev/rdsk/c2t6d0s2 /dev/rdisk/disk5_p3 /dev/rdsk/c2t6d0s3 /dev/pt/pt8 /dev/rscsi/c29t0d0 /dev/rscsi/c27t0d0 /dev/rscsi/c37t0d0 /dev/rscsi/c35t0d0 /dev/rscsi/c6t0d0 /dev/rscsi/c8t0d0 /dev/rscsi/c12t0d0 /dev/rscsi/c10t0d0 /dev/rdisk/disk10 /dev/rdsk/c30t0d1 /dev/rdsk/c28t0d1 /dev/rdsk/c38t0d1 /dev/rdsk/c36t0d1 /dev/rdsk/c7t0d1 /dev/rdsk/c9t0d1 /dev/rdsk/c13t0d1 /dev/rdsk/c11t0d1 /dev/rdisk/disk171 /dev/rdsk/c30t0d2
收藏
分享
2条回答
默认
最新
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏

评论
