暂无图片
分享
文成
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条回答
默认
最新
盖国强

amdu 试一下能不能读出数据

暂无图片 评论
暂无图片 有用 0
文成
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