do an alter database backup controlfile to trace and then rebuild the file..
You may want to perform a full exp before your have to stop the database in
order to rebuild the controlfile
dan

-----Original Message-----
From: Marcus Jones [mailto:[Email Address Removed] Wednesday, March 31, 2004 11:55 AM
To: LazyDBA.com Discussion
Subject: Lost Controlfile


Hello,

I'm on 9i and I lost my controlfile...i do not have a backup...What are the
steps to get it back...the database is still up...Thanks

_________________________________________________________________
MSN Toolbar provides one-click access to Hotmail from any Web page - FREE
download! http://toolbar.msn.com/go/onm00200413ave/direct/01/


--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page