Backup job terminate and end with status 25

kat1234 · ‎08-05-2013

Dear all,

My oracle rman backup job always terminate at the middle with status 25. I get output like:

==== started on Thu 08/01/2013 09:53 ====

Script name: "C:\Program Files\Veritas\NetBackup\DbExt\Oracle\hot_database_backup.cmd"

#

RMAN : C:\oracle\product\11.2.0\dbhome_1\bin\rman.exe

NLS_LANG : american

ORACLE_HOME : C:\oracle\product\11.2.0\dbhome_1

ORACLE_SID : abcd

NLS_DATE_FORMAT : YYYY-MM-DD:hh24:mi:ss

RMAN_LOG_FILE : "C:\Program Files\Veritas\NetBackup\DbExt\Oracle\hot_database_backup.out"

NB_ORA_SERV : hosta

NB_ORA_FULL : 0

NB_ORA_INCR : 1

NB_ORA_CINC : 0

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Aug 1 21:53:28 2013

connected to target database: IBSDSDIR (DBID=1287629914)

using target database control file instead of recovery catalog

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26>

allocated channel: ch00

channel ch00: SID=336 device type=SBT_TAPE

channel ch00: Veritas NetBackup for Oracle - Release 7.5 (20130209)

sent command to channel: ch00

Starting backup at 2013-08-01:21:53:29

channel ch00: starting incremental level 1 datafile backup set

channel ch00: specifying datafile(s) in backup set

input datafile file number=00008 name=M:\ORADATA\ABC\ABCTXHIS.DBF

input datafile file number=00005 name=M:\ORADATA\ABC\ABC.DBF

input datafile file number=00006 name=M:\ORADATA\ABC\ABCIDX.DBF

input datafile file number=00003 name=M:\ORADATA\ABC\UNDOTBS01.DBF

input datafile file number=00004 name=M:\ORADATA\ABC\USERS01.DBF

channel ch00: starting piece 1 at 2013-08-01:21:53:30

released channel: ch00

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

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

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

RMAN-03009: failure of backup command on ch00 channel at 08/01/2013 22:23:45

ORA-19506: failed to create sequential file, name="bk_u6hog81qq_s209_p1_t822347610", parms=""

ORA-27028: skgfqcre: sbtbackup returned error

ORA-19511: Error received from media manager layer, error text:

VxBSACreateObject: Failed with error:

Server Status: Communication with the server has not been initiated or the server status has not been retrieved from the serve

RMAN>

Recovery Manager complete.

#

The failure only happen for my scheduled daily backup, it is always successful if it runs manually. I already set 99 as maximium jobs for each client and CLIENT_WAIT and CLIENT_READ = 7200. Would anyone give me some suggestions what's the problem. Thanks.

Vickie · ‎08-05-2013

Hi Kat,



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

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

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

RMAN-03009: failure of backup command on ch00 channel at 08/01/2013 22:23:45

ORA-19506: failed to create sequential file, name="bk_u6hog81qq_s209_p1_t822347610", parms=""

ORA-27028: skgfqcre: sbtbackup returned error

ORA-19511: Error received from media manager layer, error text:

   VxBSACreateObject: Failed with error:

   Server Status:  Communication with the server has not been initiated or the server status has not been retrieved from the serve

This error shows,

Communication with the master server isn't working.

Or Bp.conf, inetd.conf entries, services files, or Media server services may be at fault. Check these configuration files.

The client or media server (if it's an SSO machine) is mis-configured somehow. Check connectivity with Media server as well.

This error applies to the local machine, and doesn't generally refer to mis-configurations in the infrastructure machines (especially when these machines have existed for some time without issues).

Also share the output of below commands,

ping <server name>

telnet <server name> bpcd

bptestbpcd -client <server name>

bpclntcmd -pn (from client)

Or you need to check the Parameters in RMAN script which is used for backup. Check if these parameters are mentioned corretly.

Like

'NB_ORA_CLIENT=

NB_ORA_POLICY=

NB_ORA_SERV=

NB_ORA_SCHED=

Thanks,

Vickie

kat1234 · ‎08-06-2013

Hi,

The connection is OK for both server and command return correct output. I use SEND "NB_ORA_CLIENT=abc, NB_ORA_POLICY=abc_oracle" in my script. Actually i wonder the problem due to connection between media server and client. As it can backup manually and it can complete the backup of backsets at beginning. My script backup (1) database, (2) controller file and (3) archivelog. I found in some cases, the backup job terminiate at backing archivelog and sometime at controller file. The OS of Oracle server can be backup successully everytime, but the oracle backup always get error. Would give me some hints for this strange behaviour. Thanks.

Marianne · ‎08-07-2013

You will need to trace comms from beginning to end:

client <-> master
client <-> media server

The following logs are needed:

On master: bprd (if log folder soes not exist, create it and restart NBU)
On media server: bptm and bpbrm (no need to restart)
On client: bpcd and dbclient (remember to chmod 777 dbclient after creating folder)

Handy NetBackup Links

VOX

Backup job terminate and end with status 25