Home » RDBMS Server » Performance Tuning » Interpretation of Alert Log Errors
Interpretation of Alert Log Errors [message #275026] Thu, 18 October 2007 02:31 Go to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Hi Experts,

I got these errors from quering my alert log,

-- select * from alert_log where log_line like '%ORA-%';

Can someone please interpret it in a clearer way for me.

ORA-00313: open failed for members of log group 1 of thread 1
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00313: open failed for members of log group 3 of thread 1

Actually, I have 3 multiplex redologs with 3 members in each group.
Does this mean that all my logfile are corrupted or the members in
group 1 only.

Regards and thanks,

Cherish
Re: Interpretation of Alert Log Errors [message #275035 is a reply to message #275026] Thu, 18 October 2007 02:37 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
ORA-00313

ORA-00313: open failed for members of log group string of thread string
Cause: The online log cannot be opened. May not be able to find file.
Action: See accompanying errors and make log available.

Previous Topic: EXPLAIN PLAN CHANGE
Next Topic: Processes and Sessions
Goto Forum:
  


Current Time: Tue Dec 06 06:25:31 CST 2016

Total time taken to generate the page: 0.14263 seconds