NBU备份出现19511错误

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

 

 

使用RMAN备份报错如下：

RMAN> run
2> {
3> allocate channel c1 device type sbt;
4> backup current controlfile;
5> }

allocated channel: c1
channel c1: sid=145 devtype=SBT_TAPE
channel c1: VERITAS NetBackup for Oracle - Release 5.1 (2004043016)

Starting backup at 31-3月 -08
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
including current controlfile in backupset
channel c1: starting piece 1 at 31-3月 -08
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c1 channel at 03/31/2008 13:58:54
ORA-19506: failed to create sequential file, name="55jcl9ks_1_1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   Failed to process backup file <55jcl9ks_1_1>

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

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

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

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

bash-2.03$ more bp.conf
SERVER = backupcenter240
SERVER = bjdb01
SERVER = fjdb
SERVER = bjdb03
CLIENT_NAME = bjdb03
CLIENT_NAME = data03

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

SERVER = backupcenter240
MEDIA_SERVER = bjdb03
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     
2> {
3> allocate channel c1 device type sbt;
4> backup current controlfile;
5> }

using target database controlfile instead of recovery catalog
allocated channel: c1
channel c1: sid=173 devtype=SBT_TAPE
channel c1: VERITAS NetBackup for Oracle - Release 5.1 (2004043016)

Starting backup at 31-3月 -08
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
including current controlfile in backupset
channel c1: starting piece 1 at 31-3月 -08

released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c1 channel at 03/31/2008 15:29:03
ORA-19506: failed to create sequential file, name="57jcle1c_1_1", 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 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
03/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
03/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 tries
03/31/2008 15:48:36 backupcenter240 bjdb03  backup of client bjdb03 exited with status 45 (request attempted on a non reserved port)
03/31/2008 15:48:59 backupcenter240 -  Unable to write progress log on client bjdb03. Policy=bjdb03-ora Sched=Default-Application-Backup

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

SERVER = backupcenter240
CLIENT_NAME = bjdb03
REQUIRED_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        
2> {
3> allocate channel c1 device type sbt;
4> backup tablespace users;
5> }

using target database controlfile instead of recovery catalog
allocated channel: c1
channel c1: sid=65 devtype=SBT_TAPE
channel c1: VERITAS NetBackup for Oracle - Release 5.1 (2004043016)

Starting backup at 31-3月 -08
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00009 name=/data/oradata/data01/data01/users01.dbf
channel c1: starting piece 1 at 31-3月 -08
channel c1: finished piece 1 at 31-3月 -08
piece handle=5kjclnao_1_1 comment=API Version 2.0,MMS Version 5.0.0.0
channel c1: backup set complete, elapsed time: 00:02:25
Finished backup at 31-3月 -08

Starting Control File and SPFILE Autobackup at 31-3月 -08
piece handle=c-1984618042-20080331-02 comment=API Version 2.0,MMS Version 5.0.0.0
Finished Control File and SPFILE Autobackup at 31-3月 -08
released channel: c1

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/4227/viewspace-258729/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/4227/viewspace-258729/