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;
Originally posted by badrinathn
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.