Re: ORA-00345: redo log write error block

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 11 Sep 2007 15:16:57 -0700
Message-ID: <bf46380709111516m691506d9i98dc3029ede5be9a@mail.gmail.com>

On 9/11/07, Brian Lock <brianglock_at_gmail.com> wrote:
>
> This error occured on Windows Server 2003 while the weekly backup
> (Symantec) was running.
> Anyone have any ideas why this occurred and as possible work areound?
>
> Thanks
>
> Sat Sep 08 04:18:13 2007
> Errors in file c:\oraqa\admin\BLUESKY\bdump\bluesky_lgwr_2752.trc:
> ORA-00345: redo log write error block 2 count 276
> ORA-00312: online log 1 thread 1: 'K:\ORADATA\BLUESKY\REDO01.LOG'
> ORA-27072: skgfdisp: I/O error
> OSD-04008: WriteFile() failure, unable to write to file
> O/S-Error: (OS 5) Access is denied.
>

Well, the obvious things come to mind.

Does the user that is running the Oracle service have write permissions on the drive?

Does the drive work?

Can you create a file on that drive *as* the user that is running Oracle?

Are there IO errors in the Event Viewer?

Last but not least, if you cannot determine the problem, you should open an SR with Oracle Support ASAP. Not being able to write to redo is rather serious problem.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 11 2007 - 17:16:57 CDT