This content has been marked as final. Show 6 replies
I hesitate to answer as I live in a give a little get a little world.
You have 22 questions but have never closed any of them.
Total Questions: 22 (22 unresolved)
Please consider closing your old questions to keep the forum clean.
As to your question help me to understand why you cannot restore everything and then alter the tablespace to read only.
OK. Thank you.
This is not exactly your goal but the simple thing would restore the whole database. Drop the tablespace and do a tablespace point in time.
This is older but I don't believe it changed much in Oracle 11
You have a very tough requirement!
You and the document are correct.
The only other option that come to mind is using a combination of Data Pump and RMAN. So use Data pump for the tablespace
Or make the tablespace read-only before the backup and use CHECK READONLY keywords and rman to restore ( not tested by me )
RMAN> restore database check readonly;
Edited by: mseberg on Nov 9, 2012 8:11 AM