Rman - bphdb exit status = 29: failed trying to ex...

Aasif75 · ‎09-20-2012

Hello,

i have a problem with Oracle Rman (Oracle 11G R2) backup with Netbackup 7.1.0.3.

I created a template with the wizard (Backup , archive, restore) on the client.

When i launch a Manual Backup from my master server i have this :

20/09/2012 17:13:38 - Info nbjm(pid=9652) started backup job for client ora11g-rman.*****.com, policy Oracle, schedule SCH_FULL on storage unit ******

20/09/2012 17:13:41 - started process bpbrm (4948)

20/09/2012 17:13:54 - Info bpbrm(pid=4948) ora11g-rman.*****.com is the host to backup data from

20/09/2012 17:13:54 - Info bpbrm(pid=4948) reading file list from client

20/09/2012 17:13:54 - connecting

20/09/2012 17:13:57 - connected; connect time: 00:00:03

20/09/2012 17:13:58 - Info bpbrm(pid=4948) starting bphdb on client

20/09/2012 17:13:59 - Info bphdb(pid=1580) Backup started

20/09/2012 17:13:59 - Info bphdb(pid=1580) Database validation buffer = :DBNAME:ORACLE:DBHOME:d:\oracle\product\11.2.0\dbhome_1:DBNETNAME:oracle

20/09/2012 17:13:59 - Info bphdb(pid=1580) DBNAME=ORACLE DBHOME=d:\oracle\product\11.2.0\dbhome_1 DBNETNAME=oracle DBTEMPLATENAME=fullbackuptest1.tpl

20/09/2012 17:15:34 - Error bpbrm(pid=4948) from client ora11g-rman.*****.com: ERR - failed executing command <"C:\Program Files\Veritas\NetBackup\bin\bpdbsbora.exe" -backup -rw -t "fullbackuptest1.tpl">

20/09/2012 17:15:34 - Error bpbrm(pid=4948) from client ora11g-rman.*****.com: ERR - exit status: <1>

20/09/2012 17:15:34 - Error bpbrm(pid=4948) from client ora11g-rman.*****.com: ERR - bphdb exit status = 29: failed trying to exec a command

20/09/2012 17:15:36 - end writing

failed trying to exec a command(29)

This is my script fullbackuptest1.tpl :

#^oracle template configuration file <<MUST BE FIRST IN FILE, DO NOT REMOVE>>

# -----------------------------------------------------------------

# Veritas NetBackup for oracle: Backup Configuration Template

# $VRTScprght: Copyright 1993 - 2011 Symantec Corporation, All Rights Reserved $

#

# Description: test

# Template level: 1.9.0

# Generated on: 09/19/12 15:29:07

# -----------------------------------------------------------------

TEMPLATE_ID1=16973

TEMPLATE_ID2=1605

TEMPLATE_OWNER=aasif

# -----------------------------------------------------------------

# BACKUP_TYPE is derived from the schedule type when this script

# is used in a NetBackup scheduled backup. For example, when:

# schedule type is BACKUP_TYPE is

# ---------------- --------------

# Automatic Full INCREMENTAL LEVEL=0

# Automatic Differential Incremental INCREMENTAL LEVEL=1

# Automatic Cumulative Incremental INCREMENTAL LEVEL=1 CUMULATIVE

#

# For a non-proxy user initiated backup, BACKUP_TYPE is defined as shown.

# -----------------------------------------------------------------

BACKUP_TYPE=INCREMENTAL LEVEL=0

ORACLE_HOME=d:\oracle\product\11.2.0\dbhome_1

ORACLE_SID=ORACLE

TARGETDB_LOGIN=SYS as sysdba

TARGETDB_PASSWD=000a333eb56d86*****************64cadc37449028c9f61234a28b91592ab35b42155e3e40a********ed3366874ab

TARGETDB_TNSNAME=oracle

CATALOG_LOGIN=rman

CATALOG_PASSWD=3d151364860bd4d8dfe741035b33****************2e48969a32ce1f1e142e11176fec5*********09e82d09159

CATALOG_TNSNAME=oracle

# -----------------------------------------------------------------

# RMAN command section

# -----------------------------------------------------------------

