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: startup failed after repaired disk crash

Re: startup failed after repaired disk crash

From: Liz Reen <liz_at_reading.news>
Date: Fri, 28 May 1999 10:05:49 -0500
Message-ID: <MPG.11b73b204a904721989693@news.supernews.com>


In article <7if250$gj0$1_at_ernie.haupt.de>, sstaudte_at_sachsenlb.de says...
> Hi,
>
> after a disk crash on a NT 3.5.1 Server with ORACLE 7.3.3.6 we have
> repaired the server and recovered all database files from tape. The
> problem is, that the backup of database files is a file backup from a
> online database in no archive log mode. The files were open. Now I
> want to restart the database, but a error occured -> ORA-01207 file is
> more recent than control file - old control file. So I have recreated
> the controlfile with resetlogs. I want to open the database with
> resetlogs -> the database requests media recovery for the system
> tablespace. When I start " alter database recover until cancel using
> backup controlfile " , archive
> files permanent requested, but I havent such files. The database was
> in no archive log mode.
>
> Can anybody help me to startup the database ?
>
> Regards..Sigrid
>
>
>

From what I understand, you can't. I have heard that Oracle support can work miracles. Fortunately, I have never had to use them.

Liz

--
My real address is L R E E N AT P E R R I E R G R O U P dot C O M Received on Fri May 28 1999 - 10:05:49 CDT

Original text of this message

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