ORA-00283 & ORA-01610 的處理方法

 

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: '/u02/sheng/SYSTEM01.DBF'

SQL> recover datafile 1;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

解決方式是control file全部損壞的處理方法：
vi initesheng.ora
add _allow_resetlogs_corruption=true

create spfile from pfile

---------
startup mount;

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

Errors in file /u01/pp/oracle/admin/sheng/udump/sheng_ora_5800.trc:
ORA-00600: internal error code, arguments: [2662], [0], [4982397], [0], [4982439], [4194313], [], []
Thu Dec 15 09:35:46 2011

----------