Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> log archive question

log archive question

From: Glen A Stromquist <glen_stromquist_at_nospam.yahoo.com>
Date: Wed, 15 Jan 2003 17:50:50 GMT
Message-ID: <_bhV9.622$536.27097@news2.telusplanet.net>


I noticed the following in one of my alert.logs:

ARC0: Beginning to archive log# 7 seq# 10902 Tue Jan 14 20:04:15 2003
Thread 1 advanced to log sequence 10904
  Current log# 5 seq# 10904 mem# 0: D:\ORACLE\ORADATA\db\REDO05.ORA   Current log# 5 seq# 10904 mem# 1: C:\ORACLE\ORADATA\db\REDO05A.ORA Tue Jan 14 20:04:15 2003

ARC1: Beginning to archive log# 7 seq# 10902
ARC1: Failed to archive log# 7 seq# 10902
ARC1: Beginning to archive log# 8 seq# 10903
ARC1: Completed archiving log# 8 seq# 10903
ARC1: Beginning to archive log# 7 seq# 10902
ARC1: Failed to archive log# 7 seq# 10902
Tue Jan 14 20:04:15 2003
ARC0: Completed archiving log# 7 seq# 10902 Tue Jan 14 20:04:16 2003

From which I gather that the ARC0 process is stepping on the ARC1 process's toes. What I dont understand is why there are 2 arc processes running, nothing is specified in the init.ora file and I thought the default was 1 process, unless I'm mistaken.

I've enabled some tracing with alter system set log_archive_trace=127 and will see what that tells me (got this sugg. from someone elses thread back in aug)

Should I add a log_archive_max_processes param in the init.ora anyway, just so this doesnt happen again?

TIA Received on Wed Jan 15 2003 - 11:50:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US