Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: loss of system datafile with no cold backup

Re: loss of system datafile with no cold backup

From: Brian Peasland <oracle_dba_at_qwest.net>
Date: Thu, 12 Jul 2001 20:28:35 GMT
Message-ID: <3B4E0873.470A6BFD@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 - 15:28:35 CDT

Original text of this message

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