Re: Recovery Scenario

On Feb 3, 9:04 am, "Matthias Hoys" <a..._at_spam.com> wrote:
> "joel garry" <joel-ga..._at_home.com> wrote in message
>
> news:1170463922.615458.226530_at_h3g2000cwc.googlegroups.com...
>
>
>
>
>
> > 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... :-)
>
> DBMS_FALSHBACK exists since Oracle 9i Release 1. See the following link :http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_f...
>

Yeah, but in 9i it can't rewind a single TS past a drop table. Re-read the original post, the idea is to just get a single TS because of a table dropped from it, and related transactions, without redoing the whole db. For 9i, that would mean you would have to recover the TS into another db and then transport or otherwise move the data back. Just imagine the effects on backup schemes if the original db has another 100G in its other TS's, loaded since the dropped table, and someone resetlogs... or the effects on current transactions with the undo TS being restored...

(I welcome correction if I am wrong about any of this.)

jg

--
@home.com is bogus.
OMG http://www.msnbc.msn.com/id/16790277/