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
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
>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