oracle储存问题,【已解决】备份oracle数据库出错

本帖最后由 撒旦的使者 于 2010-09-07 16:08 编辑

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

以前在活动节点是b，备份没问题；

现在活动节点在a上就有问题；

原因就在于在备份策略上使用的是群集名称c，在这个节点上，名称c解析出的ip地址居然是另外一个节点的ip，所以就会出现找不到备份策略的故障。

复制一个备份策略，然后在新策略里面指定客户端的名称为节点名称，不用群集名称。