Re: Lost controlfile

From: michael ngong <mngong_at_yahoo.com>
Date: 4 Feb 2002 09:12:07 -0800
Message-ID: <ecf365d5.0202040912.7485e0a8@posting.google.com>

sashmore_at_neonramp.com (Stephen C Ashmore) wrote in message news:<4ef331c3.0202030735.25511d37_at_posting.google.com>...
> "Amadou O. Wane" <amadouW0000_at_email.uophx.edu> wrote in message news:<a3fnt2$188stf$2_at_ID-18576.news.dfncis.de>...
> > Hello,
> > I lost the controlfile for my database and can't start the db. Is there a
> > way out of this predicament?
> >
> > Thanks
>
> Hi,
> you must either go to your last backup of your control file and use
> 'recover database using backup control file'
>
>
> or use the create control file command.
>
> I would suggest you configure your database to have at least 2
> and perferable 3 control files.
>
> Stephen C. Ashmore
> Brainbench MVP for Oracle Administration
> http://www.brainbench.com

Could you give a little bit of details here. Did you have only one controlfile?If yes you may to restore it from a backup and go from there.Restore all datafiles and controlfile(s) but not online redo log files from a backup and
Mount database
Recover automatic using backup controlfiles alter database open resetlogs

If you have more than one just copy the present one over the missing one and then restart your database

Hope that helps
Michael Ngong (Sr DBA) Received on Mon Feb 04 2002 - 11:12:07 CST