NBU备份出现19511错误

由于前一段时间带库出现硬件异常，在调整测试过程中，对NBU中一些设置进行了更改，导致一台数据库无法正常备份。

使用RMAN备份报错如下：

RMAN> run
{R?vgd^!Q02> {
4P;v+K9Q|.j9l tl03> allocate channel c1 device type sbt;ITPUB个人空间&c~T0m_9}-ch*_
4> backup current controlfile;
A.f"l{%Q#Up:w~n(q05> }

allocated channel: c1ITPUB个人空间$V"j$~/Of
channel c1: sid=145 devtype=SBT_TAPE
U(}z8_y,G!E.j0channel c1: VERITAS NetBackup for Oracle - Release 5.1 (2004043016)

Starting backup at 31-3月-08ITPUB个人空间'}*b)k&M,i;xwcg
channel c1: starting full datafile backupsetITPUB个人空间I{
TF.wa
channel c1: specifying datafile(s) in backupsetITPUB个人空间c&_"wyZSF
including current controlfile in backupset
E"}7ke9K'B0channel c1: starting piece 1 at 31-3月-08
W5m*}k
wf'o A0released channel: c1
{"d_U^y)IV;_G5Y)E0RMAN-00571: ===========================================================

Ty Qdk4S/c/`8\2R0RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
A+F-]Qd0RMAN-00571: ===========================================================ITPUB个人空间j;kZs9s&g3y+o2X
RMAN-03009: failure of backup command on c1 channel at 03/31/2008 13:58:54ITPUB个人空间O]J7Y
`be
ORA-19506: failed to create sequential file, name="55jcl9ks_1_1", parms=""ITPUB个人空间@O*]Dg#zO"\{a(w
ORA-27028: skgfqcre: sbtbackup returned error
z#v5ZFnbg }v0ORA-19511: Error received from media manager layer, error text:ITPUB个人空间u2PRz3bM Y Me
   Failed to process backup file <55jcl9ks_1_1>

通过METALINK和GOOGLE都未找到关于这个错误的详细描述。其中METALINK有一篇关于ORA-19511错误的汇总，但是并没有包括当前情况的描述。

目前比较奇怪的是，备份报错后，并没有在NETBACKUP的服务器端的日志中看到这个客户端任何的备份信息。

根据这个现象，怀疑备份命令没有发送到服务器端。

对比当前失败的NETBACKUP客户端和另一个可以成功备份的客户端，发现当前客户端中的bp.conf配置存在问题：

bash-2.03$ more bp.confITPUB个人空间c"Eeel]jKH
SERVER = backupcenter240
"^Ph IGxbc0SERVER = bjdb01ITPUB个人空间5P0G+f;P'b7M8tP o+`6J
SERVER = fjdb
V1[B2c ?&}8N0SERVER = bjdb03
2Q{*}7l[0CLIENT_NAME = bjdb03
2A
~
c&j;v@$g0o(~0CLIENT_NAME = data03

配置文件中包含了多个SERVER信息，应该是这个问题导致备份命令没有发送到服务器端，修改bp.conf配置文件：

SERVER = backupcenter240
M!]kVGQ0dV.RZ!f0MEDIA_SERVER = bjdb03ITPUB个人空间8_ BQVO
CLIENT_NAME = bjdb03

然后重新执行备份：

bash-2.03$ rman target /

Recovery Manager: Release 9.2.0.4.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: DATA01 (DBID=1984618042)

RMAN> run     
a`HhE$tjgq02> {
&\Y{x-R.P~03> allocate channel c1 device type sbt;
uPqhP7b(l04> backup current controlfile;ITPUB个人空间-N6TAQ
q*F
5> }

using target database controlfile instead of recovery catalog
{\#T'ahz;Wv0allocated channel: c1
1|[R-h.C-t\ X5zXu0}0channel c1: sid=173 devtype=SBT_TAPE
c*@2X.j J3F0channel c1: VERITAS NetBackup for Oracle - Release 5.1 (2004043016)

Starting backup at 31-3月-08ITPUB个人空间"lI:RxVF7`h#N\`
channel c1: starting full datafile backupsetITPUB个人空间"Cmy#H(OC?(U
channel c1: specifying datafile(s) in backupsetITPUB个人空间rk.D5gxY
including current controlfile in backupsetITPUB个人空间WK8`@[qjN
channel c1: starting piece 1 at 31-3月-08

released channel: c1
4ZtV3fX:h-Z0RMAN-00571: ===========================================================
+we3Dc)Z{ z@m0RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
"q0G? N d^j0RMAN-00571: ===========================================================ITPUB个人空间"a`x!IF,`],|
RMAN-03009: failure of backup command on c1 channel at 03/31/2008 15:29:03
#WKof%y9^ F0ORA-19506: failed to create sequential file, name="57jcle1c_1_1", parms=""
6LMj e F6cHw;wM0ORA-27028: skgfqcre: sbtbackup returned error
Gl3UUS
Y,N0ORA-19511: Error received from media manager layer, error text:ITPUB个人空间 ESP%{Ed-[
   VxBSACreateObject: Failed with error:ITPUB个人空间bP {8V/~,p
   Server Status:  Communication with the server has not been iniatated or the server status has not been retrieved from the server.

虽然仍然报错，但是错误信息已经改变，而且从服务器端已经可以看到失败的错误信息了，问题已经解决了一部分了。

从服务器端的bpadm备份信息看，返回错误状态为45：

 45    bjdb03        bjdb03-ora       diff       backupcente 03/31/2008 15:48:36 (request attempted on a non reserved port)

详细的错误信息为：

03/31/2008 15:48:34 backupcenter240 bjdb03  bpcd on bjdb03 exited with status 45: request attempted on a non reserved port
-ml2p+iUP003/31/2008 15:48:35 backupcenter240 bjdb03  cannot send mail because BPCD on bjdb03 exited with status 45: request attempted on a non reserved port
Cu/r%BsbB d}003/31/2008 15:48:36 backupcenter240 bjdb03  suspending further backup attempts for client bjdb03, policy bjdb03-ora, schedule diff because it has exceeded the configured number of triesITPUB个人空间5uN4S4\c;]h)v
03/31/2008 15:48:36 backupcenter240 bjdb03  backup of client bjdb03 exited with status 45 (request attempted on a non reserved port)ITPUB个人空间8H`m?a4i'Q#B)z
03/31/2008 15:48:59 backupcenter240 -  Unable to write progress log </usr/openv/netbackup/logs/user_ops/dbext/logs/1281.0.1206949739> on client bjdb03. Policy=bjdb03-ora Sched=Default-Application-Backup

下面需要解决的问题就是备份端口问题，修改bp.conf参数如下：

SERVER = backupcenter240
DP!j7N9ig3J\0CLIENT_NAME = bjdb03
_Gm vz`0REQUIRED_INTERFACE = bjdb03

至此备份成功执行：

bash-2.03$ rman target /

Recovery Manager: Release 9.2.0.4.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: DATA01 (DBID=1984618042)

RMAN> run        
{g2x-\Mcl'lr@02> {ITPUB个人空间 jp?*G{B!kN,c%}[
3> allocate channel c1 device type sbt;ITPUB个人空间df&Lc8oJN2Vm
4> backup tablespace users;ITPUB个人空间s"a*Xc6yLH
5> }

using target database controlfile instead of recovery catalogITPUB个人空间z#R4_X:a.c*i"]
allocated channel: c1
I0s5OR*@*s ?:__(n0channel c1: sid=65 devtype=SBT_TAPEITPUB个人空间VU `u*dLx2^
channel c1: VERITAS NetBackup for Oracle - Release 5.1 (2004043016)

Starting backup at 31-3月-08
1v2H8V)D!W/ZO,Y,h0channel c1: starting full datafile backupset
0R2jp!Xl}
W;O0channel c1: specifying datafile(s) in backupsetITPUB个人空间4XL.bNV1CO;i
input datafile fno=00009 name=/data/oradata/data01/data01/users01.dbf
\
d@;@%\E@0channel c1: starting piece 1 at 31-3月-08ITPUB个人空间G~zdzF
channel c1: finished piece 1 at 31-3月-08ITPUB个人空间9XBk e|M
piece handle=5kjclnao_1_1 comment=API Version 2.0,MMS Version 5.0.0.0
:h!Bc!uJH%s5L0channel c1: backup set complete, elapsed time: 00:02:25
ld3v8F-n.Q'\Q0P0Finished backup at 31-3月-08

Starting Control File and SPFILE Autobackup at 31-3月-08
K)S8])d`%~ov w0piece handle=c-1984618042-20080331-02 comment=API Version 2.0,MMS Version 5.0.0.0
s{PI(x.B0Finished Control File and SPFILE Autobackup at 31-3月-08
7b$ofj NUl`Q0released channel: c1