| muzu |
Posted: Aug 14, 2007 12:06:04 PM |
Total Post: 37
Joined: Aug, 2007
|
When ever we loose all the control files? how is it possible to recover the database ?
When we start the database in nomount mode, the oracle reads from the pfile or spfile. But by specifying the create control file command how it is getting the loction of the redo log files and the data files ?
Please let me know this answer. |
|
|
 Ramesh Joyisa |
| Posted: Aug 15, 2007 08:35:00 AM |  |
|
Total Post: 226
Joined: Aug, 2007
|
yes it is possible to recover
|
|
|
|
|
| Ramesh Joyisa |
| Posted: Aug 15, 2007 08:35:41 AM | |
|
Total Post: 226
Joined: Aug, 2007
|
For recovering database u can
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
|
|
|
|
|
| muzu |
| Posted: Aug 16, 2007 03:07:54 AM | |
|
Total Post: 37
Joined: Aug, 2007
|
Thanks for ur replies! Also i want to know about the following questions
What is the option 'NORESETLOGS' used for ?
Also my doubt is how does the control file is getting recreated exactly in the state as it was before it was lost. How does it get all the checkpoint and header information exactly as it was before together with the location of redologs and datafiles.
Please explain on this.
|
|
|
|
|
| Mohammed Taj |
| Posted: Aug 18, 2007 02:50:06 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
http://dbataj.blogspot.com/2007/04/lost-all-controlfile-and-redolog-files.html
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
