新建的备份策略，备份失败。请帮忙看看

faceDragon

Script /nbu-scripts/hot_database_backup.sh
==== started on Mon Oct 29 15:58:48 CST 2012 ====


RMAN: /u01/oracle/product/11.1.0/bin/rman
ORACLE_SID: BIDWPROD
ORACLE_USER: oraprod
ORACLE_HOME: /u01/oracle/product/11.1.0

NB_ORA_FULL: 1
NB_ORA_INCR: 0
NB_ORA_CINC: 0
NB_ORA_SERV: dbbackup
NB_ORA_POLICY: ora-bi-bak

Full backup requested

Recovery Manager: Release 11.1.0.7.0 - Production on Mon Oct 29 15:58:48 2012

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

connected to target database: BIDWPROD (DBID=922326615)
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> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 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> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38>
allocated channel: ch00
channel ch00: SID=945 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.0 (2010010419)

allocated channel: ch01
channel ch01: SID=896 device type=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 7.0 (2010010419)

Starting backup at 29-OCT-12
channel ch00: starting incremental level 0 datafile backup set
channel ch00: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/oracle/oradata/BIDWPROD/undotbs01.dbf
input datafile file number=00002 name=/u01/oracle/oradata/BIDWPROD/sysaux01.dbf
input datafile file number=00004 name=/u01/oracle/oradata/BIDWPROD/users01.dbf
channel ch00: starting piece 1 at 29-OCT-12
channel ch01: starting incremental level 0 datafile backup set
channel ch01: specifying datafile(s) in backup set
input datafile file number=00005 name=/u01/oracle/oradata/BIDWPROD/informatica01.dbf
input datafile file number=00008 name=/u01/oracle/oradata/BIDWPROD/bidw_indexd01.dbf
input datafile file number=00010 name=/u01/oracle/oradata/BIDWPROD/bidwd03.dbf
input datafile file number=00006 name=/u01/oracle/oradata/BIDWPROD/dac01.dbf
input datafile file number=00013 name=/u01/oracle/oradata/BIDWPROD/bidwd05.dbf
channel ch01: starting piece 1 at 29-OCT-12
RMAN-03009: failure of backup command on ch01 channel at 10/29/2012 15:59:07
ORA-19506: failed to create sequential file, name="bk_1416_1_797961532", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   VxBSACreateObject: Failed with error:
   Server Status:  the specified policy does not exist in the configuration database
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 10/29/2012 15:59:08
ORA-19506: failed to create sequential file, name="bk_1415_1_797961531", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   VxBSACreateObject: Failed with error:
   Server Status:  the specified policy does not exist in the configuration database

RMAN> RMAN>

Recovery Manager complete.

Script /nbu-scripts/hot_database_backup.sh
==== ended in error on Mon Oct 29 15:59:08 CST 2012 ====

能看出来是什么原因吗？

匪徒易真

把备份脚本贴出来！！！！

faceDragon

回复 2# 匪徒易真

1. CMD_STR="
   
2. ORACLE_HOME=$ORACLE_HOME
   
3. export ORACLE_HOME
   
4. ORACLE_SID=$ORACLE_SID
   
5. export ORACLE_SID
   
6. $RMAN target $TARGET_CONNECT_STR nocatalog msglog $RMAN_LOG_FILE append << EOF
   
7. RUN {
   
8. ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
   
9. ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
   
10. BACKUP
    
11.     $BACKUP_TYPE
    
12.     SKIP INACCESSIBLE
    
13.     TAG hot_db_bk_level0
    
14.     FILESPERSET 5
    
15.     # recommended format
    
16.     FORMAT 'bk_%s_%p_%t'
    
17.     DATABASE;
    
18.     sql 'alter system archive log current';
    
19. RELEASE CHANNEL ch00;
    
20. RELEASE CHANNEL ch01;
    
21. # backup all archive logs
    
22. ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
    
23. ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
    
24. BACKUP
    
25.    filesperset 20
    
26.    FORMAT 'al_%s_%p_%t'
    
27.    ARCHIVELOG ALL DELETE INPUT;
    
28. RELEASE CHANNEL ch00;
    
29. RELEASE CHANNEL ch01;
    
30. #
    
31. # Note: During the process of backing up the database, RMAN also backs up the
    
32. # control file.  This version of the control file does not contain the
    
33. # information about the current backup because "nocatalog" has been specified.
    
34. # To include the information about the current backup, the control file should
    
35. # be backed up as the last step of the RMAN section.  This step would not be
    
36. # necessary if we were using a recovery catalog.
    
37. #
    
38. ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
    
39. BACKUP
    
40.     # recommended format
    
41.     FORMAT 'cntrl_%s_%p_%t'
    
42.     CURRENT CONTROLFILE;
    
43. RELEASE CHANNEL ch00;
    
44. }
    
45. EOF
    
46. "

复制代码

代码是直接从可以成功备份的客户端拷贝过来的，只是修改了几个如ORACEL_HOEM,ORACLE_SID,ORACLE用户之类的参数，所以我觉得不可能会有问题。

匪徒易真

ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   VxBSACreateObject: Failed with error:
   Server Status:  the specified policy does not exist in the configuration database


从这段报错看， 你创建的策略是有问题的  还有，你动态库连接有没有成功啊

huanglao2002

ora-bi-bak  策略配置有问题吗？

faceDragon

备份策略会可能有什么类型的问题呢？我是直接拷贝一个在正常备份的策略后修改的。修改备份路径、时间窗、客户端和客户端脚本。这些内容应该不容易出现问题的。
动态库连接成功没成功怎么判断呢？是跟libobk.so文件有关吗

匪徒易真

policy type 、 policy storage、policy volume pool、 backup selections 都设置正确啊？  动态库连接如果不知道连接成功不成功，那就再重新连接一下看返回值就知道额。  还有RMAN备份，你数据库还开归档了啊

faceDragon

早上又去手工运行备份，居然可以了！晕。。。昨天什么都没动过