Path: news.f.de.plusline.net!news-fra1.dfn.de!news.tele.dk!feed118.news.tele.dk!postnews.google.com!l53g2000cwa.googlegroups.com!not-for-mail
From: "Mahi" <mahesh.kalluru@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Recovery Scenario
Date: 2 Feb 2007 11:42:47 -0800
Organization: http://groups.google.com
Lines: 32
Message-ID: <1170445367.358112.219150@l53g2000cwa.googlegroups.com>
NNTP-Posting-Host: 81.240.25.245
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1170445372 25978 127.0.0.1 (2 Feb 2007 19:42:52 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 2 Feb 2007 19:42:52 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: l53g2000cwa.googlegroups.com; posting-host=81.240.25.245;
   posting-account=SpS2lg0AAAAFCiujvENGVtirRIFqdgo4
Xref: news.f.de.plusline.net comp.databases.oracle.server:193521

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