Re: Archiver error without archive log mode

From: Martin Klier <usn_at_usn-it.de>
Date: Tue, 26 Aug 2008 11:35:04 +0200
Message-ID: <48B3CE48.9030605@usn-it.de>


Hi Maureen,

thanks for your reply.

Maureen English schrieb:

> If there truly is an archive process running, on unix, you can do a
> ps and see processes named like ora_arc0_PROD running.
There has never been an ARC* process in the process list, since the DB crashed in the very beginning. I did not check the ps list before, since I've seen no reason for looking this one up explicitely. :)

> If there is no archiver running, these processes won't exist.
It doesn't.

> Regaring the messages when trying to do the log switch, we've had that
> problem in most of our databases when we either had too few log files
> or the log files were too small. We now have 5 log files (duplexed) and
> keep them at least 50M for an active database. We've been able to get
> by with 15M log files for small, not so active, databases, but then for
> our production database they are 150M.
Yes, I've got this hint before, and checked this already. My redo logs are 200MB in size per member, and the system has 19 of them. I times the message in question appears, there are often 10 log groups in state INACTIVE. Regards and thank you so far!
Martin

-- 
Usn's IT Blog for Linux, Oracle, Asterisk
http://www.usn-it.de

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 26 2008 - 04:35:04 CDT

Original text of this message