ORACLE数据库无法打开

ALLSTARS_ORACLE

环境：Redhat+oracle 11G R2
断电后,数据库启动不了。
在网上搜索后，知道可能是误删在线日志造成的。在/oradata/orcl/下发现没有redo01.log文件。
于是按照网上教程重建控制文件，重新启动数据库，出现如下错误：
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: '/oradata/orcl/system01.dbf'
请问各位应该如何解决啊？我是新手，数据库没有备份，里面的表结构和存储过程很重要....T-T



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

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: '/oradata/orcl/system01.dbf'
谢谢您了...



_allow_resetlogs_corruption=true
是这个吗？
db open 是alter database open吗？

加上参数后，这个是输出
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open



执行recover until cancel报如下错误应该怎么办？
SQL> recover until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


呃.....我又尝试着重建了一遍控制文件，结果现在出现新的问题了...重建后第一次alter database open resetlogs;会出现如下问题：
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [0], [91992354], [0],
[91992359], [12583056], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [2662], [0], [91992353], [0],
[91992359], [12583056], [], [], [], [], [], []
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [2662], [0], [91992351], [0],
[91992359], [12583056], [], [], [], [], [], []
Process ID: 7288
Session ID: 125 Serial number: 3
然后重新connect sys/Dreamtech508 as sysdba，startup mount再alter database open resetlogs;回报如下错误：
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
各位大侠救救我吧，里面的表和存储过程真的很重要...数据倒是可以无视...T-T



执行recover until cancel仍然会报如下错误：
SQL> recover until cancel;
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.


STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "ORCL" RESETLOGS ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
--  GROUP 1 '/oradata/orcl/redo01.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 2 '/oradata/orcl/redo02.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 3 '/oradata/orcl/redo03.log'  SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  '/oradata/orcl/system01.dbf',
  '/oradata/orcl/sysaux01.dbf',
  '/oradata/orcl/undotbs01.dbf',
  '/oradata/orcl/users01.dbf'
CHARACTER SET AL32UTF8


是这样？还是不行。。。。