If it is the same sid as the original just do a restore and recover not a clone. Ken -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Norman Dunbar Sent: Tuesday, December 11, 2012 6:37 AM To: oracle-l@xxxxxxxxxxxxx Subject: RMAN Clone question - different server same name.... I'm about to clone a clone of a clone of a clone and it's 6.5 TB in size. I'm a tad concerned, before I start, because I don't see how to do this in the docs, or in any of my books on RMAN. I need the auxiliary database to have the same structure, and SID as the target. I need to have a tnsnames.ora entry for the clone, which can't be the same as the target - for obvious reasons. if I create an alias like aux when RMAN connects to aux to do the duplicate, it complains about the db name being different to that in the "duplicate target database to aux. I know I can clone the target to a newly named auxiliary, and then "nid" that to rename it. But I was wondering how I can easily duplicate (from active database) to a new database, with an identical path name structure and SID as the target? Could I clone from the auxiliary as opposed to the target? Would that work? I'd avoid the need to have the auxiliary database in the tnsnames.ora so I should be able to get away with it. As I'm running on different servers, I'm using NOFILENAMECHECK and I'd really rather not end up with an overwrite problem on the target database. I'm not that much of an RMAN expert to know what it will do in this situation. Thanks. Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 -- //www.freelists.org/webpage/oracle-l ----- Checked by AVG - www.avg.com Version: 2012.0.2221 / Virus Database: 2634/5449 - Release Date: 12/10/12 ----- Checked by AVG - www.avg.com Version: 2012.0.2221 / Virus Database: 2634/5449 - Release Date: 12/10/12 -- //www.freelists.org/webpage/oracle-l