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

Thread: deleted datafile. How do I recover?

  1. #1
    Join Date
    Jun 2001
    Location
    florida
    Posts
    12

    Unhappy

    Please help!

    I have deleted a physical datafile space on Unix box before dropping the tablespace in Oracle. After the fact, when I try to drop Oracle tablespace the Instance crashed. I started the instance in mount mode, try to alter the tablespace offline Oracle tell me db is not open. I then tried to alter db open, I receive error 01157 cannot identify/lock datafile and ora 01110 datafile /oracle/----/----/ datafile"name".
    How do I recover Oracle without having to do a backup of the datafile? This datafile has no useful purpose.
    Is their a way to recover form this?
    THanks
    Dev

  2. #2
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    did you try either of the following at the mount stage --

    alter database datafile 3 offline;

    or

    alter database datafile 3 offline drop;

    you can use the datafile name also with the full path

    - Rajeev

    Rajeev Suri

  3. #3
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Wink maybe ...


    you need to take the datafile offline, not the tablespace.

    - mount the database

    - then issue:
    alter database datafile
    '/disk2/data/datafile_name.dbf' offline;

    try that.

    - Magnus

  4. #4
    Join Date
    Jun 2001
    Location
    florida
    Posts
    12
    Thank Rajeev
    When I tried datafile offline the following message occur>
    ORA-01145: offline immediate disallowed unless media recovery enabled. Any suggestion how to do this. I am reading up on this. I am a Newbie in Oracle and a have been in MSSQL.
    thanks
    dev

  5. #5
    Join Date
    Jun 2001
    Location
    florida
    Posts
    12
    Magnus. Thank you too! Please read my reply to Rajeev and see how you can assist.
    Dev

  6. #6
    Join Date
    Jun 2001
    Location
    florida
    Posts
    12

    Wink

    Thanks fells the off line drop methos work.
    cheers
    Dave

  7. #7
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Talking


    WHOO-HOOO!

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