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 -> Help with error ORA-01189 after crash!

Help with error ORA-01189 after crash!

From: RJSchulzSJ <rjschulzsj_at_aol.com>
Date: 1997/05/14
Message-ID: <19970514222600.SAA11909@ladder02.news.aol.com>#1/1

our db (Oracle for NetWare 7.3.2.) have had the biggest crash you can imagine, only the database-files are present!!!

i tried to run the following script, but i recieve the error ora-01189!

Here the complete messages (sorry, it´s a german installtation)

ORA-01503: Create Controlfile gescheitert
ORA-01189: Datei entspricht einem anderen RESETLOGS als vorherige Daten
ORA-01110: Datendatei 25: 'data:mydb\allgemd'

how can i reuse my old datafiles ????? !!!!

here is the controlfile-maker-sql-script:



connect internal

startup nomount

create controlfile reuse database "oracle" NORESETLOGS NOARCHIVELOG

   maxlogfiles 32
   maxlogmembers 2
   maxdatafiles 254
   maxinstances 1
   maxloghistory 100
logfile

   group 1 'data:oranw732\database\log2orcl.ora' size 200K,    group 2 'data:oranw732\database\log1orcl.ora' size 200K datafile

'data:oranw732\database\sys1orcl.ora',
'data:oranw732\database\usr1orcl.ora',
'data:oranw732\database\rbs1orcl.ora',
'data:oranw732\database\tmp1orcl.ora',
'data:mydb\allgemd',
'data:mydb\allgemi',
'data:mydb\archivd',
'data:mydb\archivi'


Received on Wed May 14 1997 - 00:00:00 CDT

Original text of this message

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