RE: 11g Active Database Duplication
- From: "Blanchard, William" <wblanchard@xxxxxxxxxxxxxxxxxxxx>
- To: <robertgfreeman@xxxxxxxxx>, <mjalsingh@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- 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>
WGB
_____
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Robert Freeman
Sent: Friday, December 18, 2009 3:23 PM
To: mjalsingh@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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.
Other related posts:
