Re: Recovery Scenario

On Feb 2, 2:35 pm, "Access" <a..._at_spam.com> wrote:
> "Mahi" <mahesh.kall..._at_gmail.com> wrote in message
>
> news:1170445367.358112.219150_at_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 ?
>

Methinks that is a new feature for 10g. Metalink Note:335851.1 shows another 10g feature, Automatic TSPITR in 10G RMAN. In an phone interview I did while sitting in my car, I kind of half-recalled that, consequently confusing the interviewers as to the minimum work it takes to restore a specific TS. I can't help but wonder if the OP is at that same place... :-)

jg

--
@home.com is bogus.
"The trick is to find a boss who is happy to allow us to be
generalists but pay us the wages of a specialist." - Andrew Clarke