Re: RMAN duplicate only used blocks?

  • From: Vishal Gupta <vishal@xxxxxxxxxxxxxxx>
  • To: Brandon.Allen@xxxxxxxxxxx
  • Date: Tue, 28 Jun 2011 17:15:16 +0100

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.

Other related posts: