Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to restore a controlfile ?

Re: How to restore a controlfile ?

From: <ppla_at_sgosoft.com>
Date: Thu, 14 Jan 1999 15:06:40 GMT
Message-ID: <77l15p$2ni$1@nnrp1.dejanews.com>


Hi,
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.

Força Barça.

Pep.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Jan 14 1999 - 09:06:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US