| mit |
Posted: Apr 22, 2007 03:29:11 AM |
Total Post: 48
Joined: Sep, 2006
|
Hi,
Can any one suggest what to do when all control files are lost,
please tell me what to do ,i do not have backup of control files.
Thanx
AMIT |
|
|
 Jayanta |
| Posted: Apr 22, 2007 12:40:42 PM |  |
|
Total Post: 479
Joined: Feb, 2006
|
u may recreate those control files!
cheers!
|
|
|
|
|
| Vigyan |
| Posted: Apr 22, 2007 05:53:23 PM | |
|
Total Post: 386
Joined: May, 2001
|
As Jayanta said, you can re-create control files if you have all your data files and archive log files. You will also need online redo log files to recover database.
Thanks,
Vigyan
|
|
|
|
|
| mit |
| Posted: Apr 23, 2007 12:38:12 AM | |
|
Total Post: 48
Joined: Sep, 2006
|
Hi, can u tell me the steps to recreate the control file.
Thanx
AMIT
|
|
|
|
|
| Ahmed |
| Posted: May 09, 2007 03:02:55 AM | |
|
Total Post: 13
Joined: Mar, 2006
|
can u tell us about your database version, backup strategy and operating system type?
if this is a general question you will be able to recreate your controlfile from a backup to trace file
|
|
|
|
|
| mit |
| Posted: May 12, 2007 01:26:42 AM | |
|
Total Post: 48
Joined: Sep, 2006
|
Hi,ahmed
I have oracle 9.2.0.5.0 with windows2000 operating system and i have no backup
Thanx
AMIT
|
|
|
|
|
| KS |
| Posted: Jun 20, 2007 11:42:09 AM | |
|
Total Post: 65
Joined: Nov, 2006
|
Hi all,
I have one question,
since he lost all the control files , he can't use the
alter database backup controlfile to ['filename' | trace] command.
are you people suggesting him to take the control file backup from similiar Database and then edit it as per his Database ??
- Sri.
|
|
|
|
|
| Jayanta |
| Posted: Jun 21, 2007 02:03:28 PM | |
|
Total Post: 479
Joined: Feb, 2006
|
hello sri,
before making any comments plz read about the topic from various resource and try to analyze what others mean to say.
regards!
|
|
|
|
|
| KS |
| Posted: Jul 09, 2007 09:38:50 AM | |
|
Total Post: 65
Joined: Nov, 2006
|
Hi Jayanta,
I'm clear about my comments, kindly let me know if you feel any mistakes in my comments.
Regards,
Sri.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
