archiving not possible: error count exceeded
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: archiving not possible: error count exceeded

  1. #1
    Join Date
    Dec 2000
    Posts
    41
    I found this message in my alert.log:

    ARC0: Beginning to archive log# 3 seq# 115
    ARC0: Error 19504 creating archivelog file 'D:\ORA8I\DATABASE\TERRI\LOGS\ARC00115.001'
    ARC0: Archiving not possible: error count exceeded

    I've checked for space, and that definitely is not the problem, can anyone explain what could be causing this error?

    Dawn

  2. #2
    Join Date
    Dec 1999
    Location
    Cincinnati, Ohio USA
    Posts
    99
    What are your log_archive_ parameters in your initSID.ora file?

    Also, Have you tried copying a file (outside of Oracle) to the log archive destination? Try copying an old archivelog to a new name to assure the same size file can be written to the disk.
    Doug

  3. #3
    Join Date
    Dec 2000
    Posts
    41
    Here are my init parameters:

    log_archive_start = true
    log_archive_dest = 'D:\ora8i\Database\terri\logs'
    log_archive_format: Arch-%t-%S.arc
    log_archive_duplex_dest = 'D:\Ora8i\Mirroredfiles'
    log_archive_min_succeed_dest = 2

    Also, I tried your suggestion - I was able to copy another file to the log archive destination with no trouble. Any other ideas?

    Dawn

  4. #4
    Join Date
    Dec 1999
    Location
    Cincinnati, Ohio USA
    Posts
    99
    Is there a arc???.trc file in your bdump directory, relating to this error?
    Doug

  5. #5
    Join Date
    Dec 1999
    Location
    Cincinnati, Ohio USA
    Posts
    99
    One quick thought is to get rid of the "-" in the format, try using an "_" underscore instead. Bounce the database to get the change to take effect.

    The reason is the warning message indicates

    'D:\ORA8I\DATABASE\TERRI\LOGS\ARC00115.001

    and your format
    says

    Arch-%t-%S.arc

    Which does not make since, since this format is not formating correctly. Note that it says ARC and not Arch, let alone, it is not using the dashes and where did the '.' come from after the 115. Something is not right with the format. Try simplifying the format to

    arch_%t_%s.arc


    Doug

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