Forum Discussion

Aasif75's avatar
Aasif75
Level 3
13 years ago

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

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

7.1.x and Earlier
Backup and Recovery
NetBackup
Oracle
Troubleshooting
Windows

13 Replies

Sort By
  • Will_Restore's avatar
    Will_Restore
    Level 6
    13 years ago
    I believe
     
    TARGETDB_LOGIN=SYS as sysdba
     
    should be simply
     
    TARGETDB_LOGIN=SYS

     

  • Nicolai's avatar
    Nicolai
    Moderator
    13 years ago

    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's avatar
    Will_Restore
    Level 6
    13 years ago

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

     

    TARGETDB_TNSNAME=oracle
     
    CATALOG_TNSNAME=oracle

     

  • Marianne's avatar
    Marianne
    Level 6
    13 years ago

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

  • Aasif75's avatar
    Aasif75
    Level 3
    13 years ago

    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's avatar
    Marianne
    Level 6
    13 years ago

    Are you trying to do offhost, snapshot backups?

    If not, remove the PROXY statement.

     

  • Yasuhisa_Ishika's avatar
    Yasuhisa_Ishika
    Level 6
    13 years ago
    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's avatar
    Aasif75
    Level 3
    13 years ago

    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

  • Aasif75's avatar
    Aasif75
    Level 3
    13 years ago

     

    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;
}