auto shutdown of archiver on startup

From: EdStevens <quetico_man_at_yahoo.com>
Date: 9 Feb 2007 12:57:07 -0800
Message-ID: <1171054627.106217.161370@s48g2000cws.googlegroups.com>

Platform : Oracle 10.2.0 on HP-UX

Just created a new, very vanilla database with scripts genned out of dbca (custom database). Maybe this was happening on previous databases and I just never noticed, but I see that several seconds after the database opens, we see this in the alert log:

Fri Feb 9 12:02:31 2007
Completed: ALTER DATABASE OPEN
Fri Feb 9 12:02:32 2007
db_recovery_file_dest_size of 16384 MB .... <snip> Fri Feb 9 12:03:29 2007
Shutting down archive processes
Fri Feb 9 12:03:34 2007
ARCH shutting down
ARC2: Archival stopped

Nothing else appeared amiss, so I monitored the processes during a startup sequence:

stevense> ps -ef|grep ora _arc|grep -v grep

  oracle 24278     1  0 12:23:55 ?         0:00 ora_arc1_<sid>
  oracle 24276     1  0 12:23:55 ?         0:00 ora_arc0_<sid>
  oracle 24280     1  0 12:23:55 ?         0:00 ora_arc2_<sid>

stevense> ps -ef|grep ora _arc|grep -v grep <snip several reps of same, then>
stevense> ps -ef|grep ora _arc|grep -v grep stevense>

  oracle 24278     1  0 12:23:55 ?         0:00 ora_arc1_<sid>
  oracle 24276     1  0 12:23:55 ?         0:00 ora_arc0_<sid>

stevense> exit

So, it looks like three archivers are getting started at db startup, then one is almost immediatey shut down at the end of the startup cycle. I have log_archive_max_processes=2. I know that "LGWR process starts a new ARCn process whenever the current number of ARCn processes is insufficient to handle the workload." But I haven't seen definitive docs to say it will also decrease the number of ARCn processes when workload lightens, and I am somewhat surprised that there would be need to be doing this dynamic re-allocation right at startup. Received on Fri Feb 09 2007 - 14:57:07 CST