| viral |
Posted: Jan 09, 2008 08:19:14 AM |
Total Post: 8
Joined: Jun, 2007
|
hii everyone..
here im facing a very serious problem wid my control files... my files are lost... then how to recover it.. i hav no bckup.......
seekin for the best n satisfied answer....
......urs friendly.....
bye.... |
|
|
 Murtuja |
| Posted: Jan 09, 2008 08:45:12 AM |  |
|
Total Post: 857
Joined: Jan, 2006
|
STARTUP MOUNT
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
|
|
|
|
|
| Mohammed Taj |
| Posted: Jan 09, 2008 09:18:01 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
Murtuja,
how can OP mount his database without controlfiles ?
OP lost all controlfile without backup.
there is only one way to recreate controlfile LIKE BELOW.
http://dbataj.blogspot.com/2007/03/all-control-file-missing-without-backup.html
|
|
|
|
|
| Babu |
| Posted: Jan 09, 2008 09:38:03 AM | |
|
Total Post: 94
Joined: Oct, 2007
|
Taj,
Murtuja saying correct. To create text based controlfile in mount stage. After in Nomount stage need to create controlfile.
Babu
|
|
|
|
|
| Mohammed Taj |
| Posted: Jan 09, 2008 09:50:43 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
Babu,
Yes murtuja is correct if we are able to Mount our database without controlfile.
but reread OP question.
OP lost all controlfiles + without controlfiles backup.
now can you mount your database without controlfile ???
Answer is NO.
that is why we need to follow below step.
1. conn with sys user
2. startup nomount
3. create controlfile
4. alter database open;
|
|
|
|
|
| Murtuja |
| Posted: Jan 10, 2008 03:54:51 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Thanks Mohammed and Babu.This discussion cleared my doubt.
Thanks again
|
|
|
|
|
| Murtuja |
| Posted: Jan 10, 2008 03:59:19 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Below link confirms Mohammed's point.
Create New Control File After Losing All Current and Backup Control Files
http://download-uk.oracle.com/docs/cd/B19306_01/backup.102/b14191/osrecov005.htm
|
|
|
|
|
| Babu |
| Posted: Jan 10, 2008 04:06:51 AM | |
|
Total Post: 94
Joined: Oct, 2007
|
I got your point. Thank you Taj.
Babu
|
|
|
|
|
| viral |
| Posted: Jan 10, 2008 05:51:04 AM | |
|
Total Post: 8
Joined: Jun, 2007
|
thanks a lot all of uu..
especially taj sir.. very grateful of u..
v did the practical according to d link given by u successfully.......
again thanks a lotttttttttttt... :-)
Ur's friendly...
V!R@l....... n gang.....
hav a nice time.....
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
