RE: 11g Active Database Duplication
Date: Fri, 18 Dec 2009 15:26:16 -0600
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>
[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.
Robert G. Freeman
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>
Sent: Fri, December 18, 2009 11:17:14 AM Subject: 11g Active Database Duplication
Has anyone used this feature (in version 18.104.22.168) 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
Is that correct? Why it needs to create a copy on source ?
DUPLICATE TARGET DATABASE
FROM ACTIVE DATABASE
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