Results 1 to 3 of 3

Thread: Lost tablespace

  1. #1
    Join Date
    Jul 2003
    Near Paris France

    Red face Unanswered: Lost tablespace


    I have lost a TableSpace and I don't have a backup of this tablespace.
    So all data include in this tablespace are lost, it is ok.

    My current problem is that I can not open the database.
    I get these errors

    ORA-01122: database file 8 failed verification check
    ORA-01110: data file 8: '/bases/oracle/dmaeur1/data/d1/data_dmaeur1_eurmadm2_01.dbf'
    ORA-01251: Unknown File Header Version read for file number 8

    Is it possible to remove the tablespace from the controlfile before open the database?

  2. #2
    Join Date
    Mar 2002
    Reading, UK
    If I remember correctly mount the database, take the tablespace offline, do open database and then drop it.


  3. #3
    Join Date
    Apr 2003
    Minneapolis, MN
    hi AlenP,

    I guess You cannot take the tablespace offline because it requires all the datafiles belongs to it available and online. But in this case If you try to take the tablespace offline, it gives you an error. So You have to take the individual datafiles offline. then you can start the database. But it is possible only when your database is in ARCHIVELOG mode to recover the datafile.

    Hi pmscontact,

    In your case two options are available depends on the mode the database was operating.

    (1) If it was operating in ARCHIVELOG mode then you can still perform the complete recovery eventhough you do not have the backup of these tablespace If you have any complete backup (cold or hot) and you have all the archivelogs since that backup and till the time media failure happened, you can have complete recovery. elase perform incomplete recovery in which data loss is sure.

    (2) IF your database was operating in NOARCHIVELOG mode, then I am sorry but yoy lost yur data. You have only one options which is RESTORE your last most recent cold bakup. and if you do not have anycold backup even, then you lost your whole database.

    MS Computer Science
    OCP DBA 9i/8i

Posting Permissions

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