Re: RMAN Clone question - different server same name....
Date: Wed, 12 Dec 2012 08:25:29 +0000
Message-ID: <50C83F79.2000604_at_dunbar-it.co.uk>
Morning Jared,
On 11/12/12 18:18, Jared Still wrote:
> I've not had to to this recently, so I pulled a script from my notes:
> ...
Thanks for that. My problem was having to have, as I thought, the tns alias for the auxiliary database the same as it's actual db_name. Last time I did one of these clones, it barfed at the "duplicate ... to alias ...", because, as it told me, the alias name didn't match the db_name name.
I therefore thought that the alias for the auxiliary database, defined on the target server's tnsnames, had to be the same as the sid for the auxiliary.
However, I did it yesterday and it accepted it quite happily this time. Sometimes I really hate RMAN/Oracle!
It's still running, copying the files over, so I expect it to barf at the "switch" command, like my last one did, because I apparently have a file from a previous incarnation. I have an SR open on that one!
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-lReceived on Wed Dec 12 2012 - 09:25:29 CET