Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: restore with only one datafile ...
What you are saying is :
- we've lost our complete database - we've lost our complete backup - somewhere on our tapes we've found one datafile (users01.dbf or something) - we want to salvage the data in that one datafile
correct ?
"Epicentre Team B Annecy" <carmanet_at_epicentre.fr> wrote in message
news:a4aouj$gd1$1_at_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 - 05:15:22 CST