Can anybody tell me what are the steps
If control is corrupt
this is very urgent plz. help me
Printable View
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