Re: 11g Active Database Duplication
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: mjalsingh@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 18 Dec 2009 13:22:36 -0800 (PST)
>> 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: ManmohanJalsingh <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:
