Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Table recovery from RMAN backup

Re: Table recovery from RMAN backup

From: <jaysingh1_at_optonline.net>
Date: Fri, 12 Dec 2003 09:44:27 -0800
Message-ID: <F001.005D9B24.20031212094427@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US