nbu oracle 问题

Question

本帖最后由 zhangmq 于 2010-07-23 18:12 编辑

各位好，小弟在aix5.3上安装了nbu 6.5 server做备份服务器，在一部windows 2003 oracle10g server上安装了client。备份、恢复windows 2003的文件是正常的，备份oracle遇到些问题，报code 6。

以下是输出的报错，请帮忙分析，谢谢：
==== started on 2007-01-16 星期二  22:07 ====
Script name: "C:Program FilesVERITASNetBackupscripthot_database_backup.cmd"
#                                       
  RMAN  :  D:oracleproduct10.1.0Db_1binrman.exe                       
  NLS_LANG  :  american               
  ORACLE_HOME  :  D:oracleproduct10.1.0Db_1         
  ORACLE_SID  :  orcl           
  NLS_DATE_FORMAT  :  YYYY-MM-DD:hh24:mi:ss
  RMAN_LOG_FILE  :  "C:Program FilesVERITASNetBackupscripthot_database_backup.out"     
  NB_ORA_SERV  :  aix                     
  NB_ORA_FULL  :  1                     
  NB_ORA_INCR  :  0                     
  NB_ORA_CINC  :  0                     
  NB_ORA_CLASS  :  su182_oracle                  

Recovery Manager: Release 10.1.0.2.0 - Production

Copyright (c) 1995, 2004, Oracle.  All rights reserved.

connected to target database: ORCL (DBID=1240621131)
using target database controlfile instead of recovery catalog

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18>
allocated channel: ch00
channel ch00: sid=150 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 6.5 (20070723)

sent command to channel: ch00

Starting backup at 2007-01-16:22:07:15
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00001 name=D:ORACLEPRODUCT10.1.0ORADATAORCLSYSTEM01.DBF
input datafile fno=00003 name=D:ORACLEPRODUCT10.1.0ORADATAORCLSYSAUX01.DBF
input datafile fno=00005 name=D:ORACLEPRODUCT10.1.0ORADATAORCLEXAMPLE01.DBF
input datafile fno=00002 name=D:ORACLEPRODUCT10.1.0ORADATAORCLUNDOTBS01.DBF
input datafile fno=00004 name=D:ORACLEPRODUCT10.1.0ORADATAORCLUSERS01.DBF
channel ch00: starting piece 1 at 2007-01-16:22:07:15
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch00 channel at 01/16/2007 22:22:40
ORA-19506: failed to create sequential file, name="bk_u1ci7m9sj_s44_p1_t612050835", 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 serve

RMAN>

Recovery Manager complete.
#

Answer 1

链接库做好了么？
100心 发表于 2010-07-24 09:35

      什么链接库？

Answer 2

会不会是因为storage unit指定的是磁盘目录（basic disk），而备份脚本写的是'SBT_TAPE'
zhangmq 发表于 2010-07-24 10:09

    这个可以排除，肯定不会

Answer 3

会不会是因为storage unit指定的是磁盘目录（basic disk），而备份脚本写的是'SBT_TAPE'

Answer 4

RUN{
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
BACKUP
FORMAT 'cntrl_%s_%p_%t'
CURRENT CONTROLFILE;
...
赵大少爷 发表于 2010-07-23 20:02

    RMAN> RUN{
2> ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
3> BACKUP
4> FORMAT 'cntrl_%s_%p_%t'
5> CURRENT CONTROLFILE;
6> RELEASE CHANNEL ch00;
7> }

using target database controlfile instead of recovery catalog
allocated channel: ch00
channel ch00: sid=145 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 6.5 (20070723)

Starting backup at 17-1月 -07
channel ch00: starting full datafile backupset
channel ch00: specifying datafile(s) in backupset
including current controlfile in backupset
channel ch00: starting piece 1 at 17-1月 -07
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch00 channel at 01/17/2007 16:17:13
ORA-19506: failed to create sequential file, name="cntrl_71_1_612115308", 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 serve

RMAN>

Answer 5

链接库做好了么？

Answer 6

hosts两边解析都做了吗
赵大少爷 发表于 2010-07-23 20:06

   这个有做。

Answer 7

hosts两边解析都做了吗

Answer 8

RUN{
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
BACKUP
FORMAT 'cntrl_%s_%p_%t'
CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}

报错不

Answer 9

补充：
oracle本身应该没问题，直接在rman下执行backup current controlfile;backup full database;备份在windows 2003本地都正常。