Tablespace restore / recovery with RMAN
Hi,
I've got a question on tablespace restore / recovery with RMAN. Background : I am currently backing up a database (in archivelog mode) using rman scripts. I use incremental backups to backup the database every night (level 0 on sun, level 1 on other days). Archive logs are backed up every hour.
I'd like to get your opinion on ways to restore the tablespace in the below scenario.
1) I create a NEW tablespace (tablespace 'TEST_TS') at 1pm today and add a bunch of tables to it.
2) I then rename the underlying datafile '/u12/oradata/TESTRMAN/test_ts01.dbf' to test_ts01.dbf.old or something.
Now how do I recover this tablespace (TEST_TS)? I tried offlining it, and restoring it from rman..but that doesn't seem to work since it doesn't have a baseline.
Any ideas? Do I have to do a point in time recovery or something?
Thanks for your time.
PS : Yes, I realize that it is a good practise to backup the database immediately after creating a new tablespace..but lets keep that aside for now.