RE: ORA-00345: redo log write error block
- From: "Peter McLarty" <p.mclarty@xxxxxxxxxx>
- To: <brianglock@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 12 Sep 2007 08:28:44 +1000
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@xxxxxxxxx]
Sent: Wednesday, 12 September 2007 06:56 AM
To: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
