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

  • From: "Kenneth Naim" <kennethnaim@xxxxxxxxx>
  • To: <oracle@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 11 Dec 2012 06:41:45 -0500

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


Other related posts: