Archive log

Printable View

05-09-2001, 04:05 AM
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
05-09-2001, 07:09 AM
Upeshp

Just check the space in your archive log destination.

Make sure that it is not full.
05-09-2001, 07:19 AM
nalanda

17 GB on the disk.
05-09-2001, 07:36 AM
Thomasps

===

[Edited by Thomasps on 05-09-2001 at 07:38 AM]
05-09-2001, 08:50 AM
gogo

hey..
try stopping archiving n restarting it after changing there path ....make sure ur logfiles have not got corrupted...
05-09-2001, 09:43 AM
nalanda

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
05-09-2001, 10:45 AM
sambavan

Re: Any ideas???

Quote:

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
05-09-2001, 11:51 AM
nalanda

How do I check to make sure if the Disk is the problem in this situation.
Thanks.
05-09-2001, 12:45 PM
sreddy

You have to use diskchk(NT) like utility. Contact your server admin to use some tool to check the disk condition.
09-17-2003, 10:22 PM
yls177

Quote:

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