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.
The goal is to restore all without this specific TBS and then open the database.
Then, we would like to restore this TBS after the database is opened.
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!
The doc says :
Limitations of TSPITR
There are a number of situations which you cannot resolve by using TSPITR.
You cannot recover dropped tablespaces.
The goal is to backup all the database each week without this TBS. And then, restore all the database without this TBS in a first time.
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
OK but this command restore the whole database with checking for read only TBS. This is not my initial demand.