Re: Archiver error without archive log mode
- From: Martin Klier <usn@xxxxxxxxx>
- To: Maureen English <sxmte@xxxxxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 26 Aug 2008 11:35:04 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
