09-20-2012 08:51 AM
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 from20/09/2012 17:13:54 - Info bpbrm(pid=4948) reading file list from client20/09/2012 17:13:54 - connecting20/09/2012 17:13:57 - connected; connect time: 00:00:0320/09/2012 17:13:58 - Info bpbrm(pid=4948) starting bphdb on client20/09/2012 17:13:59 - Info bphdb(pid=1580) Backup started20/09/2012 17:13:59 - Info bphdb(pid=1580) Database validation buffer = :DBNAME:ORACLE:DBHOME:d:\oracle\product\11.2.0\dbhome_1:DBNETNAME:oracle20/09/2012 17:13:59 - Info bphdb(pid=1580) DBNAME=ORACLE DBHOME=d:\oracle\product\11.2.0\dbhome_1 DBNETNAME=oracle DBTEMPLATENAME=fullbackuptest1.tpl20/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 command20/09/2012 17:15:36 - end writingfailed trying to exec a command(29)
#^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=16973TEMPLATE_ID2=1605TEMPLATE_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=0ORACLE_HOME=d:\oracle\product\11.2.0\dbhome_1ORACLE_SID=ORACLETARGETDB_LOGIN=SYS as sysdbaTARGETDB_PASSWD=000a333eb56d86*****************64cadc37449028c9f61234a28b91592ab35b42155e3e40a********ed3366874abTARGETDB_TNSNAME=oracleCATALOG_LOGIN=rmanCATALOG_PASSWD=3d151364860bd4d8dfe741035b33****************2e48969a32ce1f1e142e11176fec5*********09e82d09159CATALOG_TNSNAME=oracle# -----------------------------------------------------------------# RMAN command section# -----------------------------------------------------------------RUN {ALLOCATE CHANNEL ch00TYPE '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';BACKUPINCREMENTAL LEVEL=0FORMAT 'BACKUP_%T-%s-%U'DATABASE;RELEASE CHANNEL ch00;}
Please can you help me?
Thank you
09-20-2012 09:16 AM
09-20-2012 09:18 AM
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
09-20-2012 09:22 AM
also, seems to me these should be unique, not both 'oracle'
09-20-2012 09:51 PM
Have you changed NBU Client Service on the Oracle server to run as user with full Oracle admin rights?
09-21-2012 01:50 AM
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/12INF - released channel: ch00INF - 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:38INF - ORA-27196: skgfpbk : sbtpcbackup a renvoyé une erreurINF - 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
09-21-2012 02:01 AM
Are you trying to do offhost, snapshot backups?
If not, remove the PROXY statement.
09-21-2012 02:14 AM
09-21-2012 02:17 AM
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
09-21-2012 02:52 AM
PROXY is still there. See under the 1st BACKUP statement.
09-21-2012 03:00 AM
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; }
09-21-2012 03:20 AM
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?
09-21-2012 05:00 AM
Yes i know that, but this is only for test.. it's not in production state
12-12-2012 05:08 AM
I'm Getting this error same and not able to find answers