Re: restore with only one datafile ...

From: Epicentre Team B Annecy <carmanet_at_epicentre.fr>
Date: Tue, 12 Feb 2002 10:57:18 +0100
Message-ID: <a4aouj$gd1$1@wanadoo.fr>

Hello,

The problem is the following:
We had a USERS tablespace with a single "users" datafile (in an archive mode DB), and we've made a hot backup, but we've lost all backuped files, except this "users" datafile!
So, is it possible to move the old datafile's objects to the new datafile, for our old users and objects being recognized in the new database?

Thanks,
Regards.

"NorwoodThree" <norwoodthree_at_my-deja.com> a écrit dans le message news: ba03e2c.0202111622.6a6ce120_at_posting.google.com...
> "Epicentre Team ANNECY" <djeanneret_at_epicentre.fr> wrote in message
news:<a48sgf$mbi$1_at_wanadoo.fr>...
> > Is possible to restore a tablespace if USER datafile is the only file
> > backuped?
> > Of course it's just an exercise for a stage !!
> >
> > Thanks
>
> I dont think I understand the question. Do you mean that your have
> multiple datafiles for the USER tablespace, and 1 of them needs to be
> restored due to corruption? Please clarify; the phrasing of your
> question makes it sound like you aren't familiar with Oracle
> architecture...
Received on Tue Feb 12 2002 - 03:57:18 CST