Re: Archive Log errors

A copy of this message has been e-mailed to Alex Hudghton at <7nmi0s$duo$1_at_taliesin.netcom.net.uk>...

For what it's worth ...

262$ oerr ora 00255
00255, 00000, "error archiving log %s of thread %s, sequence # %s"
// *Cause: An error occurred during archival. // *Action: Check the error stack for more detailed information. If it is not
// possible to archive the log because the online log is corrupted,
// then the log can be cleared using the UNARCHIVED option. This will
// make any existing backups useless for recovery to any time after
// the log was created, but will allow the database to generate redo.

First, see if you have any free space on the file system you are archiving to. If that is not the problem you may have some hardware problems since you are getting OS write errors.

regards
Jerry Gitomer

Alex Hudghton wrote in message
<7nmi0s$duo$1_at_taliesin.netcom.net.uk>...
>The following is from the alert log:
>
>Tue Jul 27 15:56:44 1999
>ORA-00255: error archiving log 1 of thread 1, sequence # 1736
>ORA-00312: online log 1 thread 1:
>'/u1/oravl03/ORACLE/EXUS1/log/logEXUS1_A1.dbf'
>ORA-00312: online log 1 thread 1:
>'/u1/oravl80/ORACLE/EXUS1/log/logEXUS1_A2.dbf'
>ORA-00334: archived log:

'/u1/oravl81/ORACLE/EXUS1/arc/archEXUS1_1736.dbf'
>ORA-19502: write error on file
>"/u1/oravl81/ORACLE/EXUS1/arc/archEXUS1_1736.dbf", blockno 15297
>(blocksize=1024)
>ORA-27072: skgfdisp: I/O error
>HP-UX Error: 2: No such file or directory
>Additional information: 15297
>ORA-00272: error writing archive log
>/u1/oravl81/ORACLE/EXUS1/arc/archEXUS1_1736.dbf
>ORA-19502: write error on file
>"/u1/oravl81/ORACLE/EXUS1/arc/archEXUS1_1736.dbf", blockno 15297
>(blocksize=1024)
>ORA-27072: skgfdisp: I/O error
>HP-UX Error: 2: No such file or directory
>Additional information: 15297
>
>
>The log files do exist.
>Oracle is 8.0.5.1
>OS is HPUX 10.20
>
>Any clues why this is happening ??
>
>Alex
>
>
>
Received on Wed Jul 28 1999 - 08:56:47 CDT