RMAN - Duplicate Database with Veritas to new server

Some of you may recall this subject in a thread earlier this year:

http://www.freelists.org/archives/oracle-l/05-2007/msg00324.html

Well, it's back, and this time with a solution.

It seems I've spent a lot of time lately chasing down NetBackup idiosyncrasies.

This is NetBackup 5.1 MP5 on Windows 2003.

If interested, read the referenced thread, it isn't very long.

Here's the solution.

This does NOT work:

RUN
{

allocate auxiliary channel C1 device type 'sbt' parms="ENV=(NB_ORA_POLICY=ORA_client,NB_ORA_SCHED=OracleBackup,NB_ORA_CLIENT=client,NB_ORA_SERV=nbu)";

allocate auxiliary channel C2 device type 'sbt' parms="ENV=(NB_ORA_POLICY=ORA_client,NB_ORA_SCHED=OracleBackup,NB_ORA_CLIENT=client,NB_ORA_SERV=nbu)";

set until time "to_date('08/07/2007 06:08:00','mm/dd/yyyy hh24:mi:ss')";

DUPLICATE TARGET DATABASE TO ORCL; }

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 08/07/2007 13:41:22

RMAN-03015: error occurred in stored script Memory Script

ORA-19507: failed to retrieve sequential file, handle="APP_T20070806_db_s1075_p1_t629896012", parms=""

ORA-27029: skgfrtrv: sbtrestore returned error

ORA-19511: Error received from media manager layer, error text:

   Backup file <APP_T20070806_db_s1075_p1_t629896012> not found in NetBackup catalog

RMAN> **end-of-file**

This however, DOES work:

RUN
{

allocate auxiliary channel C1 device type 'sbt';

allocate auxiliary channel C2 device type 'sbt';

send
"NB_ORA_POLICY=ORA_client,NB_ORA_SCHED=OracleBackup,NB_ORA_CLIENT=client,NB_ORA_SERV=nbu";

set until time "to_date('08/07/2007 06:08:00','mm/dd/yyyy hh24:mi:ss')";

DUPLICATE TARGET DATABASE TO ORCL; }

Setting up the parameters with the ALLOCATE CHANNEL command does not work with DUPLICATE
DATABASE and NetBackup.

Using the SEND command to set the parameters does work.

This is a problem that has been reported in the past on MetaLink, and I thought Veritas had it fixed, as
it does work now for making backups and with automatic channels.

Apparently this missed a spot.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l