Database Software

I believe this is an issue with the NetBackup configuration on the dev server or NBU parameters used in the RMAN run command. Can someone please review these steps and commands to help determine why this does not work?

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
On Linux Red Hat 2.6
Veritas NetBackup 6.5

(real names replaced with prodserver, devserver, and masterserver)

As a test I am trying to restore the production Oracle database instance (prod on prodserver.com) to the development database server (devserver.com). After restoring relevant prod directories and files onto the development server I restore the initprod.ora to $ORACLE_HOME/dbs. ORACLE_HOME and ORACLE_BASE are identical on both servers.

I update the ORACLE_SID on the dev server to prod and startup nomount prod on the dev server and create the spfile from the restored pfile from the prod server.

Shutdown prod on the dev server and start RMAN without the catalog, set the dbid to that of the prod database, startup force nomount, restore controlfile from autobackup.

% rman target /
RMAN> set dbid 134461749;
RMAN> startup force nomount;

RMAN> run {
2> allocate channel t1 device type sbt;
3> send 'NB_ORA_SERV=masterserver.com,
4> NB_ORA_POLICY=ORACLE_PROD,
5> NB_ORA_CLIENT=prodserver.com';
6> restore controlfile from autobackup;
7> }

using target database control file instead of recovery catalog
allocated channel: t1
channel t1: SID=152 device type=SBT_TAPE
channel t1: Veritas NetBackup for Oracle - Release 6.5 (2010011113)

sent command to channel: t1

Starting restore at 09-AUG-10

channel t1: looking for AUTOBACKUP on day: 20100809
channel t1: AUTOBACKUP found: c-134461749-20100809-02
channel t1: restoring control file from AUTOBACKUP c-134461749-20100809-02
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/09/2010 10:03:21
ORA-19870: error while restoring backup piece c-134461749-20100809-02
ORA-19507: failed to retrieve sequential file, handle="c-134461749-20100809-02", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Failed to process backup file <c-134461749-20100809-02>



Also tried to name the backup piece in the run command with similar results.

RMAN> run {
2> allocate channel t1 device type sbt;
3> send 'NB_ORA_SERV=masterserver.com,
4> NB_ORA_POLICY=ORACLE_PROD,
5> NB_ORA_CLIENT=prodserver.com';
6> restore controlfile from 'c-134461749-20100809-02';
7> }

And

RMAN> run {
2> allocate channel t1 device type sbt;
3> send 'NB_ORA_SERV=masterserver.com,
4> NB_ORA_POLICY=ORACLE_PROD,
5> NB_ORA_CLIENT=prodserver.com';
6> restore controlfile from '/c-134461749-20100809-02';
7> }

allocated channel: t1
channel t1: SID=152 device type=SBT_TAPE
channel t1: Veritas NetBackup for Oracle - Release 6.5 (2010011113)

sent command to channel: t1

Starting restore at 09-AUG-10

channel t1: restoring control file
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/09/2010 10:48:33
ORA-19870: error while restoring backup piece /c-134461749-20100809-02
ORA-19507: failed to retrieve sequential file, handle="/c-134461749-20100809-02", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Failed to process backup file </c-134461749-20100809-02>

The bp.conf on the dev server has the prod client and dev client both declared.

bp.conf =
SERVER = masterserver.com
SERVER = devserver.com
SERVER = prodserver.com
EMMSERVER = masterserver.com
CLIENT_NAME = devserver.com
CLIENT_NAME = prodserver.com