DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ora-01110

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    ora-01110

    ORA-01110: data file 128: 'H:\ORACLE\xxxx\SAPDATA1\TEMP_6\TEMP.DATA6'
    ORA-01115: IO error reading block from file 128 (block # 1)
    ORA-27072: skgfdisp: I/O error
    OSD-04006: ReadFile() failure, unable to read from file
    O/S-Error: (OS 33) The process cannot access the file because
    another process has locked a portion of the file.


    got this error once in a while. and its not always on temp, some other different tablespaces are involved as well. on oracle 8.0.6 and NT. when this happeend, the instace will shut down by itself and need to a do a recover on that daatfile to startup the db again.

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    It seems to me a disk/hardware problem, intermittantly the file is not available.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Oct 2002
    Posts
    391
    what happens is that originally, we had online backup scheduled everyday. and then this error occurs. apparently, we had file system backups scheduled recently. so what happened is that when file sysetm backup is running for a datafile, at the same time when a transaction needs that file, oracle senses that file is used by another program, make it offline and make it recover status.

    am i right to conclude this way?

  4. #4
    Join Date
    May 2001
    Posts
    736
    I think when ever your backup starts it taking the datafile offline.

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by yls177
    what happens is that originally, we had online backup scheduled everyday. and then this error occurs. apparently, we had file system backups scheduled recently. so what happened is that when file sysetm backup is running for a datafile, at the same time when a transaction needs that file, oracle senses that file is used by another program, make it offline and make it recover status.

    am i right to conclude this way?
    What type of backup are you running? RMAN Online backup or OS Online backup?
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  6. #6
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi,
    As the Database is running on windows,
    trying to take file system backup will error out if another process is currently accessing the files.This is not the case in UNIX.



    If doing in RMAN, i feel u will not get this error.

    regards
    anandkl
    anandkl

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