Sunday, 12 April 2015

How to overcome error ORA-03113: end-of-file on communication channel during STARTUP



Hello,
This is my firs post .
This post is dedicated to my Anjeet sir. Without help of Anjeet sir I was unable to solve this problem.
First of all I want to say in which senario this error is raised.
Scenario
When I removed control file from default location and create  control file using control file trace command
>alter database backup controlfile to trace as '/home/oracle/contl.sql';

I copy all command in Sql * plus command prompt and create again control file
 When I run Startup  then above error  raised.
The status of trace alert_orcl.log file status is:

Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_lgwr_7154.trc:
ORA-00313: open failed for members of log group 2 of thread 1
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_lgwr_7154.trc:
ORA-00313: open failed for members of log group 2 of thread 1
Mon Apr 13 09:39:24 2015
ARC1 started with pid=21, OS id=7203 
Mon Apr 13 09:39:24 2015
ARC2 started with pid=22, OS id=7209 
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_7199.trc:
ORA-00313: open failed for members of log group 1 of thread 
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/orcl/redo02.log'
ORA-00312: online log 2 thread 1: '/home/oracle/disk02/redo05.log'

USER (ospid: 7199): terminating the instance due to error 313
Solution
>startup mount;
>recover database untill cancel;
>alter database open resetlogs;




No comments:

Post a Comment