Archive log
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Archive log

  1. #1
    Join Date
    Oct 2000
    Posts
    25
    Can someone Please explain why Have the database experienced this problem and what do I do if this problem reoccurs.
    Win 2000 and Oracle 8i.
    Sat May 05 21:00:37 2001
    ARC0: I/O error 19502 archiving log 5 to 'D:\ORACLE\ORADATA\FIMS\ARCHIVE\FIMST001S00372.ARC'
    ARC0: Archiving not possible: error count exceeded
    ARC0: Failed to archive log# 5 seq# 372
    ARCH: Archival stopped, error occurred. Will continue retrying
    ARCH:
    ORA-16038: log 5 sequence# 372 cannot be archived
    ORA-19502: write error on file "", blockno (blocksize=)
    ORA-00312: online log 5 thread 1: 'D:\ORACLE\ORADATA\FIMS\LOG05.LOG'
    ORA-00312: online log 5 thread 1: 'D:\ORACLE\ORADATA\FIMS\REDO55.LOG'
    Sat May 05 22:02:32 2001
    Thread 1 advanced to log sequence 374
    Current log# 3 seq# 374 mem# 0: D:\ORACLE\ORADATA\FIMS\REDO03.LOG
    Current log# 3 seq# 374 mem# 1: D:\ORACLE\ORADATA\FIMS\REDO33.LOG
    Sat May 05 22:02:32 2001
    ARC0: Beginning to archive log# 5 seq# 372
    ARC0: Archiving not possible: No primary destinations
    ARC0: Failed to archive log# 5 seq# 372
    ARCH: Archival stopped, error occurred. Will continue retrying
    ARCH:
    ORA-16014: log 5 sequence# 372 not archived, no available destinations
    ORA-00312: online log 5 thread 1: 'D:\ORACLE\ORADATA\FIMS\LOG05.ORA'
    ORA-00312: online log 5 thread 1: 'D:\ORACLE\ORADATA\FIMS\REDO55.LOG'

    The destination is not changed. So why did this happen???
    Please advice ...........
    Thanks

  2. #2
    Join Date
    Mar 2001
    Posts
    131
    Just check the space in your archive log destination.

    Make sure that it is not full.


  3. #3
    Join Date
    Oct 2000
    Posts
    25
    17 GB on the disk.

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    ===

    [Edited by Thomasps on 05-09-2001 at 07:38 AM]

  5. #5
    Join Date
    May 2001
    Posts
    10
    hey..
    try stopping archiving n restarting it after changing there path ....make sure ur logfiles have not got corrupted...

  6. #6
    Join Date
    Oct 2000
    Posts
    25

    Any ideas???

    ORA-19502: write error on file "", blockno (blocksize=)

    Can someone Please explain what this means and why did this happen.
    Is it the blocks on archive file or the operating system file???

    How do I solve this problem rather than changing the destination after the error occurs or restarting the server (as we did).

    Please advice.........

    Thanks

  7. #7
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925

    Re: Any ideas???

    Originally posted by nalanda
    ORA-19502: write error on file "", blockno (blocksize=)


    19502, 00000, "write error on file \"%s\", blockno %s (blocksize=%s)"
    // *Cause: write error on output file
    // *Action: check the file


    Check to make sure that your disk is not at problem. And I'm curious to know, have to fixed the problem by bouncing the server?


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  8. #8
    Join Date
    Oct 2000
    Posts
    25
    How do I check to make sure if the Disk is the problem in this situation.
    Thanks.

  9. #9
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    You have to use diskchk(NT) like utility. Contact your server admin to use some tool to check the disk condition.
    Reddy,Sam

  10. #10
    Join Date
    Oct 2002
    Posts
    391
    Originally posted by sreddy
    You have to use diskchk(NT) like utility. Contact your server admin to use some tool to check the disk condition.
    how about if it is unix? errpt, dmesg did not show anything

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