Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-00345: redo log write error block

RE: ORA-00345: redo log write error block

From: Peter McLarty <p.mclarty_at_cqu.edu.au>
Date: Wed, 12 Sep 2007 08:28:44 +1000
Message-ID: <27AA2E9CA7A0C44283BC1E9B00086AA90802390E@UNIMAIL.staff.ad.cqu.edu.au>


Hi Brian  

I will hazard to guess your backup is trying to backup open database files with a file copy backup. If so, its a mostly a waste of time. Whilst in a desperate situation you can recover data from the database that you can reconstruct you would need to extract that data from the old database and reload it to a new database to remain supported. Oracle wont support a database running after such a recovery, only assist you through the recovery.
Make sure the oracle datafiles, controlfiles, and redo logs are excluded from virus scanning and file copy type backups unless you are doing a file copy of a shutdown database. In this case you were not.  

Cheers  

Peter


From: Brian Lock [mailto:brianglock_at_gmail.com] Sent: Wednesday, 12 September 2007 06:56 AM To: oracle-l_at_freelists.org
Subject: ORA-00345: redo log write error block

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.

Sat Sep 08 04:18:18 2007
Errors in file c:\oraqa\admin\BLUESKY\bdump\bluesky_lgwr_2752.trc:

ORA-00340: IO error processing online log 1 of thread 1
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.

LGWR: terminating instance due to error 340 Sat Sep 08 04:18:23 2007
Errors in file c:\oraqa\admin\BLUESKY\bdump\bluesky_pmon_2692.trc: ORA-00340: IO error processing online log of thread

Sat Sep 08 04:18:57 2007
Instance terminated by LGWR, pid = 2752
Mon Sep 10 07:55:45 2007

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 11 2007 - 17:28:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US