Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to restore a controlfile ?
On Thu, 14 Jan 1999 ppla_at_sgosoft.com wrote:
>
> I hope you have more than one control file. You can't recover
> an older controlfile because controlfiles keep the database
> timestamp.
> You may startup your database removing the controlfile lost from
> the controlfile list specified on the init.ora. Then you may use
> the alter database backup controlfile to trace to generate an
> script for creating another controlfile to replace the lost one.
> If you don't have more controlfiles your are really in trouble
> so you must contact oracle.
There is no need to throw in the towel yet! If you know where your files live, you can write your own "create controlfile" statement. After all, you probably know or can find out all the information that would have been in the backed-up-to-trace controlfile script. I posted the section from the Oracle Documentation of how to accomplish this recently on this newsgroup. The article can be accessed at the following URL:
http://www.dejanews.com/getdoc.xp?AN=425023376
--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah
Received on Thu Jan 14 1999 - 10:43:32 CST