数据库无法Open了 .... 高手HELP !
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.
页:
[1]