Re: Associating an orphaned datafile with a new database

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sat, 16 Aug 2003 09:39:12 -0700
Message-ID: <Q6t%a.489$kP.386@fed1read03>

Sam Jones wrote:

> Hi,
> We had a series of problems (human errors compounded by equipment
> failures compounded by the big blackout) that caused our only
> SystemFile to disappear, including our only backup of it. (Argh)
> We kept all the local datafiles separate. We also have the latest
> valid control files and all online and archived redo logs.
> Is there any way to create a new database (using the same creation
> script, file locations and sizes) as the old one, and convince Oracle
> that it should incorporate the saved/old datafiles from prior to the
> disaster?
>
> Thankful for any constructive advice,
> Sam

What's a "SystemFile"?

It depends.

The FIRST thing to do is to backup all the datafiles, control files and the redo logfiles.

So exactly what piece(s) of the Oracle DB are you missing?

What OS?

Which version of Oracle? Received on Sat Aug 16 2003 - 11:39:12 CDT