| sam |
Posted: May 26, 2008 04:43:49 AM |
Total Post: 11
Joined: May, 2008
|
hi
my database is in archive logmode i have no any type of backup and my controlfile is corrupt.
i want to recreate controlfile so is it possible to create controlfile
without any type of backup if yes
so plz help me
thanks
Regards
samir amin |
|
|
Murtuja |
| Posted: May 26, 2008 05:19:35 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Hi,
http://www.orafaq.com/wiki/Control_file_recovery
HTH
|
|
|
|
|
fozturk |
| Posted: May 27, 2008 02:03:41 AM | |
|
Total Post: 69
Joined: Sep, 2007
|
could you solve your issue? if not pls tell me if you can nomount or open your db?
1# if you can mount, use below script in nomount you can use:
CREATE CONTROLFILE SCRIPT... (check for the full script @google)
2# if you can open your db, then trace your current control file with ALTER DATABASE BACKUP CONTROLFILE command. It will place a trace file to your udump folder.
hope it helps.
|
|
|
|
|
sam |
| Posted: May 27, 2008 02:12:27 AM | |
|
Total Post: 11
Joined: May, 2008
|
thanks everybody i solved this problem with ur help
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |