Path: news.f.de.plusline.net!news-fra1.dfn.de!keepthis.news.telefonica.de!telefonica.de!newsfeed.r-kom.de!newsfeed.freenet.de!border2.nntp.ams.giganews.com!nntp.giganews.com!news.astraweb.com!newsrouter-eu.astraweb.com!hwmnpeer01.ams!news.highwinds-media.com!kramikske.telenet-ops.be!nntp.telenet.be!news.skynet.be!195.238.0.222.MISMATCH!newsspl501.isp.belgacom.be!tjb!not-for-mail
From: "Access" <anti@spam.com>
Newsgroups: comp.databases.oracle.server
References: <1170445367.358112.219150@l53g2000cwa.googlegroups.com>
Subject: Re: Recovery Scenario
Date: Fri, 2 Feb 2007 23:35:58 +0100
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
Lines: 43
Message-ID: <45c3bcce$0$3127$ba620e4c@news.skynet.be>
Organization: -= Belgacom Usenet Service =-
NNTP-Posting-Host: 081ba104.news.skynet.be
X-Trace: 1170455758 news.skynet.be 3127 81.243.142.238:1493
X-Complaints-To: usenet-abuse@skynet.be
Xref: news.f.de.plusline.net comp.databases.oracle.server:193530


"Mahi" <mahesh.kalluru@gmail.com> wrote in message 
news:1170445367.358112.219150@l53g2000cwa.googlegroups.com...
> Hi,
>
> i have a tablespace of 3.5 TB size, some body dropped one table from
> it, my senior asked me to recover that, recovering minimal amnt of
> tablespaces.
>
> We are using Oracle 9.2.0.5.0 and Sun Solaris 9.0, i tried to recover
> System , Undo & the tablespace which is having that dropped table, by
> using RMAN.
>
> 1) I have full backup of Database with Archivelogs
> 2) I created auxilary DB with Pfile of target
> 3) then i gone for PITR of tablespaces, using set until time
> 4) Restore tablespace system, rbs, ba
> 5) set new name to the datafiles
> 6) Recovering the 3 tbs skipping remaining tbs
> 7) Renaming the Redo log files
> 8) Alter database open resetlogs
> here when i checked the v$datafile it contains these  3 tablespaces
> online, SYSTEM, RBS & BA the remaining in offline drop mode.
>
> My mentor says that she wants 3 tbs only system, rbs & ba to c not all
> the other, she says i recovered complete database.
> is anything wrong i did here.
> for recovery command also i have used until time option.
>
> Please Advice me
>
> With Regards
>
> Mahesh
>

Hi,

Couldn't you have used DBMS_FLASHBACK to recover the lost table ?

Matthias