Re: loss of system datafile with no cold backup

From: koert54 <k_at_k.com>
Date: Thu, 12 Jul 2001 22:50:00 GMT
Message-ID: <sQp37.5027$Xy1.932612@afrodite.telenet-ops.be>

That's correct - if your system ts is gone - so is your program logic ...

"Brian Peasland" <oracle_dba_at_qwest.net> wrote in message news:3B4E0873.470A6BFD_at_qwest.net...
> > is down and corrupted) ... if you lost the datafile it'll use its own
> > heuristic functions to create a
> > dictionary by scanning the remaining DB files - the downpart is that all
> > your tablenames & column
> > names are gone ....
> > I was so impressed by this tool that I started 'designing' my own little
> > data unloader...
> > The problem is that info on the datafile format is as good as non
existing
> > and I will consider it
> > allready a small victory if I'll be able to unload a simple table....
(hey
> > you have to do something
> > for fun ???) However- information on DB blocks and the byte layout of
tables
> > can be reconstructed...
>
> But the tool won't be able to extract procedures, functions, sequences,
> etc from a loss of a SYSTEM datafile right?
>
> Brian
Received on Thu Jul 12 2001 - 17:50:00 CDT