Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2004
    Posts
    2

    Unanswered: 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 ID6.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.

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    A. Kill ArcServe process ... Oracle doesn't want to play nice when others want to lock his files ... as you can see. Your redo logs may be in a "stale" status which means a member of the group is incomplete with the "redo" it contains.

    Start the database ... and manually do log switches until you go thru the log is question. You may get lucky and that will do it ... If the log file is corrupted, Oracle will crash when you do a switch to the "bad" logfile.
    If this happens, you can start database, find the log in use.
    drop the log group and rebuild them ...

    EX:

    SQL> select group#,members, status from v$log;

    GROUP# MEMBERS STATUS
    ---------- ---------- ----------------
    1 1 CURRENT
    2 1 INACTIVE
    3 1 INACTIVE

    SQL> select group#, status
    2 from v$logfile;

    GROUP# STATUS
    ---------- -------
    1
    2 STALE
    3 STALE

    it shows 2 stale groups... but when I

    SQL> alter system switch logfile;

    System altered.

    SQL> select group#, status
    2 from v$logfile;

    GROUP# STATUS
    ---------- -------
    1
    2
    3 STALE

    it show only one , when I further do

    SQL> select group#,members, status from v$log;

    GROUP# MEMBERS STATUS
    ---------- ---------- ----------------
    1 1 INACTIVE
    2 1 CURRENT
    3 1 INACTIVE

    SQL> alter system switch logfile;

    System altered.

    SQL> select group#, status
    2 from v$logfile;

    GROUP# STATUS
    ---------- -------
    1
    2
    3

    NOW NO STALE FILES

    SQL> select group#, status
    2 from v$logfile;

    GROUP# STATUS
    ---------- -------
    1
    2
    3

    HTH
    Gregg

  3. #3
    Join Date
    Nov 2004
    Posts
    2
    hi,
    thanks for the reply.
    Currently the temporary countermeasure that we take to solve this problem is by restarting the oracle db server when it automatically shut down as what i explained previously.

    Is there any permanent countemeasure for this problem.eg:can we avoid the arcserve from locking the oracle files ??.Pls help.thanks.

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Arcserve has an optional module to do a hot backup of an oracle database. It is not part of the standard backup software.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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