ORA-03113: end-of-file on communication channel
729036Mar 21 2010 — edited Mar 21 2010hi experts
using oracle linux
database version 10.2.0.1 2 node rac
well was doing home scenario with missing archived logs and using allowresetlogs_corruption hidden parameter
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 9867098396261 generated at 03/21/2008 13:37:44 needed for
thread 1
ORA-00289: suggestion : /arcredo/XSCLFY/log1_648355446_2093.arc
ORA-00280: change 9867098396261 for thread 1 is in sequence #2093
Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: ‘/u100/oradata/XSCLFY/SYSTEM01_SCLFY.dbf’
ORA-01112: media recovery not started
SQL> alter database open resetlogs;
alter database open resetlogs
ERROR at line 1:
ORA-03113: end-of-file on communication channel
ALERT LOG ERROR IS
Errors in file /u01/app/oracle/admin/devdb/udump/devdb1_ora_24718.trc:
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: '+DG1/devdb/controlfile/current.260.683098967'
ORA-15078: ASM diskgroup was forcibly dismounted
Sun Mar 21 04:22:16 2010
Errors in file /u01/app/oracle/admin/devdb/udump/devdb1_ora_24718.trc:
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: '+DG1/devdb/controlfile/current.260.683098967'
ORA-15078: ASM diskgroup was forcibly dismounted
Sun Mar 21 04:22:16 2010
Master archival failure: 204
Sun Mar 21 04:22:18 2010
Errors in file /u01/app/oracle/admin/devdb/bdump/devdb1_rbal_24369.trc:
ORA-00204: error in reading (block , # blocks ) of control file
Sun Mar 21 04:22:25 2010
Instance terminated by LMON, pid = 24244
********************************************************************************************
ABOERTING THE INSTANCE AND RESTORING CONTROLFILE FROM AUTOBACK AND AGAIN MOUNTING THE ASM DISK GIVES ME THE SAME ERROR
CAN ANY BODY GIVE EXPERT COMMENTS
THANX