Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

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

Created: 20 Sep 2012 • Updated: 20 Sep 2012 | 13 comments

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

Comments 13 CommentsJump to latest comment

Will Restore's picture
I believe
 
TARGETDB_LOGIN=SYS as sysdba
 
should be simply
 
TARGETDB_LOGIN=SYS

Will Restore -- where there is a Will there is a way

Nicolai's picture

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

Assumption is the mother of all mess ups.

If this post answered your'e qustion -  Please mark as a soloution.

Will Restore's picture

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

TARGETDB_TNSNAME=oracle
 
CATALOG_TNSNAME=oracle

Will Restore -- where there is a Will there is a way

Marianne's picture

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

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

Aasif75's picture

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

dba_user.PNG
AttachmentSize
clientbackup.txt 2.97 KB
Marianne's picture

Are you trying to do offhost, snapshot backups?

If not, remove the PROXY statement.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

Yasuhisa Ishikawa's picture

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.

Authorized Symantec Consultant(ASC) Data Protection in Tokyo, Japan

Aasif75's picture

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

Aasif75's picture

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

AttachmentSize
fullbackuptest1.txt 2.05 KB
Marianne's picture

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

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

Aasif75's picture

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's picture

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?

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

GADID's picture

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