Re: Recovery Scenario

"Matthias Hoys" <anti_at_spam.com> wrote in message news:45c4c0ba$0$3145$ba620e4c_at_news.skynet.be...
>
> "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
>
>

I meant FLASHBACK :-) Received on Sat Feb 03 2007 - 11:05:43 CST