RUN {

ALLOCATE CHANNEL ch00

TYPE 'SBT_TAPE';

SEND 'NB_ORA_CLIENT=ora11g-rman.*****.com,NB_ORA_SID=ORACLE,NB_ORA_POLICY=Oracle,NB_ORA_SERV=mymasterserver.*****.com,NB_ORA_SCHED=Oracle';

BACKUP

INCREMENTAL LEVEL=0

FORMAT 'BACKUP_%T-%s-%U'

DATABASE;

RELEASE CHANNEL ch00;

}

My bphdb log is attached on this topic

Please can you help me?

Thank you

Will_Restore · ‎09-20-2012

I believe

TARGETDB_LOGIN=SYS as sysdba

should be simply

TARGETDB_LOGIN=SYS

Nicolai · ‎09-20-2012

Please see this tech note:

Status Code 29 (failed trying to exec a command) when run from the master server, but attempts to run the backup with the template from the Oracle client are successful.

http://www.symantec.com/docs/TECH51372

Will_Restore · ‎09-20-2012

also, seems to me these should be unique, not both 'oracle'

TARGETDB_TNSNAME=oracle

CATALOG_TNSNAME=oracle

Marianne · ‎09-20-2012

Have you changed NBU Client Service on the Oracle server to run as user with full Oracle admin rights?

Handy NetBackup Links

Aasif75 · ‎09-21-2012

Hello,

I corrected my script with TARGETDB_LOGIN=SYS but i have the same error.

Regarding the TARGETDB_TNSNAME and the CATALOG_TNSNAME, it's the same TNS name because my catalog and my oracle server, are the same.

This tech note http://www.symantec.com/docs/TECH51372 can not be applied to my issue because i didn't give the full path but only the script name fullbackuptest1.tpl .

And How can i give the user with full Oracle admin rights on the service? I already have this, is it correct? ( i attached the screenshot)

And when i launch a backup on the client side with backup archive restore program, i have this error :

SPFILE cannot be backed up by proxy.

INF - channel ch00: starting full proxy datafile backup at 21/09/12

INF - released channel: ch00

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

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

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

INF - RMAN-03009: failure of backup command on ch00 channel at 09/21/2012 10:38:38

INF - ORA-27196: skgfpbk : sbtpcbackup a renvoyé une erreur

INF - ORA-19511: Erreur reçue de la couche de gestionnaire de supports, texte du message d'erreur :

INF - VxBSACreateObject: Failed with error:

INF - The transaction was aborted.

INF - Recovery Manager complete.

INF - End of Recovery Manager output.

INF - End Oracle Recovery Manager.

Thank you

Marianne · ‎09-21-2012

Are you trying to do offhost, snapshot backups?

If not, remove the PROXY statement.

Handy NetBackup Links

Yasuhisa_Ishika · ‎09-21-2012

Configure template without recovery catalog, and test it to confirm if the agent works in simple configuration. BTW, how will you recover your DB in disaster. Recovery catalog must work when you recover you DB. So you should not use target database as recovery catalog DB.

Aasif75 · ‎09-21-2012

I don't think so..

I can't remove proxy statement, it's added automatically when i launch a backup on the client side.

This is my backup script in the attachment, i don't have "proxy" statement.

I launched it, and i got this :

Thank you

Marianne · ‎09-21-2012

PROXY is still there. See under the 1st BACKUP statement.

Handy NetBackup Links

Aasif75 · ‎09-21-2012

Yes it's added automatically when i launch the backup

but in my run i don't have PROXY statement

RUN {
ALLOCATE CHANNEL ch00 
    TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=ora11g-rman.******.com,NB_ORA_SID=ORACLE,NB_ORA_POLICY=Oracle,NB_ORA_SERV=mymasterserver.localdomain.com,NB_ORA_SCHED=SCH_FULL';
BACKUP
    INCREMENTAL LEVEL=0
    FORMAT 'BACKUP_%T-%s-%U'
    DATABASE;
RELEASE CHANNEL ch00;
}

Marianne · ‎09-21-2012

I cannot say if this a bug or not... I have nowhere to test/check. Maybe a little check-box that is selected?

Why not customize one of the sample rman scripts on the Oracle server?

Handy NetBackup Links

Aasif75 · ‎09-21-2012

Yes i know that, but this is only for test.. it's not in production state

GADID · ‎12-12-2012

I'm Getting this error same and not able to find answers

VOX

Rman - bphdb exit status = 29: failed trying to exec a command