RMAN Clone question - different server same name....

From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Tue, 11 Dec 2012 11:36:30 +0000
Message-ID: <50C71ABE.4070700_at_dunbar-it.co.uk>

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
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 11 2012 - 12:36:30 CET