Re: Archive Log errors

It has turned out to be a full file system - but I didn't expect the 'no such file or directory' message
rather - 'no space left on device'

Alex

Jerry Gitomer wrote in message <7nn253$t7l$1_at_autumn.news.rcn.net>...
>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 - 09:21:26 CDT