windows 2003下NBU6.5 备份windows oracle 10g失败，兄弟们帮忙看看

Question

贴上我的日志

==== started on 2010-07-20 星期二  18:22 ====
Script name: "C:Documents and SettingsAdministrator桌面123.cmd"
#                                       
  RMAN  :  D:oracleproduct10.2.0db_1binrman.exe                       
  NLS_LANG  :  american               
  ORACLE_HOME  :  D:oracleproduct10.2.0db_1         
  ORACLE_SID  :  soul           
  NLS_DATE_FORMAT  :  YYYY-MM-DD:hh24:mi:ss
  RMAN_LOG_FILE  :  "C:Documents and SettingsAdministrator桌面123.out"     
  NB_ORA_SERV  :  dell161                     
  NB_ORA_FULL  :  1                     
  NB_ORA_INCR  :  0                     
  NB_ORA_CINC  :  0                     
  NB_ORA_CLASS  :  oracle191                  

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jul 20 18:22:45 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: SOUL (DBID=404200679)
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>
allocated channel: ch00
channel ch00: sid=135 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 6.5 (20070723)

allocated channel: ch01
channel ch01: sid=146 devtype=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 6.5 (20070723)

Starting backup at 2010-07-20:18:22:47
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00001 name=D:ORACLEPRODUCT10.2.0ORADATASOULSYSTEM01.DBF
input datafile fno=00004 name=D:ORACLEPRODUCT10.2.0ORADATASOULUSERS01.DBF
channel ch00: starting piece 1 at 2010-07-20:18:22:47
channel ch01: starting incremental level 0 datafile backupset
channel ch01: specifying datafile(s) in backupset
input datafile fno=00003 name=D:ORACLEPRODUCT10.2.0ORADATASOULSYSAUX01.DBF
input datafile fno=00005 name=D:ORACLEPRODUCT10.2.0ORADATASOULEXAMPLE01.DBF
input datafile fno=00002 name=D:ORACLEPRODUCT10.2.0ORADATASOULUNDOTBS01.DBF
channel ch01: starting piece 1 at 2010-07-20:18:22:48
RMAN-03009: failure of backup command on ch00 channel at 07/20/2010 18:38:03
ORA-19506: failed to create sequential file, name="bk_u0alj9efn_s10_p1_t724875767", 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
channel ch00 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on ch01 channel at 07/20/2010 18:38:04
ORA-19506: failed to create sequential file, name="bk_u0blj9efn_s11_p1_t724875767", 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
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 07/20/2010 18:38:03
ORA-19506: failed to create sequential file, name="bk_u0alj9efn_s10_p1_t724875767", 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-03009: failure of backup command on ch01 channel at 07/20/2010 18:38:04
ORA-19506: failed to create sequential file, name="bk_u0blj9efn_s11_p1_t724875767", 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.
#   

谢谢给位，{:3_185:} 非常的抓狂

Answer 1

看起来像是介质层面的问题，做link没，重做下
脚本路径里面不要带中文，呵呵

Answer 2

用备份向导试了试，oracle可以备份了。神奇的是第一次备份成功了，吃完饭回来再备份一次，监视里面发现job根本没跑起来，是不是啥bug

重装nbu再跑可以，oracle可以备份，等几个小时再用向导跑还是不行

Answer 3

存储介质不可用？

测试下disk备份试试

Answer 4

回复 2# s5619132

    还是报一样的错

麻烦帮看看脚本有没有问题

@setlocal ENABLEEXTENSIONS

@echo off

@set RMAN_LOG_FILE="%~dpn0.out"

@if exist %RMAN_LOG_FILE% del %RMAN_LOG_FILE%

@set ORACLE_HOME=D:oracleproduct10.2.0db_1

@set ORACLE_SID=soul

@set TARGET_CONNECT_STR=sys/abc123

@set RMAN=%ORACLE_HOME%binrman.exe

@REM @set NB_ORA_PC_STREAMS=3

