Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Help with error ORA-01189 after crash!
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:
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'
![]() |
![]() |