数据库无法Open了 .... 高手HELP !

ALLSTARS_ORACLE

SQL> alter database open noresetlogs;
alter database open noresetlogs
*
ERROR at line 1:
ORA-01588: must use RESETLOGS 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: '/opt/oracle/app/oracle/oradata/ifirst/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> select checkpoint_change# from v$database;

CHECKPOINT_CHANGE#
------------------
           3348551



刚开始是 ora-03113 end-of-file on communication channel 错误.  瞎折腾一会就成这样了.. 不才啊


SQL> select name,checkpoint_change# from v$datafile;

NAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE#
------------------
/opt/oracle/app/oracle/oradata/ifirst/system01.dbf
           3348551

/opt/oracle/app/oracle/oradata/ifirst/tools01.dbf
           3348551

/opt/oracle/app/oracle/oradata/ifirst/rbs01.dbf
           3348551


NAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE#
------------------
/opt/oracle/app/oracle/oradata/ifirst/temp01.dbf
           3348551

/opt/oracle/app/oracle/oradata/ifirst/users01.dbf
           3348551

/opt/oracle/app/oracle/oradata/ifirst/indx01.dbf
           3348551


NAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE#
------------------
/opt/oracle/app/oracle/oradata/ifirst/IFIRST.dbf
           3348551

/opt/oracle/app/oracle/oradata/ifirst/CINNER.dbf
           3348551

/opt/oracle/app/oracle/oradata/ifirst/IFIRST_TEMP.dbf
           3348551


NAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE#
------------------
/opt/oracle/app/oracle/oradata/ifirst/WELLKEY.dbf
           3348551

/opt/oracle/app/oracle/oradata/ifirst/IFIRSTYEJIN.dbf
           3348551

/opt/oracle/app/oracle/oradata/ifirst/IFIRSTYEJIN_TEMP.dbf
           3348551


NAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE#
------------------
/opt/oracle/app/oracle/oradata/ifirst/MEITOU.dbf
           3348551

/opt/oracle/app/oracle/oradata/ifirst/MEITOU_TEMP.dbf
           3348551


14 rows selected.


发现这里的兄弟很是热情啊... 在CSDN上发帖一天了都无人过问..


SQL> recovery database until cancel using backup controlfile;

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: '/opt/oracle/app/oracle/oradata/ifirst/system01.dbf'


就是打不开哦

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: '/opt/oracle/app/oracle/oradata/ifirst/system01.dbf'




SQL> select name,last_change# from v$datafile;

NAME
--------------------------------------------------------------------------------
LAST_CHANGE#
------------
/opt/oracle/app/oracle/oradata/ifirst/system01.dbf


/opt/oracle/app/oracle/oradata/ifirst/tools01.dbf


/opt/oracle/app/oracle/oradata/ifirst/rbs01.dbf



NAME
--------------------------------------------------------------------------------
LAST_CHANGE#
------------
/opt/oracle/app/oracle/oradata/ifirst/temp01.dbf


/opt/oracle/app/oracle/oradata/ifirst/users01.dbf


/opt/oracle/app/oracle/oradata/ifirst/indx01.dbf



NAME
--------------------------------------------------------------------------------
LAST_CHANGE#
------------
/opt/oracle/app/oracle/oradata/ifirst/IFIRST.dbf


/opt/oracle/app/oracle/oradata/ifirst/CINNER.dbf


/opt/oracle/app/oracle/oradata/ifirst/IFIRST_TEMP.dbf



NAME
--------------------------------------------------------------------------------
LAST_CHANGE#
------------
/opt/oracle/app/oracle/oradata/ifirst/WELLKEY.dbf


/opt/oracle/app/oracle/oradata/ifirst/IFIRSTYEJIN.dbf


/opt/oracle/app/oracle/oradata/ifirst/IFIRSTYEJIN_TEMP.dbf



NAME
--------------------------------------------------------------------------------
LAST_CHANGE#
------------
/opt/oracle/app/oracle/oradata/ifirst/MEITOU.dbf


/opt/oracle/app/oracle/oradata/ifirst/MEITOU_TEMP.dbf



14 rows selected.