@for /F "tokens=1*" %%p in ('date /T') do @set DATE=%%p %%q
@for /F %%p in ('time /T') do @set DATE=%DATE% %%p

@echo ==== started on %DATE% ==== >> %RMAN_LOG_FILE%
@echo Script name: %0 >> %RMAN_LOG_FILE%

@set NLS_LANG=american
@set NLS_DATE_FORMAT=YYYY-MM-DD:hh24:mi:ss

@echo #                                       >> %RMAN_LOG_FILE%
@echo   RMAN  :  %RMAN%                       >> %RMAN_LOG_FILE%
@echo   NLS_LANG  :  %NLS_LANG%               >> %RMAN_LOG_FILE%
@echo   ORACLE_HOME  :  %ORACLE_HOME%         >> %RMAN_LOG_FILE%
@echo   ORACLE_SID  :  %ORACLE_SID%           >> %RMAN_LOG_FILE%
@echo   NLS_DATE_FORMAT  :  %NLS_DATE_FORMAT% >> %RMAN_LOG_FILE%
@echo   RMAN_LOG_FILE  :  %RMAN_LOG_FILE%     >> %RMAN_LOG_FILE%

@echo   NB_ORA_SERV  :  %NB_ORA_SERV%                     >> %RMAN_LOG_FILE%
@echo   NB_ORA_FULL  :  %NB_ORA_FULL%                     >> %RMAN_LOG_FILE%
@echo   NB_ORA_INCR  :  %NB_ORA_INCR%                     >> %RMAN_LOG_FILE%
@echo   NB_ORA_CINC  :  %NB_ORA_CINC%                     >> %RMAN_LOG_FILE%
@echo   NB_ORA_CLASS  :  %NB_ORA_CLASS%                   >> %RMAN_LOG_FILE%

@if "%NB_ORA_FULL%" EQU "1" @set BACKUP_TYPE=INCREMENTAL Level=0
@if "%NB_ORA_INCR%" EQU "1" @set BACKUP_TYPE=INCREMENTAL Level=1
@if "%NB_ORA_CINC%" EQU "1" @set BACKUP_TYPE=INCREMENTAL Level=1 CUMULATIVE
@if NOT DEFINED BACKUP_TYPE @set BACKUP_TYPE=INCREMENTAL Level=0

@(
echo RUN {
echo ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
echo ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
echo BACKUP
echo       %BACKUP_TYPE%
echo       FORMAT 'bk_u%%u_s%%s_p%%p_t%%t'
echo       DATABASE;
echo sql 'alter system archive log current';
echo RELEASE CHANNEL ch00;
echo RELEASE CHANNEL ch01;
echo # Backup all archive logs
echo ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
echo BACKUP
echo       FILESPERSET 20
echo       FORMAT 'arch-s%%s-p%%p'
echo       ARCHIVELOG ALL;
echo RELEASE CHANNEL ch00;
echo }
) | %RMAN% target %TARGET_CONNECT_STR% nocatalog msglog '%RMAN_LOG_FILE%' append

@set ERRLEVEL=%ERRORLEVEL%

@if %ERRLEVEL% NEQ 0 @goto err

@set LOGMSG=ended successfully
@if "%STATUS_FILE%" EQU "" goto end
@echo 0 > "%STATUS_FILE%"
@goto end

:err
@set LOGMSG=ended in error
@if "%STATUS_FILE%" EQU "" @goto end
@echo 1 > "%STATUS_FILE%"

:end

@for /F "tokens=1*" %%p in ('date /T') do @set DATE=%%p %%q
@for /F %%p in ('time /T') do @set DATE=%DATE% %%p

@echo #  >> %RMAN_LOG_FILE%
@echo %==== %LOGMSG% on %DATE% ==== >> %RMAN_LOG_FILE%
@endlocal

Answer 5

你准备备份到什么地方去哦
还有，你如果不用两个channel，就用一个，还有问题吗

Answer 6

http://blog.chinaunix.net/u1/38775/showart_310167.html

可以解決問題