Message-ID: <F001.005D9B24.20031212094427@fatcity.com>
Date: Fri, 12 Dec 2003 09:44:27 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: ml-errors@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: jaysingh1@optonline.net
Subject: Re: Table recovery from RMAN backup
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT

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

----- Original Message -----
Date: Friday, December 12, 2003 11:34 am

> 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@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@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@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@llnl.gov
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Andy Rivenes
>  INET: arivenes@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@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@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@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).