Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Recovery Scenario
"Mahi" <mahesh.kalluru_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 ?
Matthias Received on Fri Feb 02 2007 - 16:35:58 CST