-
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
DBA OCP 8i
-
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.
VenDe ChukPeen Zuri
Someone who quotes himself as a DBA and posts simple question in forums is a big idiot to me . I donot care what others think
-
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.
-
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!
Jeff Hunter
-
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
DBA OCP 8i
-
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
-
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.
www.cnoug.org
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|