求助：ORA-01033: ORACLE initialization or shutdown in progress

[welcomei]

前些天，oracle报错了，然后我重启了下linux~~，然后，就出现问题了~~

oracle@localhost oracle]$ sqlplus "/ as sysdba"

SQL*Plus: Release 8.1.7.0.0 - Production on ÐÇÆÚËÄ 12ÔÂ 6 14:15:27 2007

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production

SQL> connect
Enter user-name: sxyd
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress


Warning: You are no longer connected to ORACLE.


我进行了如下操作：


[oracle@localhost oracle]$ sqlplus "/ as sysdba"

SQL*Plus: Release 8.1.7.0.0 - Production on ÐÇÆÚËÄ 12ÔÂ 6 14:22:08 2007

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production

SQL> shutdown
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 1625862304 bytes
Fixed Size 73888 bytes
Variable Size 642670592 bytes
Database Buffers 983040000 bytes
Redo Buffers 77824 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


SQL> alter database open RESETLOGS;
alter database open RESETLOGS
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u01/oracle/oradata/ora8i/system01.dbf'


SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL> recover database using backup controlfile;
ORA-00279: change 103493658 generated at 11/16/2007 02:30:24 needed for thread
1
ORA-00289: suggestion : /u01/oracle/product/8.1.7/dbs/arch1_1179302.dbf
ORA-00280: change 103493658 for thread 1 is in sequence #1179302


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'/u01/oracle/product/8.1.7/dbs/arch1_1179302.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3



怎么办？

[welcomei]

继续上面：

SQL> alter database open ;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


SQL> alter database open RESETLOGS;
alter database open RESETLOGS
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/oracle/oradata/ora8i/system01.dbf'

[welcomei]

怎么没人回复啊~~~

[guan0616]

try：
shutdown immediate;
startup mount;
recover database until cancel;
alter database open RESETLOGS;

[chun290]

我的数据也出现同样的问题。不知道楼主的问题是怎么解决的/

[_liangzi_]

oracle数据库没启动完，多等一会儿。

[hailang_maxu]

重建控制文件

数据文件和日至文件不一致

[knowledge_Is_Life]

好像没那么简单,呵呵.

[wwj_ws]

应该是 系统 表空间 的 数据文件 损坏吧
使用 恢复数据文件的命令 试试吧