RE: Archiver error without archive log mode

Greetings,

Is it possible log_archive_start is set to true? I believe that will start the archiver process even if the database is in noarchivelog mode.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Martin Klier Sent: Thursday, August 21, 2008 9:29 AM To: oracle-l_at_freelists.org
Subject: Archiver error without archive log mode

Dear list,

A question - maybe I am just silly, but I can't explain how that comes: One of my 10gR2 Databases is in NORACHIVELOG mode. (v$database log_mode is NOARCHIVELOG).

If I force a logswitch with "alter system switch logfile;" I'll get this alert log entry (without any ORA- error): Thread 1 cannot allocate new log, sequence <something>"

This alone would be quite "funny", but tonight there have been jobs refusing to start with "ORA-0257 archiver error. Connect internal only, until freed.”

Why is there an archiver process without archive log mode, and why is it blocking my transactions?

Something you should know: The ASM disk group used by the database is 95% full, but there have been no errors with extending tablespaces or something like that.

Any advice is greatly appreciated - thanks in advance! Martin Klier

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

--
http://www.freelists.org/webpage/oracle-l

��i��0���zX���+��n��{�+i�^ Received on Fri Aug 22 2008 - 13:23:53 CDT