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: Galen Boyer <galenboyer_at_hotpop.com>
Date: 8 Jul 2001 14:17:08 -0500
Message-ID: <wkg0c76xm3.fsf@msn.com>

On 8 Jul 2001, jgaldames_at_xmmcorp.com wrote:

> We lost one drive which had the system and tools datafiles. The
> database instance was created only a week ago. I didn't create
> a cold backup right after creating the database because I'm a
> new dba and didn't know that would be a good idea. Any... I
> have all the other datafile, the control file and the init.ora
> file. Is there a way to recover from this? We don't want to
> loose the data that is in those datafiles.

I believe you are dead here except you may be able to use DUL? This was discussed in an earlier thread. There was some discussion going on regarding the OraFocus.com site and Kurt, k_at_k.com talked about building a tool like this. But since the open source version isn't built yet, maybe Julie can use the DUL (Data unloader) tool that Kurt mentioned for like $250 an hour. I don't where this tool is. Kurt?

It sure would be nice to be able to just give an open source version of this tool to someone who is found in Julie's predicament, don't you think?

-- 
Galen
I don't want to be the rock.  Yeah, okay, what do you want to be?
I want to be the piece of glass.
Received on Sun Jul 08 2001 - 14:17:08 CDT

Original text of this message

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