我在启动数据库的时候报如下的错误,不知道怎么处理,请各位大虾出招,谢谢!!SQL> startup;
ORACLE instance started.Total System Global Area 110576688 bytes
Fixed Size 726064 bytes
Variable Size 92274688 bytes
Database Buffers 16777216 bytes
Redo Buffers 798720 bytes
Database mounted.
ORA-01113: file 21 needs media recovery
ORA-01110: data file 21: '/home/oracle9i/product/9.2.0.2/dbs/RMS_TBS_0205.dbf'
ORACLE instance started.Total System Global Area 110576688 bytes
Fixed Size 726064 bytes
Variable Size 92274688 bytes
Database Buffers 16777216 bytes
Redo Buffers 798720 bytes
Database mounted.
ORA-01113: file 21 needs media recovery
ORA-01110: data file 21: '/home/oracle9i/product/9.2.0.2/dbs/RMS_TBS_0205.dbf'
解决方案 »
- 如何把excel中的数据导入到oracle数据库中
- Proc中打开游标:ORA-01722
- oracle中创建表时用 organization index怎么使用?到底是什么意思?
- 一个关于执行效率的问题
- 急!!在一个机房内,有人将我共享文件夹内的内容全部删除了,如何把他揪出来?正义的人们帮帮我。。。。。
- 高手GG这边看过来:c#.net可以调用oracle里面创建的包吗?
- select * from table_1 A,table_2 B where A.col_a=b.col_a(+)?
- 散分!!!向四位版主学习!
- CHAR和NCHAR字符类型之间的区别?
- 求一个oracle 9i 64 linux 安装包
- 自动关于自动ROLLBACK和COMMIT的问题!
- 如何查询最近时间的一条记录
如果不是
recover database就可以了先查查,自己试下,不成功大家再一起看看
系统提示启动时,需要的文件找不到
你知道这个数据文件里面有什么数据或什么表吗?
如果是不重要的,可以把这个文件设置为离线,然后用备份文件恢复回来ALTER TABLESPACE game OFFLINE;
如果是意外删除了数据文件,则必须带有RECOVER选项
ALTER TABLESPACE game OFFLINE FOR RECOVER;有关表空间的操作,请参考:
http://blog.csdn.net/hdhai9451/archive/2009/02/07/3867196.aspx
今天在检查接口机的时候,发现速度奇慢,于是,就差了一下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!问题解决!呵呵
1、新建表空间TB,对应数据文件TB1.ora
2、将TB离线(offline)
3、新建数据文件TB2.ora(大小与TB1.ora不同)
4、将TB的TB1.ora改名为TB2.ora
5、将TB上线(online)
结果出现了ORA-01113、ORA-01110问题。解决1:(尝试了,但没成功)
startup mount;
alter database datafile filename offline drop;
alter database open;解决2:(成功恢复)
startup mount;
recover datafile filename;
alter database open;
RMS_TBS_0205.dbf给干掉了,即 rm -f RMS_TBS_0205.dbf然后关了数据库,重启就打不开了
进入startup mount后,把找不到的文件离线ALTER TABLESPACE 表空间名 OFFLINE,
再创建一个新的文件补回来
http://hi.baidu.com/jdsnhan/blog/item/69c8cab15968d051092302fc.html
1. alter database create datafile '/home/oracle9i/product/9.2.0.2/dbs/RMS_TBS_0205.dbf';
2. set autorecovery on;
3. recover datafile '/home/oracle9i/product/9.2.0.2/dbs/RMS_TBS_0205.dbf';
4. alter database datafile '/home/oracle9i/product/9.2.0.2/dbs/RMS_TBS_0205.dbf' online;
5. alter database open;