Re: Archiver error without archive log mode

I think that the messages in your alert log are perfectly normal,
information only, messages reported by Oracle for a database that
is not in archivelog mode.  They look just like all of ours where
we have some of the log_archive... parameters set, but the database
is not in archivelog mode.

On the other hand, our production database that *is* in archivelog
mode has the following messages in the alert log upon shutdown:

Fri Aug 22 20:47:35 2008
Shutting down archive processes
Archiving is disabled
Fri Aug 22 20:47:40 2008
ARCH shutting down
ARC1: Archival stopped
Fri Aug 22 20:47:45 2008
ARCH shutting down
ARC0: Archival stopped
Fri Aug 22 20:47:47 2008
Thread 1 closed at log sequence 47531
Successful close of redo thread 1
Fri Aug 22 20:47:49 2008
Completed: ALTER DATABASE CLOSE NORMAL

Note the 2 lines that start with ARC1: and ARC0:.

Upon startup, the following messages appear in the alert log
showing that the archive processes are really starting up:

ALTER DATABASE OPEN
Fri Aug 22 20:57:46 2008
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=2, OS id=1587971
ARC1 started with pid=35, OS id=1691287
Fri Aug 22 20:57:46 2008
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE

- Maureen

Martin Klier wrote:

But at each shutdown, this is in the log:

-------------
Sat Aug 23 12:26:39 2008
Completed: alter database dismount
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
-------------

And while starting up:
-------------
Sat Aug 23 12:26:58 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as
/opt/oracle/product/10gR2/db/dbs/arch
Autotune of undo retention is turned on.
...
-------------

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


Other related posts: