oracle shutdown 报错

[shenghuiping2001]

我的tablespace 文件少了一个，现在重启database 报错：
SQL> shutdown immediate;
ORA-01116: error in opening database file 7
ORA-01110: data file 7: '/u02/ezhoudg/ezhoudgdata03.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3

大家有没有解决方法啊？

[qin_phoenix]

[oracle@jumper eygle]$ sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Sun Aug 20 01:22:50 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area  252777592 bytes
Fixed Size                   451704 bytes
Variable Size             134217728 bytes
Database Buffers          117440512 bytes
Redo Buffers                 667648 bytes
Database mounted.


SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: '/opt/oracle/oradata/eygle/eygle02.dbf'


SQL> alter database create datafile 3 as '/opt/oracle/oradata/eygle/eygle02.dbf';

Database altered.

SQL> select name from v$datafile;

NAME
-------------------------------------------------------
/opt/oracle/oradata/eygle/system01.dbf
/opt/oracle/oradata/eygle/undotbs01.dbf
/opt/oracle/oradata/eygle/eygle02.dbf
/opt/oracle/oradata/eygle/eygle01.dbf

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 3 needs media recovery
ORA-01110: data file 3: '/opt/oracle/oradata/eygle/eygle02.dbf'


SQL> recover datafile 3;
Media recovery complete.
SQL> alter database open;

Database altered.

[luoyoumou]

-- 悲哀，数据文件出问题啦，可能要将这个数据文件offline ，或这个数据文件涉及到的表空间offline，
-- 才能将数据库关闭！
--       这个数据文件找不到：ORA-27041: unable to open file
                            Linux Error: 2: No such file or directory

-- 这么明显的错误也看不懂么？
-- *1) 去查一下：路径下面的文件是否存在：/u02/ezhoudg/ezhoudgdata03.dbf
-- *2) 如果文件存在，看其文件的属主及权限，Oracle用户是否有相应的读、写权限？

[shenghuiping2001]

谢谢，确实这个文件没有了，我开了归档，可以恢复吗？
SQL> select FILE_NAME,TABLESPACE_NAME,ONLINE_STATUS from dba_data_files where TABLESPACE_NAME='EZHOUDGDATA';

FILE_NAME TABLESPACE_NAME ONLINE_
------------------------------ ------------------------------ -------
/u02/ezhoudg/ezhoudgdata03.dbf EZHOUDGDATA RECOVER
/u02/ezhoudg/ezhoudgdata01.dbf EZHOUDGDATA ONLINE
/u02/ezhoudg/ezhoudgdata02.dbf EZHOUDGDATA ONLINE

SQL> recover datafile '/u02/ezhoudg/ezhoudgdata03.dbf';
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 7: '/u02/ezhoudg/ezhoudgdata03.dbf'
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/u02/ezhoudg/ezhoudgdata03.dbf'

[ruihuahan]

recover 操作需要数据文件已存在。
如果有备份的话，从备份中把数据文件 restore 回来，然后再 recover。
只有归档日志的话，恐怕不行。

[shenghuiping2001]

那这个datafile 的文件没了，这个tablespace 里的data 就恢复不回来啦啊？就没哟其他的办法吗？