Re: RMAN - Dropping Tablespaces!!!

I tried to reproduce this on a test machine using 8.1.5 on NT and found that after RMAN synchronizes itself the "list backup;" command will no longer show the datafiles that were associated with the dropped tablespace. However, one could still recover this tablespace if one performed a point-in-time recovery of the database.

That means that the backupsets themselves are not changed, only the list is updated to show the current structure of the database.

This may be different on your system.

One way to test would be to get a development version of Oracle 8.0.4 from http://technet.oracle.com and place it on a linux box. Create a small dummy production database and a recovery database. Create a new tablespace in the dummy database and insert something in it. Make a backup with the current control file using rman. Drop the tablespace. Note that the rman list backup command no longer shows the datafile. Then recover until the scn associated with the backup that contained the tablespace. You should have the tablespace back again in the new database incarnation.

Frank Hubeny

sbenyo_at_my-deja.com wrote:

> Hi,
>
> I'm using RMAN with oracle 8.0.4.4 on unix.
> The problem is that when I drop a tablespace, RMAN synchronizes itself
> and detects that a tablespace was dropped and removes all the datafiles
> associated with this tablespace from the availiable backupsets!!
>
> This means I cannot restore the dropped tablespace anymore!
>
> Is there any way to avoid this problem and restore/recover dropped
> tablespaces using RMAN ????
>
> Any help will be most appreciated!!
>
> Thanks,
>
> Shaul
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Feb 19 2000 - 21:48:10 CST