Re: ora-00205 control files missing

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 26 Oct 1999 18:57:55 +0200
Message-ID: <940957103.17887.0.pluto.d4ee154e@news.demon.nl>

If you have 1 valid controlfile and the other two are missing, just copy the first.
If you don't have controlfile but do have a database, check out the create controlfile statement.
To do so you need to run svrmgrl / svrmgr<xx> connect internal
startup nomount
your create controlfile statement
alter database open resetlogs

Hth,

--
Sybrand Bakker, Oracle DBA
<sgrutt_at_my-deja.com> wrote in message news:7v4bb8$p9$1_at_nnrp1.deja.com...
> I cannot start the database. I get ora-00205 control files missing
> error. The initSID file points to two control files which do not exist.
> Is there a way I can create them?
>
> Thanks.
> sgruttad_at_netsetgo.net
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Oct 26 1999 - 11:57:55 CDT