51Testing软件测试论坛

标题: 帮忙解决ORA-01157的问题 [打印本页]

作者: 金鱼先生 时间: 2012-7-31 08:49
标题: 帮忙解决ORA-01157的问题
帮忙解决ORA-01157的问题

信息如下：

SQL> startup
ORACLE instance started.

Total System Global Area  784998400 bytes
Fixed Size                2163800 bytes
Variable Size          239078312 bytes
Database Buffers       536870912 bytes
Redo Buffers             6885376 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/dev/vg_index/rsdp_dls_dlscidx_data_0001'

然后：
SQL> alter database datafile '/dev g_data/rsdp_dls_dlsc_data_0001' offline drop;

Database altered.

但是还是提示问题存在：
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/dev g_index/rsdp_dls_dlscidx_data_0001'

文件：
rsdp_dls_dlsc_data_0001 -> /dev/raw/raw21

请问怎么解决该问题？

欢迎光临 51Testing软件测试论坛 (http://bbs.51testing.com/)