Re: Question: Yet more RMAN frustration...

From: Oliver Gehlert <funklover4u_at_yahoo.de>
Date: Wed, 03 Aug 2005 22:52:39 +0200
Message-ID: <dcrapg$ij0$1@online.de>

you are missing the main point:
if rman can successfully apply all the changes made to a tablespace, it will reapply all these changes when recovering your tablespace! Rman restores your tablespace from the backup and then applies all the changes form the archived logs and the redo logs until there are all(!) changes applied. RMAN is working correctly. Please have a look at the oracle concepts guide.

You must do an incomplete recovery - and as you want only one tablespace recoverd to an earlier point in time, have a look at TSPITR in the docs (tablespace point in time recovery).

HTH Oliver Received on Wed Aug 03 2005 - 15:52:39 CDT