"Sam Jones" <zing43000_at_yahoo.com> wrote in message
news:2663d67c.0308160153.13cc3807_at_posting.google.com...
> 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?
You need at the very least an old backup of the system datafile to begin
recovery, without it there is no synchronization point with which to apply
redo logs. Oracle will reject any datafile that does not belong to the
original set.
Received on Sat Aug 16 2003 - 12:49:54 CDT
