for failure archived logs in alert log page
Hi aarif,
i had
question: 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.
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
(for n number of times i had copied just a few lines )
Reply 1 : 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.( we dont have space problem)
Reply 2:check if the Directory has right permissions. Sometime (it has been seen on NT) Windows explorer changed the directory permission( i think we dont have this problem)
Reply 3: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 this might be a problem)
Reply 4: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.
please refer to the cathy_ll question posted on 08-29-2002 07:57 AM by Sameer