Get in contact with Oracle support - they can still recover your data even
without the system tablespace
"Sam Jones" <zing43000_at_yahoo.com> wrote in message
news:2663d67c.0308161642.4e836526_at_posting.google.com...
> Not that it matters, since I think we can not recover the lost data...
> but we are running Oracle 9.0, under Mandrake Linux 9.0
> with archiving on. There is no systemfile (file #1).
>
> We do have all the archived redo logs since the database was started,
> but I understand we can not apply them to a new empty database.
>
> Thanks for your help. Now we have the very unpleasant task of
> rebuilding a database from scraps of paper.
>
> -Sam
>
> "Maximus" <qweqwe_at_qwqwewq.com> wrote in message
news:<69u%a.770858$Vi5.17435006_at_news1.calgary.shaw.ca>...
> > "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 Sun Aug 17 2003 - 01:50:02 CDT
