RE: Archiver error without archive log mode
- From: "William Wagman" <wjwagman@xxxxxxxxxxx>
- To: <usn@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 22 Aug 2008 11:23:53 -0700
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@xxxxxxxxxxx
(530) 754-6208
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Martin Klier
Sent: Thursday, August 21, 2008 9:29 AM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
