Errors in file /u01/app/oracle/admin/ORCL/bdump/orcl_arc1_7586.trc:
ORA-00313: open failed for members of log group 4 of thread 1.
I encountered this error when group 4 was current and i just added a log member in this group.
After that I make too many log switch with
alter database switch logfile;
and not got any errors.
due to frequent log switches I got "Thread 1 cannot allocate new log, sequence 161
Private strand flush not complete"
This issue is infact not a bug and is expected behavior.
This is the same as "Checkpoint not completed" this is due to that all the redo entries from buffers have not been just written to redo files.
Strand is the new technology in 10g that deals with redo latches. this machnism allows multiple redo buffer latches to be written in redo, same parallel redo writing in 9i.
ref.Doc ID: Note:372557.1
A good discussion .....
http://www.lazydba.com/oracle/0__26265.html
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment