| raj |
Posted: Aug 10, 2007 06:49:50 AM |
Total Post: 15
Joined: Aug, 2007
|
| i lost my all control files is it possible to restore all control files |
|
|
Ramesh Joyisa |
| Posted: Aug 10, 2007 07:32:20 AM | |
|
Total Post: 226
Joined: Aug, 2007
|
Start the database in NOMOUNT mode and Create the control file using command CREATE CONTROLFILE statement, specifying the NORESETLOGS option ,Recover the database as normal and then open database
|
|
|
|
|
Mohammed Taj |
| Posted: Aug 11, 2007 12:43:32 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
And Addition of ramesh suggestion...
you can check all scnerio related control files
http://dbataj.blogspot.com/2007/04/all-control-file-lost-without-backup.html
regards
Taj
|
|
|
|
|
dipali |
| Posted: Aug 11, 2007 08:01:21 AM | |
|
Total Post: 31
Joined: Dec, 2006
|
and after recreating control files, dont forget to take it's backup using
"alter system backup controlfile [to trace]"
command.. so that you can use it to recreate control file next time when you again lose the control files..
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |