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@xxxxxxxxxxxxxxxx>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@xxxxxxx [mailto:rajendra.pande@xxxxxxx] > *Sent*: Tuesday, June 28, 2011 12:17 PM > *To*: cicciuxdba@xxxxxxxxx <cicciuxdba@xxxxxxxxx>; oracle-l@xxxxxxxxxxxxx< > oracle-l@xxxxxxxxxxxxx> > *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@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *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. >