多网卡环境备份ORACLE故障解决一则

环境

1.AIX HACMP ORACLE RAC

2.WINDOW2003 MASTER SERVER

3.NBU6.5

 

故障

1.文件能够正常备份

2.ORACLE备份失败，OUT输出如下

 

Starting backup at 04-MAR-10
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00005 name=/oradata/zjrs/HCIS4J01.dbf
input datafile fno=00004 name=/oradata/zjrs/users01.dbf
input datafile fno=00003 name=/oradata/zjrs/sysaux01.dbf
channel ch00: starting piece 1 at 04-MAR-10
channel ch01: starting incremental level 0 datafile backupset
channel ch01: specifying datafile(s) in backupset
input datafile fno=00002 name=/oradata/zjrs/undotbs01.dbf
input datafile fno=00001 name=/oradata/zjrs/system01.dbf
channel ch01: starting piece 1 at 04-MAR-10
RMAN-03009: failure of backup command on ch01 channel at 03/04/2010 20:42:55
ORA-19506: failed to create sequential file, name="bk_2038_1_712788160", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   VxBSAValidateFeatureId: Failed with error:
   Server Status:  unexpected message received
channel ch01 disabled, job failed on it will be run on another channel
released channel: ch00
released channel: ch01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch00 channel at 03/04/2010 20:42:56
ORA-19506: failed to create sequential file, name="bk_2037_1_712788160", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   VxBSAValidateFeatureId: Failed with error:
   Server Status:  unexpected message received

RMAN> RMAN>

 

解决办法

在多网卡备份环境中，需要在BP.CONF中添加REQUIRED_INTERFACE参数，否则即使能够备份文件系统，但往往无法备份ORACLE

 
添加REQUIRED_INTERFACE = 10.150.229.2 
# more bp.conf
SERVER = zjbaksvr
CLIENT_NAME = zjrsdb_svc 
REQUIRED_INTERFACE = 10.150.229.2

 

发起备份，成功。