DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: error from archive log

  1. #1
    Join Date
    May 2002
    Posts
    12
    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

  2. #2
    Join Date
    Apr 2002
    Posts
    55
    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

  3. #3
    Join Date
    Nov 2000
    Posts
    224
    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.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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

  5. #5
    Join Date
    May 2002
    Posts
    12
    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

  6. #6
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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

  7. #7
    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

  8. #8
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    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
  •  


Click Here to Expand Forum to Full Width