Database Software

Hi,

I am testing rman and I have a problem to restring a dropped table. I set archivelog on and Flashback is off.
Yesterday I have created tablespace as MYDATA (#6) and created a table called t1. I used ramn to backup the tablespace yesterday after adding some records to table t1.
Today I dropped the table t1 and created a table called t2. I added some records to table t2 and took a backup of the tablespace.
I wanted to restore t1 from my yesterday’s backup and did following:

RMAN> list backup of datafile 6 summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
38 B F A DISK 23-JAN-10 1 1 NO TAG20100124T121426
45 B F A DISK 24-JAN-10 1 1 NO TAG20100124T151946

RMAN> SQL ‘ALTER DATABASE DATAFILE 6 OFFLINE’;
RMAN> RESTORE DATAFILE 6 FROM TAG = TAG20100124T121426;
RMAN> RECOVER DATAFILE 6;
RMAN> SQL ‘ALTER DATABASE DATAFILE 6 ONLINE’;

When I query database, I cannot see t1 table but I can only query table t2. Where do I do mistake? Could you please explain.

Thank you