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

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 11 Dec 2012 10:18:02 -0800
Message-ID: <CAORjz=NnXKmKVtJyGc8o=3Ye8XRg0TqbJAZg7_r4uVKHeWcm8Q_at_mail.gmail.com>



On Tue, Dec 11, 2012 at 3:36 AM, Norman Dunbar <oracle_at_dunbar-it.co.uk>wrote:
> 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.
>
>

Hi Norman,

I've not had to to this recently, so I pulled a script from my notes:

Some of it can be edited - the 2nd channel and NBU parameters for instance.

It is fairly straightforward - a lot of the problem is the lame terminology.

HTH Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com


The terminology used here is somewhat counterintuitive.

The database be copied is the TARGET
The database that is the destination is AUXILIARY

Target DB: PR09
Auxiliary DB: TS01

Connect to RMAN

TARGET = source database
AUXILIARY = new database

NBU Password for

   $OH/bin/rman target nbu/PASSWORD_at_pr09 auxiliary / nocatalog

RMAN Script

RUN
{
allocate channel C1 device type 'sbt';

allocate auxiliary channel C2

   device type 'sbt'

 parms="ENV=(NB_ORA_POLICY=ORA_ordb02_agile_full,NB_ORA_CLIENT=ordb02,NB_ORA_SERV=rsysnbu)";

# if you want two channels to tape (2 drives) allocate auxiliary channel C3

   device type 'sbt'

 parms="ENV=(NB_ORA_POLICY=ORA_ordb02_agile_full,NB_ORA_CLIENT=ordb02,NB_ORA_SERV=rsysnbu)";

   set until time "to_date('08/25/2006 22:33:21','mm/dd/yyyy hh24:mi:ss')";

   DUPLICATE TARGET DATABASE TO TS01 ; }

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 11 2012 - 19:18:02 CET

Original text of this message