RE: UNDO tablespace issue- the dropped datfaile still shows in v$recover_file

Prasad,  

But if you physically dropped the datafile, you cannot synch it. If you can (ie, if you have some space available), I would rather (temporarily) create another fresh NEWUNDO tbs, using other datafile(s); and afterwards do an "alter system set undo_tablespace=NEWUNDO ;" . After, check if any sessions are still using the old UNDO (transactions).

Once Oracle begins to use NEWUNDO, you could try to put OFFLINE the old UNDO and consider dropping it via "drop tablespace UNDO including contents and datafiles", and finally re-create the original UNDO again, and again run the "alter system set undo_tablespace=UNDO"  

Can someone please suggest how do I synch it .

thanks in advance
Prasad

--
http://www.freelists.org/webpage/oracle-l