RE: 11g Active Database Duplication

From: Blanchard, William <wblanchard_at_societyinsurance.com>
Date: Fri, 18 Dec 2009 15:26:16 -0600
Message-ID: <CB340D772D072D47A5DE07533432A7E50E08476A_at_exch1.soc.int>

Lol. You must just give Oracle Support fits.  

<Oracle Support>It works like this...</Oracle Support> <you>Um, no it doesn't, it works like this and here's how I know it...</you>    

WGB

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Robert Freeman Sent: Friday, December 18, 2009 3:23 PM
To: mjalsingh_at_gmail.com; oracle-l_at_freelists.org Subject: Re: 11g Active Database Duplication

>> Oracle support told me that RMAN first creates a copy backup of the
primary database on **source server** and then transfer it to target
>> to build the clone copy.

I can tell you that Oracle support is WRONG on that one! No copy/backup of the database is made. The network transfer takes off almost immediately and you can watch the traffic as it goes. I'd ask them to support their assertion with some real documentation.

RF  

Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it! Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex)
Oracle Database 11g New Features (Oracle Press) Oracle Database 10g New Features (Oracle Press) Other various titles
Blog: http://robertgfreeman.blogspot.com Check out my new blog series on installing Oracle Database 11gR2 on Windows using VMWare!

---

From: Manmohan Jalsingh <mjalsingh_at_gmail.com> To: oracle-l_at_freelists.org
Sent: Fri, December 18, 2009 11:17:14 AM Subject: 11g Active Database Duplication

Hi ,

Has anyone used this feature (in version 11.1.0.7) successfully to clone a database between two servers which uses different ASM diskgroups. I am trying to create a clone using following rman script which is failing during restore. Oracle support told me that RMAN first creates a copy backup of the primary database on **source server** and then transfer it to target to build the clone copy.
Is that correct? Why it needs to create a copy on source ?

run {
DUPLICATE TARGET DATABASE
TO 'DUPDB'
FROM ACTIVE DATABASE
db_file_name_convert='+DATA1/ORCL','+DATA2/DUPDB' }

Errors during the restore -

Starting backup at 17-DEC-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=376 instance=orcl3 device type=DISK channel ORA_DISK_1: starting datafile copy input datafile file number=00007
name=+DATA1/orcl/datafile/index.500.704464441 RMAN-03009: failure of backup command on ORA_DISK_1 channel at 12/17/2009 12:15:47
ORA-19504: failed to create file "+data2" channel ORA_DISK_1 disabled, job failed on it will be run on another channel

Thanks
Manmohan.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 18 2009 - 15:26:16 CST