-
Oracle Error in during Arcserve2000 backup process
Please refer to the coding error message attached:
Any quick action can be taken to solve this problem.For my understanding,oracle file is locked by the arcserve application during backup process and it cause the file corruption in oracle db and db shut down.
----error msg----
*** SESSION ID:(6.1) 2004-10-04 00:21:37.875
ORA-00345: redo log write error block 71 count 69
ORA-00312: online log 3 thread 1: 'D:\ORACLE\ORADATA\SSA\LOG_GROUP3_1.LOG'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 5) Access is denied.
ORA-00346: log member marked as STALE
ORA-00312: online log 3 thread 1: 'D:\ORACLE\ORADATA\SSA\LOG_GROUP3_1.LOG'
ORA-00345: redo log write error block 2057 count 1986
ORA-00312: online log 3 thread 1: 'D:\ORACLE\ORADATA\SSA\LOG_GROUP3_1.LOG'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 5) Access is denied.
ORA-00345: redo log write error block 2120 count 63
ORA-00312: online log 3 thread 1: 'D:\ORACLE\ORADATA\SSA\LOG_GROUP3_1.LOG'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 5) Access is denied.
ORA-00345: redo log write error block 3646 count 1526
ORA-00312: online log 3 thread 1: 'D:\ORACLE\ORADATA\SSA\LOG_GROUP3_1.LOG'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 5) Access is denied.
*** 2004-10-04 00:21:41.250
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [2745], [1], [], [], [], [], [], []
--------------------------------------
Pls help.Thanks in advance.
-
Re: Oracle Error in during Arcserve2000 backup process
Originally posted by sasi
Please refer to the coding error message attached:
Any quick action can be taken to solve this problem.For my understanding,oracle file is locked by the arcserve application during backup process and it cause the file corruption in oracle db and db shut down.
----error msg----
*** SESSION ID:(6.1) 2004-10-04 00:21:37.875
ORA-00345: redo log write error block 71 count 69
ORA-00312: online log 3 thread 1: 'D:\ORACLE\ORADATA\SSA\LOG_GROUP3_1.LOG'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 5) Access is denied.
ORA-00346: log member marked as STALE
ORA-00312: online log 3 thread 1: 'D:\ORACLE\ORADATA\SSA\LOG_GROUP3_1.LOG'
ORA-00345: redo log write error block 2057 count 1986
ORA-00312: online log 3 thread 1: 'D:\ORACLE\ORADATA\SSA\LOG_GROUP3_1.LOG'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 5) Access is denied.
ORA-00345: redo log write error block 2120 count 63
ORA-00312: online log 3 thread 1: 'D:\ORACLE\ORADATA\SSA\LOG_GROUP3_1.LOG'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 5) Access is denied.
ORA-00345: redo log write error block 3646 count 1526
ORA-00312: online log 3 thread 1: 'D:\ORACLE\ORADATA\SSA\LOG_GROUP3_1.LOG'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 5) Access is denied.
*** 2004-10-04 00:21:41.250
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [2745], [1], [], [], [], [], [], []
--------------------------------------
Pls help.Thanks in advance.
dude, do the math on this one
Backup software is locking files that Oracle needs...hmm...lemme think..... shut off the #$@&^%!!! backup job.
You likely need an Oracle agent to perform backups with this software else take your own backup, dump it to a folder and have the backup software backup that specific folder and not your precious open database files
Last edited by stmontgo; 10-20-2004 at 11:28 PM.
I'm stmontgo and I approve of this message
-
isn't it your REDO LOGS is in STALE status?
-
Originally posted by reydp
isn't it your REDO LOGS is in STALE status?
this is sort of a tinsy winsy problem we have here
OSD-04008: WriteFile() failure, unable to write to file
I'm stmontgo and I approve of this message
-
I thought there was no active redo logs that is available for the LGWR to get its job done, and that it needs to force a log switch to force the INACTIVE/STALE redo logs to become active. Isn't it the case here?
-
Originally posted by reydp
I thought there was no active redo logs that is available for the LGWR to get its job done, and that it needs to force a log switch to force the INACTIVE/STALE redo logs to become active. Isn't it the case here?
NO - The backup software whacked the database , pure and simple
I'm stmontgo and I approve of this message
-
To initial poster -
You shouldn't be backing up online redo logs during a hot backup in the first place. So address that.
-
Its hardly a 'hot backup' though, is it?
Its just the backup software locking onto a 'file' that Oracle is trying to use at the same time. It could be anything as far as the software is concerned: an oracle datafile, a control file, a redo logfile, a text files ...
if the backup software has an Oracle Agent, I presume it places each tablespace in B/Up mode. Is it also clever enough to not backup the on-line redo? Or does it have to be configured to backup only certain files (datafiles) and ignore the on-line redo?
Anyway - you could still back them up - just don't use them as part of your recovery ... no?
-
Originally posted by JMac
Its hardly a 'hot backup' though, is it?
Its just the backup software locking onto a 'file' that Oracle is trying to use at the same time. It could be anything as far as the software is concerned: an oracle datafile, a control file, a redo logfile, a text files ...
if the backup software has an Oracle Agent, I presume it places each tablespace in B/Up mode. Is it also clever enough to not backup the on-line redo? Or does it have to be configured to backup only certain files (datafiles) and ignore the on-line redo?
Anyway - you could still back them up - just don't use them as part of your recovery ... no?
It just so happens the redo log is mentioned here but I believe that to be a moot point, thet same behavior could easily be observed for locking the system df, undo df etc or the control file. Point being, he needs the Oracle agent.
I'm stmontgo and I approve of this message
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|