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

Thread: Removing entry of a datafile from controlfile

  1. #1
    Join Date
    Aug 2002
    Posts
    3

    Question

    Hai everybody
    In my database,a datafile is corrupted.I have no
    backup for that,So i made offline drop that datafile.
    I added a new datafile to that tablespace now.When i create
    the tables in the tablespace an error comes 'file 6 cannot be read at this time' .That it is indicating the dropped datafile.How to remove the entry from the controlfile
    permanently.Not possible to shutdown the db and recreate the
    controlfile.
    Thanks in advance.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you cannot do that

    you have to drop entire tablespace

    you will lose data

    but that's only way

  3. #3
    IF database is in archivelog, and you have all the archivelog since the ddatafile is created, you can recover it.Though it seems hard to keep all the archivelog since the datafile creation.
    www.cnoug.org

  4. #4
    another solution to try to save as much data as possible:
    find out the segments that have extents in that datafile.
    export other tables that does not have extents in the datafile first.
    and then use rowid to extract records from the tables that have extents in the datafile.
    www.cnoug.org

  5. #5
    Join Date
    Aug 2002
    Posts
    10
    1 shutdown the datebase
    2 startup mount
    3 alter database datafile '/disk2/data/db2.dbf' offline
    4 alter database open

    Because you did have the backup of the datafile corrupted.I can not ensure you can recovery the data loss.

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by wengyan
    1 shutdown the datebase
    2 startup mount
    3 alter database datafile '/disk2/data/db2.dbf' offline
    4 alter database open

    Because you did have the backup of the datafile corrupted.I can not ensure you can recovery the data loss.
    you can do that if you are in archive log otherwise not

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