REGARDING CONTROL FILE

Can anybody tell me what are the steps
If control is corrupt
this is very urgent plz. help me

Here are some of the threads that discusses on this issue. Always first try to recover from your backup. If that doesn't work, as a last resolution only choose to rebuild the control file .


http://www.dbasupport.com/forums/sho...?threadid=7833

http://www.dbasupport.com/forums/sho...?threadid=5619

http://www.dbasupport.com/forums/sho...?threadid=5130

http://www.dbasupport.com/forums/sho...?threadid=3109

http://www.dbasupport.com/forums/sho...?threadid=1532

Good luck
Sam

Follow these steps:
1. Shutdown the database(if its running)
2. Mount the database
3. run this command
svrmgr>alter database backup controlfile to trace;
This creates trace file in USER_DUMP_DEST.
4. Edit the trace file and remove header information and
rename this file to say create_control.sql
5. Shutdown database
6. @create_control.sql
7. alter database open

GOOD LUCK