Deleted datafile by mistake
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Deleted datafile by mistake

  1. #1
    Join Date
    Feb 2002
    Posts
    23
    Hi All,


    I had some unwanted tablespaces . I dropped all of them except one. I deleted all the datafiles aasociated with these tablespaces including the datafile of the tablespace which I forgot to drop;

    I did'nt notice this , but when I restarted the database , it gives the error
    ORA-01110: data file 24: '/oradata/oradata/MAPS/MAP_RBS_GEN_DF01.DBF'
    ORA-01115: IO error reading block from file 24 (block # 1)
    ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file

    I tried through server manager but , not able to make the tablespace offline without opening the database.


    Can anybody suggest me which way can I open the database.

    Thanks in Advance.

    Louis.






  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    In this case try to drop datafile from database:
    ALTER DATABASE DATAFILE '/oradata/oradata/MAPS/MAP_RBS_GEN_DF01.DBF' OFFLINE DROP;

    After that try to open database,
    alter tablespace offline immediate;
    drop tablespace 'ts';
    Best wishes!
    Dmitri

  3. #3
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    In which mode r u running ur database.If its in noarchive log mode,use alter database datafile 'filename' offline drop;
    else if ur database is running in archive log mode.
    start ur database in mount phase, take the datafile offline.And then take the tablespace offline and then drop it.
    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