Yeah even then I had a customer site with a bad backup strategy and a
corrupted system datafile
and Oracle could not help me at all.
<yong321_at_yahoo.com> wrote in message news:84c5c3$4jb$1_at_nnrp1.deja.com...
> 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 Thu Dec 30 1999 - 21:54:45 CST
