在线请问：ORA-01092错误，如何解决？

rainyday

这是oracle启动过程和报错信息：

      SQL>; shutdown abort
      ORACLE instance shut down.
      SQL>; startup mount
      ORACLE instance started.

      Total System Global Area 2098689168 bytes
      Fixed Size 738448 bytes
      Variable Size 620756992 bytes
      Database Buffers 1476395008 bytes
      Redo Buffers 798720 bytes
      Database mounted.
      SQL>; alter database datafile 25 offline drop;

      Database altered.

      SQL>; alter database open;
      alter database open
      *
      ERROR at line 1:
      ORA-01092: ORACLE instance terminated. Disconnection forced

sshd

check alert.log file to see why the instance gets shut down after mounted

cole

shutdown immediate
startup mount
alter database datafile 25 offline drop;
alter database open;
drop tablespace tablespace_name

rainyday

谢了！后来不知怎么弄的redo日志都有问题。
alter database clear unarchived logfile group n;
然后在init中加上了隐含参数
_allow_resetlogs_corruption=true
把数据库打开了