Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1061360
  • 博文数量: 239
  • 博客积分: 10
  • 博客等级: 民兵
  • 技术积分: 3618
  • 用 户 组: 普通用户
  • 注册时间: 2012-11-12 13:17
文章分类

全部博文(239)

文章存档

2021年(1)

2016年(1)

2015年(30)

2014年(91)

2013年(116)

分类: LINUX

2014-06-15 22:41:56

启动Oracle报错:
[oracle@oracle11g ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.3.0 Production on Sun Jun 15 22:13:54 2014
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size    2228784 bytes
Variable Size 1140854224 bytes
Database Buffers  452984832 bytes
Redo Buffers    7344128 bytes
Database mounted.
ORA-10873: file 4 needs to be either taken out of backup mode or media
recovered
ORA-01110: data file 4: '/u01/oracle/oradata/orcl/users01.dbf'

SQL> select status from v$instance;
STATUS
------------
MOUNTED

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-10873: file 4 needs to be either taken out of backup mode or media
recovered
ORA-01110: data file 4: '/u01/oracle/oradata/orcl/users01.dbf'

SQL> alter database end backup;
Database altered.

SQL> alter database open;
Database altered.
SQL> select status from v$instance;
STATUS
------------
OPEN
阅读(1520) | 评论(0) | 转发(0) |
0

上一篇:unod表空间

下一篇:windows 7 正确禁用 IPv6

给主人留下些什么吧!~~