Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01159 Wrong Database ID
The only way to get data from datafiles without control files is by
spending a lot of money to have Oracle support people come in your
office. They have their trick to do the data mining.
Yong Huang
In article <3869243d.100282478_at_super.news-ituk.to>,
See Message body for real address wrote:
> There may be, but I doubt it...the header contains info that is
related to other
> files ( particularly the Sys ones) and, if they are not the same, the
database
> will not open..Perhaps someone will have a hack that can do this...
>
> "Appie at InfoPAct" <avlenten_at_flakkee.net> wrote:
>
> >Hi,
> >
> >I'm really stuck with a big problem.
> >From an early database I only have three datafiles left. (a complete
> >tablespace)
> >All the other files, Sys1...., Usr1....., Rbs1..., Tmp1...., the
> >controlfiles and logfiles are gone.
> >No backups or dumps are available. (as always, of cource)
> >
> >What I tried to do, to get the important data out of the datafiles is
> >creating a new database,
> >exactly the some as the lost one.
> >While creating the controlfile I get the message ORA-01159, the
datafiles
> >have a
> >WRONG DATABASE ID. (The gave the new database the same DATABASENAME)
> >
> >Is there a way to put these files into a new database, or is there
somewhere
> >a tool
> >available to edit the header of the datafiles so my database will
recognize
> >them?
> >
> >Or perhaps someone has a better idea to get the data from the
datafiles?
> >
> >Thanks,
> >Ab
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Dec 28 1999 - 23:23:09 CST