Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Table recovery from RMAN backup
Dear Andy & Mladen
Thanks for your immediate help.
BTW what is the best book for RMAN in the market( ver 9i). I heard some positive comments about Robert Freeman's book.
Thanks
Sami
> Take a look at TSPITR (tablespace point in time recovery), I
> believe that's
> how it's performed as I've never tried it. Essentially RMAN
> creates a
> "temporary" database, recovers the objects in the tablespace
> targeted for
> recovery, and then you can recover the data in the object(s) in
> question.
>
> At 08:14 AM 12/12/2003 -0800, jaysingh1_at_optonline.net wrote:
> >Hi Gurus,
> >
> >I have accidentally deleted my table in development env. RMAN is
> the only
> >backup available here. How do i recover the droped table?
> >
> >Any help would be really appreciated.
> >
> >TIA
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >--
> >Author:
> > INET: jaysingh1_at_optonline.net
> >
> >Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> >San Diego, California -- Mailing list and web hosting services
> >------------------------------------------------------------------
> ---
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
>
> Andy Rivenes
> Lawrence Livermore National Laboratory
> Phone: 925-424-9834
> Email: arivenes_at_llnl.gov
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Andy Rivenes
> INET: arivenes_at_llnl.gov
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> -------------------------------------------------------------------
> --
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: jaysingh1_at_optonline.net Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Dec 12 2003 - 11:44:27 CST