Re: restore a single datafile

What do you mean with proper backup ?
RMAN or a backup utility ??
[Quoted] I've no enterprise manager environment, only a flat copy of the file with the db closed.
Thanks
AG

[Quoted] "Dusan Bolek" <pagesflames_at_usa.net> wrote in message news:1e8276d6.0301150850.61e15f6d_at_posting.google.com...
> "gritto" <agrittini_at_yahoo.com> wrote in message
news:<3e254898$0$227$4d4efb8e_at_read.news.it.uu.net>...
> > Hi all,
> > is it possible to restore a single datafile (or tablespace) from a
backup by
> > attaching the file ??
> > I've dropped a tablespace yesterday, but I can restore from a backup the
> > datafile that is in the tablespace, so I'd like to know if there is a
mode
> > to include that old datafile again in the db without repplying all the
log,
> > or reimport the data.
> > The tablespace contains data for a single user, so no data are lost
around,
> > all is included in that file.
>
> You can't restore single datafile by attaching it to database. It
> doesn't matter if you have any data around. In fact you have always
> some data around, even if it is a single tablespace for single user.
> However, you're not lost. If you have proper backup, you can easily
> recover database to the time before dropping and then just transfer
> data between your database and restored one using DB link, exp/imp, as
> you wish.
>
> --
> _________________________________________
>
> Dusan Bolek, Ing.
> Oracle team leader
>
> Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
> can call it an overture to bankruptcy) on that server. I'm still using
> this email to prevent SPAM. Maybe one day I will change it and have a
> proper mail even for news, but right now I can be reached by this
> email.
Received on Wed Jan 15 2003 - 18:02:57 CET