急救！！在裸设备上将lv添加如原有表空间出错（在线等）

显示全部楼层 · 2007-5-20 04:01:01

SQL> alter tablespace unicall2x add datafile '/dev/ora_unicall1';
alter tablespace unicall2x add datafile '/dev/ora_unicall1'
*
ERROR at line 1:
ORA-01115: IO error reading block from file 9 (block # 1)
ORA-01110: data file 9: '/dev/ora_unicall1'
ORA-27091: unable to queue I/O
ORA-27069: attempt to do I/O beyond the range of the file
Additional information: 1
Additional information: 1

千问 · 2007-5-20 04:01:01

ALTER TABLESPACE unicall2x ADD DATAFILE '/dev/rora_unicall1' size 5999m;
[ 本帖最后由 OneGoodDream 于 2008-9-24 20:05 编辑 ]

千问 · 2007-5-20 04:01:01

试用了楼上的，报错如下：
另外有点不明白，/dev/ora_unicall1 是我以前建好的一个10g 的LV ，还有必要指定size吗？
alter tablespace unicall2x add datafile '/dev/ora_unicall1'size 5999m
*
ERROR at line 1:
ORA-01119: error in creating database file '/dev/ora_unicall1'
ORA-27086: unable to lock file - already in use
IBM AIX RISC System/6000 Error: 13: Permission denied
Additional information: 8
Additional information: 463086

千问 · 2007-5-20 04:01:01

ORA-01119: error in creating database file '/dev/ora_unicall1'
ORA-27086: unable to lock file - already in use

select name from v$datafile;
检查是不是已经被使用

千问 · 2007-5-20 04:01:01

没有被用

千问 · 2007-5-20 04:01:01

文件属组是否正确？

千问 · 2007-5-20 04:01:01

正确，加之前都改过了
chown oracle:dba/dev/ora_unicall1
chmo 600 /dev/ora_unicall1

千问 · 2007-5-20 04:01:01

fuser /dev/ora_unicall1

千问 · 2007-5-20 04:01:01

[oracle@SHUDB-A] fuser /dev/rora_unicall1
/dev/rora_unicall1: 463086782442 1200348

千问 · 2007-5-20 04:01:01

操作系统是aix吧，如果是，裸设备是lv名前加r，你的就应该是rora_unical1