发表于: 2008.05.03 20:30
分类: ORACLE
出处: http://yangtingkun.itpub.net/post/468/461034
---------------------------------------------------------------
由于前一段时间带库出现硬件异常，在调整测试过程中，对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 </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
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
re: NBU备份出现19511错误 
