archiving and writeFile() failure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: archiving and writeFile() failure

  1. #1
    Join Date
    Jan 2001
    Posts
    1
    Hi,

    We have oracle8i with archivelog on , the instance hang down
    while it was archiving

    KFC : Write / open error block=0x1b4c3 online= 1
    file=7 snmpk
    error=27072 txt: 'OSD-04008: writeFile() failure, unable to write to file
    o/s-error: (os 333) the process cannot access the file because another process has loced a portion of the file because another process has locked a portion of the file.

    autamatic datafile offline due to write error on file7.

    i increase the size of the file by adding a new data file but it won't help the still coming back after we shutdown the instant and restart it after a while.

    help us .. thank you


    thanks for the reply i already shutdown the database and alter the tablespace and the database is running.

    who the DBVERIFY will help me if i find which block is corrupted ..

    [Edited by maha on 01-23-2001 at 07:15 AM]

  2. #2
    Join Date
    Sep 2000
    Location
    Calcutta / Ahmedabad, India
    Posts
    137
    shutdown the database....and startup in mount stage. since you say that the datafile is already offline......offline that particular tablespace and open the database. from the mount stage try to recover the tablespace , once that is done open the database with resetlog option.


    once everything is running fine do not forget to run the DBVERIFY utility to check the datafiles for block corruption.

    Suvashish

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