Oracle Error in during Arcserve2000 backup process
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Oracle Error in during Arcserve2000 backup process

  1. #1
    Join Date
    Oct 2004
    Posts
    3

    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.
    Share on Google+

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187

    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
    Share on Google+

  3. #3
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    isn't it your REDO LOGS is in STALE status?
    Share on Google+

  4. #4
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    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
    Share on Google+

  5. #5
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    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?
    Share on Google+

  6. #6
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    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
    Share on Google+

  7. #7
    Join Date
    Oct 2002
    Posts
    807
    To initial poster -

    You shouldn't be backing up online redo logs during a hot backup in the first place. So address that.
    Share on Google+

  8. #8
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    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?
    Share on Google+

  9. #9
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    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
    Share on Google+

  10. #10
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I wonder if he might need the Oracle Agent??
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."
    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width