Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

729036Mar 21 2010 — edited Mar 21 2010
hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 18 2010
Added on Mar 21 2010
1 comment
2,015 views