Re: RMAN duplicate only used blocks?

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Tue, 28 Jun 2011 14:19:16 -0300
Message-ID: <BANLkTimOig=KLGxgebT_5+yKnJbBkAFxTQ_at_mail.gmail.com>



Well,

  This is pretty much what I thought, thanks everyone for your replies :-)

cheers
Alan.-

On Tue, Jun 28, 2011 at 1:33 PM, Amaral, Rui <Rui.Amaral_at_tdsecurities.com>wrote:

> That's what I have seen myself. I have had a number of "opportunities" and
> haven't seen it work any other way yet.
>
> Maybe it has to be automagically turned on? Or a hidden feature for 12.x
> :-P
>
>
>
>
> *From*: rajendra.pande_at_ubs.com [mailto:rajendra.pande_at_ubs.com]
> *Sent*: Tuesday, June 28, 2011 12:17 PM
> *To*: cicciuxdba_at_gmail.com <cicciuxdba_at_gmail.com>; oracle-l_at_freelists.org<
> oracle-l_at_freelists.org>
> *Subject*: RE: RMAN duplicate only used blocks?
>
>
> I don’t believe there is any such feature. Notice the words “I believe”
> J****
>
> What I believe is available in 11G is that RMAN is capable of backing up
> only used blocks****
>
> But in 1 iTB file if only 200M is used then my understanding will be that
> somehow magically the output file will still be 1TB even though only 200MB
> was backed up.****
>
> Of course I have not tested it yet.****
>
> ** **
>
> Thanks ****
>
> ** **
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Guillermo Alan Bort
> *Sent:* Tuesday, June 28, 2011 11:51 AM
> *To:* oracle-l-freelists
> *Subject:* RMAN duplicate only used blocks?****
>
> ** **
>
> So, the situation is this, I have a tablespace with about 600GB of free
> space (spread out in about 80 datafiles). The entire database itself has
> about 2TB and we need to copy it to another server. The problem is that we
> have 1.5TB allocated in the ASM instance in the destination server. We
> wanted to use RMAN, but the database won't fit. We could use export/import
> but it would take too long and we don't have anywhere to store the export.
>
> Someone pointed to me that RMAN was capable of duplicating only the used
> blocks... I researched a lot but I couldn't find it... so I'm either looking
> in the wrong place or that someone was wrong. (there is also the possibility
> that I'm very sleepy).
>
> I know rman can compress backups and that it only backs up used blocks
> (when doing a backupset anyway) but I think duplicate just... duplicates...
> I don't think it resizes and moves stuff around.
>
> Anyway... I think we will have to go with datapump for this one (we are on
> 11g anyway), but I was just wondering if I was missing a key feature in
> rman...
>
> thanks
> Alan.-****
>
>
> NOTICE: Confidential message which may be privileged. Unauthorized
> use/disclosure prohibited. If received in error, please go to
> www.td.com/legal for instructions.
> AVIS : Message confidentiel dont le contenu peut être privilégié.
> Utilisation/divulgation interdites sans permission. Si reçu par erreur,
> prière d'aller au www.td.com/francais/avis_juridique pour des
> instructions.
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 28 2011 - 12:19:16 CDT

Original text of this message