Re: RMAN Clone question - different server same name....
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-lReceived on Tue Dec 11 2012 - 19:18:02 CET