ORA-01113 解决办法

   今天在检查接口机的时候，发现速度奇慢，于是，就查了一下v$session表，可是很不幸，查询的速度慢的要命，前几天备份的时候也没有出现问题，没办法，关闭后重启一次吧，可是关闭的时候出现了

ORA-01113: file 9 needs media recovery
ORA-01110: data file 9: '/data2/oracle/oradata/MOSS/users01.dbf'

的错误，怎么回事呢，原来也没有修改过什么，也没有操作过users表空间啊，没办法，于是shutdown abort;

$ sqlplus
 
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Oct 10 12:01:17 2006
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
Enter user-name: / as sysdba
 
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
 
SQL> startup mount;
ORACLE instance started.
 
Total System Global Area 1108838600 bytes
Fixed Size                   731336 bytes
Variable Size             973078528 bytes
Database Buffers          134217728 bytes
Redo Buffers                 811008 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 9 needs media recovery
ORA-01110: data file 9: '/data2/oracle/oradata/MOSS/users01.dbf'
 
 
SQL> recovery database;
SP2-0734: unknown command beginning "recovery d..." - rest of line ignored.
S
 
SQL> alter database datafile '/oracle/oradata/MOSS/USERS01.DBF' online;
alter database datafile '/oracle/oradata/MOSS/USERS01.DBF' online
*
ERROR at line 1:
ORA-01516: nonexistent log file, datafile, or tempfile
"/oracle/oradata/MOSS/USERS01.DBF"
 
 
SQL> l
  1* alter database datafile '/oracle/oradata/MOSS/USERS01.DBF' online
SQL> c /oracle/data2
  1* alter database datafile '/data2/oradata/MOSS/USERS01.DBF' online
SQL> /
alter database datafile '/data2/oradata/MOSS/USERS01.DBF' online
*
ERROR at line 1:
ORA-01516: nonexistent log file, datafile, or tempfile
"/data2/oradata/MOSS/USERS01.DBF"
 
 
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
$ sqlplus
 
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Oct 10 12:03:53 2006
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
Enter user-name: / as sysdba
 
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
 
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
$ pwd
/data2/oracle/oradata/MOSS
$ sqlpus
sqlpus: not found
$ sqlplus
 
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Oct 10 12:04:19 2006
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
Enter user-name: / as sysdba
 
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
 
SQL> alter database datafile '/data2/oracle/oradata/MOSS/users01.dbf' online;
 
Database altered.
 
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 9 needs media recovery
ORA-01110: data file 9: '/data2/oracle/oradata/MOSS/users01.dbf'
 
 
SQL> recover database;
Media recovery complete.
SQL> alter database open;
 
Database altered.
 
SQL>

ok！问题解决！呵呵