DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, August 31, 2017

ORA-00350 & ORA-00312: ASM

Problem:- 

Get below error while when starting database.



SQL> startup
ORACLE instance started.

Total System Global Area 481259520 bytes
Fixed Size 1337352 bytes
Variable Size 381683704 bytes
Database Buffers 92274688 bytes
Redo Buffers 5963776 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 16265
Session ID: 20 Serial number: 3

Alert LOG:

ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: ‘+FRA/orcl/onlinelog/group_1.257.805381689’
ORA-17503: ksfdopn:2 Failed to open file +FRA/orcl/onlinelog/group_1.257.805381689
ORA-15012: ASM file ‘+FRA/orcl/onlinelog/group_1.257.805381689’ does not exist
ORA-00312: online log 1 thread 1: ‘+DATA/orcl/onlinelog/group_1.261.805381679’
ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/onlinelog/group_1.261.805381679
ORA-15012: ASM file ‘+DATA/orcl/onlinelog/group_1.261.805381679’ does not exist
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_16440.trc:
ORA-00313: open failed for members of log group 1 of thread
ORA-00312: online log 1 thread 1: ‘+DATA/orcl/onlinelog/group_1.261.805381679’
ORA-00312: online log 1 thread 1:+FRA/orcl/onlinelog/group_1.257.805381689’

USER (ospid: 16440): terminating the instance due to error 313


Solution:-

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 481259520 bytes
Fixed Size 1337352 bytes
Variable Size 381683704 bytes
Database Buffers 92274688 bytes
Redo Buffers 5963776 bytes

SQL> alter database mount;


Database altered.


SQL> l
1* select a.group#, a.sequence#, a.status, a.archived, b.member from v$log a, v$logfile b where a.group#=b.group#
SQL> /

GROUP# SEQUENCE# STATUS ARC MEMBER
———- ———- —————- — ————————————————–
3 0 UNUSED YES +DATA/orcl/onlinelog/group_3.263.805381707
3 0 UNUSED YES +FRA/orcl/onlinelog/group_3.259.805381713
2 0 UNUSED YES +DATA/orcl/onlinelog/group_2.262.805381695
2 0 UNUSED YES +FRA/orcl/onlinelog/group_2.258.805381703
1 1 CURRENT NO +DATA/orcl/onlinelog/group_1.261.805381679

1 1 CURRENT NO +FRA/orcl/onlinelog/group_1.257.805381689


Physically Verification:-

ASMCMD> cd ORCL/
lsASMCMD>
AUTOBACKUP/
BACKUPSET/
CONTROLFILE/
ONLINELOG/
ASMCMD> cd ONLINELOG/
ASMCMD> ls -ltr
WARNING:option ‘r’ is deprecated for ‘ls’
please use ‘reverse’

Type Redund Striped Time Sys Name
ONLINELOG UNPROT COARSE FEB 20 09:00:00 Y group_1.257.840013685
ONLINELOG UNPROT COARSE FEB 20 09:00:00 Y group_2.258.805381703
ONLINELOG UNPROT COARSE FEB 20 09:00:00 Y group_3.259.805381713
ASMCMD> pwd
+FRA/ORCL/ONLINELOG
ASMCMD> cd +DATA/ORCL/ONLINELOG
ASMCMD> ls -ltr
WARNING:option ‘r’ is deprecated for ‘ls’
please use ‘reverse’

Type Redund Striped Time Sys Name
ONLINELOG MIRROR COARSE FEB 20 09:00:00 Y group_1.261.840013679
ONLINELOG MIRROR COARSE FEB 20 09:00:00 Y group_2.262.805381695
ONLINELOG MIRROR COARSE FEB 20 09:00:00 Y group_3.263.805381707

Note:- +DATA/orcl/onlinelog/group_1.261.805381679 Log file is not available on physically. 

SQL> alter database clear unarchived logfile group 1;
SQL> alter database open;









No comments: