免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1651 | 回复: 0

ora-01113解决办法 [复制链接]

论坛徽章:
0
发表于 2011-12-21 08:44 |显示全部楼层

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

您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP