Error when trying to drop an undo datafile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Error when trying to drop an undo datafile

  1. #1
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257

    Error when trying to drop an undo datafile

    DBAs,

    The environment is 10.2.0.3 RAC.
    When I added an undo datafile to the undo tablspace for one instance in a RAC environment.
    Due to the mistype of the datafile name, I wanted to drop the datafile.

    I used:

    alter database datafile '/CODSP/vol6/und/undotbs6_06.dbf' offline for drop;

    The undo file is offline. The command was run without error.

    Then I used trying to drop the datafile--
    alter tablespace undotbs2 drop datafile '/CODSP/vol6/und/undotbs6_06.dbf';

    I got the error:
    ORA-03264: cannot drop offline datafile of locally managed tablespace

    So I wanted to put that datafile online:

    The Oracle error says the file needs media recovery.

    Currently, the status of this file is recover.

    So, at this stage, what should I do?

    Thanks,

    Lily

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    recover the file

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