That's it!!
We want to build a new database, and be able to fill in the new
"users01.dbf" with the objects of the backuped old one!
"koert54" <nospam_at_nospam.com> a écrit dans le message news:
3c68f9d4$0$12222$4d4efb8e_at_news.be.uu.net...
> 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 - 06:58:59 CST
