新建的備份策略，備份失敗。請幫忙看看

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用戶之類的參數(shù)，所以我覺得不可能會有問題。

匪徒易真

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


從這段報錯看， 你創(chuàng)建的策略是有問題的  還有，你動態(tài)庫連接有沒有成功啊

huanglao2002

ora-bi-bak  策略配置有問題嗎？

faceDragon

備份策略會可能有什么類型的問題呢？我是直接拷貝一個在正常備份的策略后修改的。修改備份路徑、時間窗、客戶端和客戶端腳本。這些內(nèi)容應該不容易出現(xiàn)問題的。
動態(tài)庫連接成功沒成功怎么判斷呢？是跟libobk.so文件有關(guān)嗎

匪徒易真

policy type 、 policy storage、policy volume pool、 backup selections 都設置正確��？  動態(tài)庫連接如果不知道連接成功不成功，那就再重新連接一下看返回值就知道額。  還有RMAN備份，你數(shù)據(jù)庫還開歸檔了啊

faceDragon

早上又去手工運行備份，居然可以了！暈。。。昨天什么都沒動過