RMAN: partial recovery of partioned tables
I'm using Oracle 18.104.22.168 an would like to make a partial copy (not duplicating all tablespaces) of my database using the SKIP feature of RMAN DUPLICATE.
The problem is that I got a partitioned table tab1 having the partition part1 on tablespace tbs1 and a second partition part2 on tablespace tbs2.
What I would like to do is to make a recovery/duplicate of my DB. I want to duplicate only the tablespace SYSTEM and the tablespace tbs1.
Will this be possible or will oracle have any problem because I do not include all partitions of tab1. Will there be any problem when RMAN will try to drop the not recoverd/duplicated tablespace tbs2 because it inlcudes some partitions of the table tab1?
If someone has any experience in this area I would be gratefull to get any feedback
Click Here to Expand Forum to Full Width