Why does Oracle start another arc process?

From: Vince Laurent <vlaurent_at_NOSPAM.networkusa.net>
Date: Fri, 28 Jun 2002 10:54:24 -0500
Message-ID: <8i1phu4m7uu52a7uoh7j5cvhjitvbps10c@4ax.com>

On one of our systems I see the following behavior:

(sapbpr):/oracle/BPR/saptrace/background:root# ps -ef | grep -v grep | grep ora_

  bpradm 18215     1  0  Jun 19  ?         0:42 ora_dbw0_BPR
  bpradm 18217     1  0  Jun 19  ?         1:27 ora_lgwr_BPR
  bpradm 18213     1  0  Jun 19  ?         0:15 ora_pmon_BPR
  bpradm 18225     1  0  Jun 19  ?         0:35 ora_arc0_BPR
  bpradm 18221     1  0  Jun 19  ?         0:04 ora_smon_BPR
  bpradm 18223     1  0  Jun 19  ?         0:00 ora_reco_BPR
  bpradm 18219     1  0  Jun 19  ?         0:47 ora_ckpt_BPR
  bpradm  4242     1  0 14:43:11 ?         0:01 ora_arc1_BPR

And from the alert log:

Completed checkpoint up to RBA [0xfa.2.10], SCN: 0x0000.0053776d Thu Jun 20 14:43:04 2002
Beginning log switch checkpoint up to RBA [0xfc.2.10], SCN: 0x0000.0053802b
Thread 1 advanced to log sequence 252
  Current log# 14 seq# 252 mem# 0: /oracle/BPR/origlogB/log_g14m1.dbf   Current log# 14 seq# 252 mem# 1: /oracle/BPR/mirrlogB/log_g14m2.dbf Thu Jun 20 14:43:11 2002

ARC0: Completed archiving log# 11 seq# 250
ARC0: STARTING ARCH PROCESSES
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Beginning to archive log# 12 seq# 251

ARC1 started with pid=34
ARC1: Archival started
Thu Jun 20 14:43:21 2002
ARC0: Completed archiving log# 12 seq# 251

So why does Oracle start a second archive process?

We are running Oracle 8.1.7.3 on HP-UX 11.x

Thanks! Received on Fri Jun 28 2002 - 10:54:24 CDT