该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
环境:RAC 112040
ORA-01114:将块写入文件 16 时出现 IO 错误 (块 # 1734107)
ORA-29701:无法连接到集群同步服务
SELECT t.* FROM DBA_DATA_FILES t where t.FILE_ID = '16';
查询结果如下:
FILE_NAME +DGDATA/tbs_data11.dbf
FILE_ID 16
TABLESPACE_NAME TBS_DATA
BYTES 31457280000
BLOCKS 3840000
STATUS AVAILABLE
RELATIVE_FNO 16
AUTOEXTENSIBLE NO
MAXBYTES 0
MAXBLOCKS 0
INCREMENT_BY 0
USER_BYTES 31456231424
USER_BLOCKS 3839872
ONLINE_STATUS ONLINE
文件系统空间还有空余(表空间也查了,都还有很多):
root@P730adb2# df -m
Filesystem MB blocks Free %Used Iused %Iused Mounted on
/dev/hd4 10240.00 9804.70 5% 11639 1% /
/dev/hd2 10240.00 7721.05 25% 53073 3% /usr
/dev/hd9var 10240.00 9890.93 4% 6440 1% /var
/dev/hd3 10240.00 3547.88 66% 7413 1% /tmp
/dev/hd1 10240.00 10165.46 1% 1172 1% /home
/dev/hd11admin 10240.00 10238.10 1% 5 1% /admin
/proc - - - - - /proc
/dev/hd10opt 10240.00 9992.14 3% 9627 1% /opt
/dev/livedump 10240.00 10238.12 1% 4 1% /var/adm/ras/livedump
/dev/oraclelv 51200.00 23822.75 54% 660350 11% /oracle
/dev/ptfslv 10240.00 2067.86 80% 4508 1% /ptfs
/aha - - - 18 1% /aha
请求指点一下,这个错可以从哪些方面着手检查。谢谢主。