Earlier this year I was asking about Duplicate Database problems with NetBackup and Oracle.
Here's the thread from the Oracle-L list. I think I asked on this list as well.
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 they missed a spot.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
| 