今天在检查接口机的时候，发现速度奇慢，于是，就差了一下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！问题解决！呵呵
| 欢迎光临 Chinaunix (http://bbs.chinaunix.net/) | Powered by Discuz! X3.2 |