Originally posted by badrinathn
Hi,

I want to make use of the RMAN utility, available with the oracle 8i. I have installed 2 databases(prod and catdb). The initial steps of connecting to RMAN, registering db etc are complete.

I wanted to create and resolve this scenerio

1) Create a table (A) on tablespace (TSA), populate it.
2) Take the rman tablespace backup(TSA).
3) Drop the table(A)

Now, I want to get back the table(A) from the rman backup.

How can I get it back;

Steps will be very useful.
Badrinath
Rman does not support logical backups. If you wanted to create the scenario it would be best to do a export then drop the table and perform a import. If you were to do this with Rman you would essentially have to perform a tablespace recovery or database recovery using the restore database;
recover database while inside of RMAN. Make sure you have at least one good backup before you begin.