Archive log

[nalanda]

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

[Upeshp]

Just check the space in your archive log destination.

Make sure that it is not full.

[nalanda]

17 GB on the disk.

[Thomasps]

===

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

[gogo]

hey..
try stopping archiving n restarting it after changing there path ....make sure ur logfiles have not got corrupted...

[nalanda]

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

[sambavan]

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

[nalanda]

How do I check to make sure if the Disk is the problem in this situation.
Thanks.

[sreddy]

You have to use diskchk(NT) like utility. Contact your server admin to use some tool to check the disk condition.

[yls177]

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