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