RMAN tablespace recovery question

[askdjaskdj]

Hi,
I'm having a problem recovering a tablespace to it's most recent state and was wondering if i'm missing something during the restore and recovery process. Here's what i'm doing (i've setup an RMAN catalog and left all the default settings intact).

1) i create a test table in my target database, (let's call it "test1"), in a newly created tablespace, (call it "test_tbs1")

2) i load 100 sample rows in that table

3) i backup my target database using RMAN:
backup database plus archivelog

4) then i go back to the test table and i delete 50 rows from it, and commit the transaction.

5) now i go back to RMAN, and do tablespace recovery for that specific tablespace (i.e. test_tbs_1) by running:
run {
allocate channel C1 type DISK;
sql "alter tablespace test_tbs_1 offline";
restore tablespace test_tbs_1;
recover tablespace test_tbs_1;
sql "alter tablespace test_tbs_1 online";
release channel C1;
}

6) After that, i go back to my target database and run a query to see how many rows are present in the test1 table by running:

select count(1) from test1

I would expect to see 100 rows (the original number)...instead I still see only 50 rows. Why is this not working as i expected it to work?

I really hope someone can point out what i'm missing here.

Thanks

[davey23uk]

no you restored and recovered to the point you left off, therefore 50 rows

if you want the 100 back you have to do tablespace point in time recovery

[Bore]

Read a bit more about backup/recovery. This topic is too crucial to learn it in the way of test and fail