數(shù)據(jù)庫啟動的時候報錯，請大家?guī)蛶兔Γ?/a>

chenfeng

SQL>; startup
ORACLE instance started.

Total System Global Area   56008688 bytes
Fixed Size                    69616 bytes
Variable Size              38989824 bytes
Database Buffers           16777216 bytes
Redo Buffers                 172032 bytes
Database mounted.
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: '/home/oracle/database/oradata/uw7ora8i/system01.dbf'


　我想可能是控制文件壞了，重新創(chuàng)建控制文件后，我做了以下操作：
SQL>; recover database using backup controlfile;
ORA-00279: change 6702369856281 generated at 05/28/2003 18:58:57 needed for
thread 1
ORA-00289: suggestion : /home/oracle/software/dbs/arch/1_27143.dbf
ORA-00280: change 6702369856281 for thread 1 is in sequence #27143


Specify log: {<RET>;=suggested | filename | AUTO | CANCEL}
/home/oracle/database/oradata/uw7ora8i/redo02.log


ORA-03113: end-of-file on communication channel

ORA-03114: not connected to ORACLE

請大家?guī)兔�看看是怎么回事？為什么恢復不了�?/td>

debuger

原帖由 "chenfeng" 發(fā)表：
SQL>; startup
ORACLE instance started.

Total System Global Area   56008688 bytes
Fixed Size                    69616 bytes
Variable Size              38989824 bytes
Database Buffers     

我想可能是控制文件壞了，重新創(chuàng)建控制文件后，我做了以下操作：



     ..........

   

是系統(tǒng)文件壞了