又一个nbu备份oracle奇怪的问题
备份文件没问题, 通过rman备份也没问题, 通过rman scripts备份出错.这可能是什么原因?###通过rman备份也没问题
RMAN> RUN
2> {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=a110089, NB_ORA_SERV=a110088';
BACKUPDATABASE;
3> 4> 5> 6> sql 'alter system archive log current';
RELEASE CHANNEL ch00;
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
7> 8> 9> SEND 'NB_ORA_CLIENT=a110089, NB_ORA_SERV=a110088';
BACKUP ARCHIVELOG ALL ;
10> 11> RELEASE CHANNEL ch00;
}12>
allocated channel: ch00
channel ch00: sid=144 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.1 (2011020322)
sent command to channel: ch00
Starting backup at 17-AUG-11
channel ch00: starting full datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00001 name=/oradata/bench/system01.dbf
input datafile fno=00004 name=/oradata/bench/users01.dbf
input datafile fno=00003 name=/oradata/bench/sysaux01.dbf
input datafile fno=00002 name=/oradata/bench/undotbs01.dbf
channel ch00: starting piece 1 at 17-AUG-11
channel ch00: finished piece 1 at 17-AUG-11
piece handle=0jmk81u9_1_1 tag=TAG20110817T173921 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:00:55
channel ch00: starting full datafile backupset
channel ch00: specifying datafile(s) in backupset
including current control file in backupset
channel ch00: starting piece 1 at 17-AUG-11
channel ch00: finished piece 1 at 17-AUG-11
piece handle=0kmk8200_1_1 tag=TAG20110817T173921 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:00:25
Finished backup at 17-AUG-11
sql statement: alter system archive log current
released channel: ch00
allocated channel: ch00
channel ch00: sid=144 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.1 (2011020322)
sent command to channel: ch00
Starting backup at 17-AUG-11
current log archived
channel ch00: starting archive log backupset
channel ch00: specifying archive log(s) in backup set
input archive log thread=1 sequence=23 recid=1 stamp=759424718
input archive log thread=1 sequence=24 recid=2 stamp=759424720
input archive log thread=1 sequence=25 recid=3 stamp=759432732
input archive log thread=1 sequence=26 recid=4 stamp=759432732
input archive log thread=1 sequence=27 recid=5 stamp=759433242
input archive log thread=1 sequence=28 recid=6 stamp=759433243
channel ch00: starting piece 1 at 17-AUG-11
channel ch00: finished piece 1 at 17-AUG-11
piece handle=0lmk820r_1_1 tag=TAG20110817T174043 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:00:26
Finished backup at 17-AUG-11
released channel: ch00
通过rman scripts备份出错
Recovery Manager: Release 10.2.0.4.0 - Production on Thu Aug 18 09:50:27 2011
Copyright (c) 1982, 2007, Oracle.All rights reserved.
connected to target database: BENCH (DBID=1977221881)
using target database control file instead of recovery catalog
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28>
allocated channel: ch00
channel ch00: sid=138 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.1 (2011020322)
sent command to channel: ch00
allocated channel: ch01
channel ch01: sid=143 devtype=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 7.1 (2011020322)
sent command to channel: ch01
Starting backup at 18-AUG-11
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00001 name=/oradata/bench/system01.dbf
input datafile fno=00002 name=/oradata/bench/undotbs01.dbf
channel ch00: starting piece 1 at 18-AUG-11
channel ch01: starting incremental level 0 datafile backupset
channel ch01: specifying datafile(s) in backupset
input datafile fno=00004 name=/oradata/bench/users01.dbf
input datafile fno=00003 name=/oradata/bench/sysaux01.dbf
channel ch01: starting piece 1 at 18-AUG-11
RMAN-03009: failure of backup command on ch00 channel at 08/18/2011 09:50:31
ORA-19506: failed to create sequential file, name="bk_30_1_759491430", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
VxBSAValidateFeatureId: Failed with error:
Server Status:cannot connect on socket
channel ch00 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 ch01 channel at 08/18/2011 09:50:31
ORA-19506: failed to create sequential file, name="bk_31_1_759491430", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
VxBSAValidateFeatureId: Failed with error:
Server Status:cannot connect on socket 曾经更换过client对应的 nbu master, 结果出来同样的错误信息. 端口？:roll: 试试重启netbackup服务 回复 4# fenqtek
试过了， 不管用。 如果是服务出问题，为啥备普通文件没问题，通过rman 备份也没问题呢？ rman 能运行说明已经link了。脚本不能运行，肯定是脚本没有改好。 需要查看bpcd、dbclient和 bphdb日志 重点看ORA-19506啊，google一下吧，不好办，貌似以前碰到过，忘了 回复 8# wolfheader
十分感谢! :em03: 回复 1# wangyl1977
试试在send 中加入NB_ORA_SID=
页:
[1]
2