Re: Recovery Scenario

"joel garry" <joel-garry_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_flashb.htm

Matthias Received on Sat Feb 03 2007 - 11:04:59 CST