11g Active Database Duplication

From: Manmohan Jalsingh <mjalsingh_at_gmail.com>
Date: Fri, 18 Dec 2009 10:17:14 -0800
Message-ID: <7c4806e20912181017q1872b46ar8bfdcff678ec4897_at_mail.gmail.com>



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 - 12:17:14 CST

Original text of this message