Linux上ora01113一键解决,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！问题解决！呵呵