error from archive log

Printable View

08-28-2002, 11:58 AM
cathy_ll

Hi guys,
I found the following error in the alert file, will this cause any problems for database? It did show regular archive log after those errors.

Sat Aug 24 18:39:44 2002
Current log# 1 seq# 5521 mem# 1: G:\DATABASES\ACDM\REDOLOGS\ACDM_LOG12.LOG
Sat Aug 24 18:39:44 2002
ARC1: Failed to archive log# 3 seq# 5519
ARC1: Beginning to archive log# 4 seq# 5520
Sat Aug 24 18:39:44 2002
Thread 1 advanced to log sequence 5522
Current log# 2 seq# 5522 mem# 0: H:\DATABASES\ACDM\REDOLOGS\ACDM_LOG21.LOG
Current log# 2 seq# 5522 mem# 1: G:\DATABASES\ACDM\REDOLOGS\ACDM_LOG22.LOG
Sat Aug 24 18:39:44 2002
ARC1: Completed archiving log# 4 seq# 5520
Sat Aug 24 18:39:44 2002
ARC2: Beginning to archive log# 3 seq# 5519
ARC2: Failed to archive log# 3 seq# 5519
ARC2: Beginning to archive log# 1 seq# 5521
Sat Aug 24 18:39:44 2002
ARC1: Beginning to archive log# 3 seq# 5519
ARC1: Failed to archive log# 3 seq# 5519
ARC1: Beginning to archive log# 1 seq# 5521
ARC1: Failed to archive log# 1 seq# 5521
Sat Aug 24 18:39:44 2002
ARC2: Completed archiving log# 1 seq# 5521
ARC2: Beginning to archive log# 3 seq# 5519
ARC2: Failed to archive log# 3 seq# 5519
Sat Aug 24 18:39:46 2002
ARC0: Completed archiving log# 3 seq# 5519
Sat Aug 24 18:39:49 2002
Thread 1 advanced to log sequence 5523
Current log# 3 seq# 5523 mem# 0: H:\DATABASES\ACDM\REDOLOGS\ACDM_LOG31.LOG
Sat Aug 24 18:39:49 2002
ARC1: Beginning to archive log# 2 seq# 5522
Sat Aug 24 18:39:49 2002
Current log# 3 seq# 5523 mem# 1: G:\DATABASES\ACDM\REDOLOGS\ACDM_LOG32.LOG
Thread 1 advanced to log sequence 5524
Current log# 4 seq# 5524 mem# 0: H:\DATABASES\ACDM\REDOLOGS\ACDM_LOG41.LOG
Current log# 4 seq# 5524 mem# 1: G:\DATABASES\ACDM\REDOLOGS\ACDM_LOG42.LOG
Sat Aug 24 18:39:50 2002
ARC1: Completed archiving log# 2 seq# 5522
Sat Aug 24 18:39:50 2002
ARC2: Beginning to archive log# 3 seq# 5523
Sat Aug 24 18:39:50 2002
Thread 1 advanced to log sequence 5525
Sat Aug 24 18:39:50 2002
ARC0: Beginning to archive log# 3 seq# 5523
Sat Aug 24 18:39:50 2002
Current log# 1 seq# 5525 mem# 0: H:\DATABASES\ACDM\REDOLOGS\ACDM_LOG11.LOG
Sat Aug 24 18:39:50 2002
ARC0: Failed to archive log# 3 seq# 5523

thanks,

cathy
08-28-2002, 12:40 PM
vendechukp

is this ur latest & last alert log errror message in that file

Check the space in the disk where archived log files are there.

Also query the V$log, V$logfile to see the status of the redolog files.
08-28-2002, 03:23 PM
Sharma

If everythinhg what vendechukp said is correct, check if the Directory has right permissions. Sometime (it has been seen on NT) Windows explorer changed the directory permission.
08-28-2002, 03:34 PM
marist89

Quote:

Originally posted by Sharma
If everythinhg what vendechukp said is correct, check if the Directory has right permissions. Sometime (it has been seen on NT) Windows explorer changed the directory permission.

I love unix!
08-28-2002, 11:21 PM
cathy_ll

I check the views, the redo logs looks fine. The wired thing is normally the database has lots of activity during the weekend, and about 8 archived log generated for Sunday, I query the v$archived_log, I only saw one archived log on Sunday. will this mean the database has slow performance during the day, and less transactions? will the error messge mean the archive process is behind of the log writer, so the resource wait on the log, it could cause slow database application? even though, it did catched up on Monday, I check the view and alert, it looks fine on Monday.

thanks,

cathy
08-29-2002, 02:20 AM
SANJAY_G

You have three archive background processes running. While one redo log is being archived by one process the other archive process also trying to archive it and resulting in error.

I think you can ignore this error.

Sanjay
08-29-2002, 06:32 AM
chao_ping

Quote:

Originally posted by SANJAY_G
You have three archive background processes running. While one redo log is being archived by one process the other archive process also trying to archive it and resulting in error.

I think you can ignore this error.

Sanjay

I agree with you.
As tom said, this is the normal behavior.Oracle does not know other process is archiving the redo, so multiple arch processes will try to archive the same one.
you can look at the alert file, all groups are finally successfully archived.
08-29-2002, 07:57 AM
Sameer

Quote:

Originally posted by SANJAY_G
You have three archive background processes running. While one redo log is being archived by one process the other archive process also trying to archive it and resulting in error.

I think you can ignore this error.

Sanjay

ARC2: Beginning to archive log# 1 seq# 5521
Sat Aug 24 18:39:44 2002
ARC1: Beginning to archive log# 3 seq# 5519
ARC1: Failed to archive log# 3 seq# 5519
ARC1: Beginning to archive log# 1 seq# 5521
ARC1: Failed to archive log# 1 seq# 5521
Sat Aug 24 18:39:44 2002
ARC2: Completed archiving log# 1 seq# 5521
ARC2: Beginning to archive log# 3 seq# 5519
ARC2: Failed to archive log# 3 seq# 5519
Sat Aug 24 18:39:46 2002

Just read the bold line...

Nothing to worry...

Sameer