由于前一段时间带库出现硬件异常,在调整测试过程中,对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/