Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Table recovery from RMAN backup
Metalink Note:223543.1 has good information on how to recover just a single table using a modified TSPITR. I performed this operation successful on a data warehouse.
Josh
-----Original Message-----
Sent: Friday, December 12, 2003 8:59 AM
To: Multiple recipients of list ORACLE-L
Jay, if it is 9.2.0.4 and if you have undo_retention set, you can do
a flashback query. If not, you must recover the database to the specific
time, you cannot recover just a single table. You should probably read
the TSPITR recovery chapter in Rob Freeman's book. I have, a long time
ago, but I've never done it.
On 12/12/2003 11:14:33 AM, 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).
>
Mladen Gogala
Oracle DBA
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: mladen_at_wangtrading.com 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: Josh Collier INET: Josh.Collier_at_Banfield.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:19:26 CST