Re: Recovery Scenario

Mahi wrote:
> 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

You haven't done anything wrong. However you could have save some time by using RMAN DUPLICATE command with the SKIP TABLESPACE option. And the   other datafiles wouldn't have shown up in v$datafile with this method (RMAN does the housekeeping for us with this method.)

Jerome Received on Sat Feb 03 2007 - 08:33:27 CST