This is my understanding as well. RMAN will decompress the unused blocks and create an block for block copy on target database. I have not read/heard of RMAN being able to restore only used block. Regards, Vishal Gupta Email - vishal@xxxxxxxxxxxxxxx Blog - http://blog.vishalgupta.com Twitter - http://www.twitter.com/vishalgupta77 LinkedIn - http://uk.linkedin.com/in/vishalgupta77 On 28 Jun 2011, at 17:10, Allen, Brandon wrote: > I’ve never heard of such a feature, but would also be interested to hear if > someone else knows about it. I’m guessing maybe the person that mentioned > this to you was just confused about the fact that RMAN will only write used > blocks to the backup set, but when it restores the backup, it fills in those > unused blocks again. I’m pretty sure that duplicate works exactly the same > as a regular restore – it just automates the other stuff for you like > creating the controlfile, renaming datafiles, setting the new DBID, etc. I > agree that it sounds like you’ll need to use data pump, unless maybe there is > only a subset of tablespaces that you need – then you could use transportable > tablespaces just for those, and you can use RMAN to create the transportable > tablespaces if required to avoid downtime in the source database. > > Regards, > Brandon > > > Privileged/Confidential Information may be contained in this message or > attachments hereto. Please advise immediately if you or your employer do not > consent to Internet email for messages of this kind. Opinions, conclusions > and other information in this message that do not relate to the official > business of this company shall be understood as neither given nor endorsed by > it.