備份oracle數(shù)據(jù)庫出錯

input datafile fno=00027 name=/index/neas_standard01.dbf

input datafile fno=00035 name=/oradata1/tancke/neas_standard09.dbf

input datafile fno=00001 name=/oradata/new/tancke/system01.dbf

channel ch01: starting piece 1 at 06-SEP-10

RMAN-03009: failure of backup command on ch01 channel at 09/06/2010 22:32:34

ORA-19506: failed to create sequential file, name="bk_11648_1_729037899", 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 09/06/2010 22:32:37

ORA-19506: failed to create sequential file, name="bk_11647_1_729037897", 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.

原因：

備份的客戶端是兩個aix，分別為a和b，兩者有ip 1和2以及群集ip3

以前在活動節(jié)點是b，備份沒問題；

現(xiàn)在活動節(jié)點在a上就有問題；

原因就在于在備份策略上使用的是群集名稱c，在這個節(jié)點上，名稱c解析出的ip地址居然是另外一個節(jié)點的ip，所以就會出現(xiàn)找不到備份策略的故障。

復制一個備份策略，然后在新策略里面指定客戶端的名稱為節(jié)點名稱，不用群集名稱。

總結(jié)

以上是生活随笔為你收集整理的oracle出错如何备份数据,备份oracle数据库出错的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。