Oracle Rman status 29

[Jefferson_Faria]

Hello,

I'm new to netbackup and having problem to create backup on my oracle using netbackup

I saw that this discussion has been finished with no solution

Refference: https://www-secure.symantec.com/connect/forums/oracle-rman-status-29

Below are some details of my enviroment and also the script/template created by the wizard;

All servers are windows 2008 R2 standard

Master Server Version 7.5.0.3
Client server version 7.5 ---- need to be updated to 7.5.0.3? how?
Media server Version 7.5.0.3

Template

^oracle template configuration file <>
# -----------------------------------------------------------------
# Veritas NetBackup for oracle: Backup Configuration Template
# $VRTScprght: Copyright 1993 - 2012 Symantec Corporation, All Rights Reserved $
#
# Template level: 1.9.0
# Generated on: 08/29/14 16:38:52
# -----------------------------------------------------------------

TEMPLATE_ID1=16790
TEMPLATE_ID2=1601
TEMPLATE_OWNER=disa.admin

# -----------------------------------------------------------------
# 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
PRE_AUTO_MOUNT=Y
ORACLE_HOME=d:\app\administrator\product\11.2.0\dbhome_2
ORACLE_SID=oracledb
TARGET_INIT_FILE=D:\app\Administrator\product\11.2.0\dbhome_2\database\SPFILEoracledb.ORA
TARGETDB_LOGIN=sys
TARGETDB_PASSWD=password
TARGETDB_TNSNAME=oracledb
POST_AUTO_OPEN=Y

# -----------------------------------------------------------------
# RMAN command section
# -----------------------------------------------------------------

RUN {
ALLOCATE CHANNEL ch00
TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=DISAWIN02,NB_ORA_SID=oracledb,NB_ORA_POLICY=TESTE_DISAWIN02,NB_ORA_SERV=DISAWIN10,NB_ORA_SCHED=FULL';
BACKUP
INCREMENTAL LEVEL=0
FORMAT 'bk_u%u_s%s_p%p_t%t'
TAG 'bk_2908'
DATABASE;

RELEASE CHANNEL ch00;

# Control file backup

ALLOCATE CHANNEL ch00
TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=DISAWIN02,NB_ORA_SID=MSAFDEV,NB_ORA_POLICY=TESTE_DISAWIN02,NB_ORA_SERV=DISAWIN10,NB_ORA_SCHED=FULL';
BACKUP
FORMAT 'ctrl_u%u_s%s_p%p_t%t'
CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}

[RamNagalla]

So you have oracle data base in windows client?

creating the Oracle script is compleatly the taks of oracle DBA..

by any chance did you check with them about the script..?

[Nicolai]

I really (REALLY) recommend the Oracle Intelligent Policies in netbackup 7.6 

No more scripting or templates.

[Jefferson_Faria]

Nagalla,

Yes the database is running on windows server client.

I used the wizard on netbackup to create the script, but not sure if this is script problem

below are log of the job from netbackup

"29: failed trying to exec a command"

9/12/2014 11:26:40 AM - connected; connect time: 00:00:02
9/12/2014 11:26:41 AM - Info bphdb(pid=18332) Backup started           
9/12/2014 11:26:41 AM - Info bphdb(pid=18332) Database validation buffer = :DBNAME:oracledb:DBHOME:d:\app\administrator\product\11.2.0\dbhome_2:DBNETNAME:sfwdev        
9/12/2014 11:26:41 AM - Info bphdb(pid=18332) DBNAME=oracledb DBHOME=d:\app\administrator\product\11.2.0\dbhome_2 DBNETNAME=oracle DBTEMPLATENAME=oracledb_0909.tpl         
9/12/2014 11:27:54 AM - Error bpbrm(pid=2000) from client CLIENTSERVER.local: ERR - failed executing command <"D:\Veritas\NetBackup\bin\bpdbsbora.exe" -backup -rw -t "SFWDEV_0909.tpl" -jobid 17735>
9/12/2014 11:27:54 AM - Error bpbrm(pid=2000) from client CLIENTSERVER.local: ERR - exit status: <1>     
9/12/2014 11:27:54 AM - Error bpbrm(pid=2000) from client CLIENTSERVER.local: ERR - bphdb exit status = 29: failed trying to exec a command
9/12/2014 11:27:57 AM - end writing
failed trying to exec a command(29)

Appreciate...

[RamNagalla · Accepted solution]

just a guess..

try running the netbackup client services  & netbackup legecy services with oracle user id  and see how it works.

you can set the user id from services.msc --> netabckup client services --> propoerties --> log on 

[Michael_G_Ander]

the dbclient & bphdb logs usually have an indication of what the problem is

[jim_dalton]

I second Nicolai's suggestion. Life just becomes so much easier when you do move to OIP.

Jim

[Jefferson_Faria]

Hello guys sorry for dont reply for to long but, I have been of work for couple days due to some health problem..

Regarding Nagalla sugetions, we are running oracle with local acounts, (sys, system) and others, so due to that not sure if it will work. In order to that should I use oracle with AD authentication right?

[Marianne]

See  NetBackup for Oracle Administrator's Guide  

Logon account requirements can be found under this topic:

Configuring the logon account for the NetBackup
Client Service for NetBackup for Oracle