| seema |
Posted: Sep 13, 2008 01:54:04 AM |
Total Post: 70
Joined: Jan, 2008
|
| I lost my control file now how to create new control file...? |
|
|
 ramesh |
| Posted: Sep 13, 2008 06:24:34 AM |  |
|
Total Post: 77
Joined: Dec, 2006
|
what type of backup do u hav a backup
|
|
|
|
|
| balaji |
| Posted: Sep 14, 2008 12:48:43 AM | |
|
Total Post: 161
Joined: May, 2008
|
Use the 1 which is not corrupt from backup.
Regards,
Balaji
|
|
|
|
|
| http://shaharear.blogspot.com |
| Posted: Sep 14, 2008 02:05:01 AM | |
|
Total Post: 135
Joined: Apr, 2008
|
you can use create control file !
to see how please read :
http://shaharear.blogspot.com/2008/09/create-control-file.html
|
|
|
|
|
| GOPU |
| Posted: Sep 15, 2008 01:58:55 AM | |
|
Total Post: 340
Joined: Apr, 2008
|
trace the controlfile...
alter database backup controlfile to trace.
use the trace file to recreate the controlfile.
|
|
|
|
|
| vino |
| Posted: Sep 15, 2008 11:33:06 AM | |
|
Total Post: 357
Joined: Aug, 2008
|
Hi Gopu,
Since, he lost his controlfile and automatically the db should not in a working state.. How he will be able to takeup the controlfile trace then.. If he is already having that then no problem dat to he should have latest copy of the controlfile.
Regards.
|
|
|
|
|
| seema |
| Posted: Sep 16, 2008 01:37:59 AM | |
|
Total Post: 70
Joined: Jan, 2008
|
I just want to know that how to recreate control file from trace file....?
|
|
|
|
|
| chai |
| Posted: Sep 16, 2008 02:04:13 AM | |
|
Total Post: 117
Joined: Jul, 2008
|
You can follow the steps given below, provided if you have taken backup of controlfile before getting corrupted.
Condition:If all the controlfiles are lost
step 1:Copy the trace file to a .sql extension
$cp sid_ora_1234.trc recreate.sql
step 2: Edit the .sql extension file and make necessary changes.
$vi recreate.sql
.....
------------------------------------
create controlfile reuse database test noarchivelog noresetlogs
datafile ....
logfile group 1...
....
Maxdatafiles
.....
------------------------------------
Delete everything except the lines written between --
Save and Exit
Step 3: Remove the corrupted control files from controlfile path
$ rm path/filename
Step 4: SQL>startup nomount;
Step 5: Execute the .sql extension file
SQL> @path/recreate.sql;
|
|
|
|
|
| GOPU |
| Posted: Sep 16, 2008 02:15:51 AM | |
|
Total Post: 340
Joined: Apr, 2008
|
Ok, if he does'nt have the backup of controlfile ??
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
