Re: RMAN Restore on different server

On Feb 20, 1:41 pm, "Pete's" <empete2..._at_yahoo.com> wrote:
> On Feb 19, 11:36 pm, Mladen Gogala <mgogala.SPAM_ME...._at_verizon.net>
> wrote:
>
>
>
> > On Mon, 19 Feb 2007 08:02:56 -0800, sybrandb wrote:
> > > On Feb 19, 4:51 pm, Mladen Gogala <mgogala.SPAM_ME...._at_verizon.net>
> > > wrote:
> > >> On Mon, 19 Feb 2007 05:43:05 -0800, Pete's wrote:
> > >> > If you use the following parameters in your target database, rman
> > >> > should perform the renames on the datafiles for you when run the
> > >> > cloning command:
>
> > >> > db_file_name_convert = (/oracle/PDB1/d01,/oracle/XDB1/d01,
> > >> > /oracle/PDB1/d02,/oracle/XDB1/
> > >> > d02)
> > >> > log_file_name_convert = (/oracle/PDB1/l01,/oracle/XDB1/l01,
> > >> > /oracle/PDB1/l02,/oracle/XDB1/
> > >> > l02)
>
> > >> Only if your target database is a standby, not in general. You will
> > >> have to write a whole lot of "SET NEWNAME" statements in your rman
> > >> script. Get acquainted with pathologically eclectic rubbish lister.
>
> > >> --http://www.mladen-gogala.com
>
> > > Not my experience, when using the duplicate database command in RMAN.
> > > Using duplicate database aforementioned parameters are observed both
> > > for standby and ordinary databases.
>
> > I tried it last time with Oracle 9.2, without much success.
>
> > --http://www.mladen-gogala.com
>
> I've cloning databases using the above parameters with STandby's on
> AIX, cloning Production DB's to Test on AIX and Solaris, they work.
> Below is part of my RMAN cloning script to a non-standby db(but it can
> be easily changed for standby's):
>
> connect catalog rcat/XXXXXX_at_CATALOGDB1;
> connect target sys/XXXXXXX_at_PRODDB1;
> connect auxiliary sys/XXXXX_at_TESTDB1;
>
> run {
> allocate auxiliary channel t1 type 'SBT_TAPE';
> duplicate target database to TESTDB1
> nofilenamecheck;
>
> }
>
> An important part of getting it to work is the "nofilenamecheck", no
> "SETNAME's" required...........
>
> Pete's

Forgot to mention versions, if I recall correctly the above worked on 9iR1, 9iR2, 10gR1, 10gR2.

Pete's Received on Tue Feb 20 2007 - 13:43:48 CST