ora-01113解决办法

ghan

今天在检查接口机的时候，发现速度奇慢，于是，就差了一下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！问题解决！呵呵