RMAN point-in-time recovery problem

Hi,

I'm testing this RMAN feature and I've come across a strange problem.

At time T1, I made a full consistent backup of the database and the archivelogs with RMAN and then I opened the database.

At time T2 I inserted a row in an empty table test in tablespace TEST, committed the change and switched the redo log file.

At time T3 I executed a 'delete from table test', committed the change and switched the redo log file.

I wanted to restore the deleted row with RMAN: sql 'alter tablespace test offline immediate'; run {
set until time [a timestamp just before T3]; restore tablespace test;
recover tablespace test;
}

RMAN restored my backup and recovered the tablespace with the redo log corresponding to the insertion.
But in the alert.log, the error ORA-279 occured and RMAN recovered the next redo logs too.

So the row isn't in the table yet.
Any idea of the reason of this behavior? And what can I do to restore this row?

TIA Received on Wed Nov 26 2003 - 11:54:56 CST