Chinaunix

标题: Netbackup-Oracle 9i RMAN Error-for help [打印本页]

作者: kylix-2008 时间: 2007-05-23 17:08
标题: Netbackup-Oracle 9i RMAN Error-for help
環境：os solaris 9
      db oracle 9206
      veritas: NBU 5.1
通過Netbackup 執行腳本：/usr/openv/netbackup/ext/db_ext/oracle/hot_database_backup.sh時問題如下：
請各位大俠指點。。。

Script /usr/openv/netbackup/ext/db_ext/oracle/hot_database_backup.sh
==== started on Wed May 23 16:45:29 CST 2007 ====

RMAN: /disk1/db/proddb/9.2.0/bin/rman
ORACLE_SID: PROD
ORACLE_USER: testora
ORACLE_HOME: /disk1/db/proddb/9.2.0

NB_ORA_FULL: 1
NB_ORA_INCR: 0
NB_ORA_CINC: 0
NB_ORA_SERV: bckserver01
NB_ORA_POLICY: erptest_ORA

Full backup requested
Sun Microsystems Inc. SunOS 5.9    Generic May 2002

Recovery Manager: Release 9.2.0.6.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: PROD (DBID=4289347283)
using target database controlfile 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
>
allocated channel: ch00
channel ch00: sid=11 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 5.1 (2004043016)

Starting backup at 23-MAY-07
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00013 name=/disk1/db/proddata/a_archive01.dbf
input datafile fno=00015 name=/disk1/db/proddata/a_media01.dbf
input datafile fno=00031 name=/disk1/db/proddata/odm.dbf
input datafile fno=00033 name=/disk1/db/proddata/owad01.dbf
input datafile fno=00012 name=/home/proddata/undo01.dbf
channel ch00: starting piece 1 at 23-MAY-07
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch00 channel at 05/23/2007 16:45:32
ORA-19506: failed to create sequential file, name="bk_31_1_623349931", 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 server.

RMAN>

Recovery Manager complete.

Script /usr/openv/netbackup/ext/db_ext/oracle/hot_database_backup.sh
==== ended in error on Wed May 23 16:45:33 CST 2007 ====

作者: shilifenglg 时间: 2007-05-23 17:18
帮你顶！
没在Solaris环境下做过，期待楼下达人帮你解答。

作者: wolfheader 时间: 2007-05-23 17:30
检查链接文件吧

$ORACLE_HOME/lib/libobk.so

作者: maping 时间: 2007-05-23 18:42
1、确认是否有可用介质
2、确认文件是否可以备份
3、确认oracle的link是否有问题。
4、检查备份脚本

建议分别测试，可以考虑重新装软件。

或者将/etc/services的文件权限改到最大，试一试。

作者: hcjia 时间: 2007-05-23 20:20
看错误信息,应该是链接问题!

作者: huguoquan 时间: 2007-05-23 21:37
运行一下这个看看结果是什么贴出来
C:\>rman nocatalog

Recovery Manager: Release 8.1.6.0.0 - Production

RMAN> connect target /

RMAN-06005: connected to target database: ORCL (DBID=1028355197)
RMAN-06009: using target database controlfile instead of recovery catalog

RMAN> allocate channel for maintenance type 'sbt_tape';

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: delete
RMAN-08500: channel delete: sid=17 devtype=SBT_TAPE
RMAN-08526: channel delete: VERITAS NetBackup for Oracle - Release 4.5FP_3GA (20
02111220)

作者: maping 时间: 2007-05-23 21:38

原帖由 huguoquan 于 2007-5-23 21:37 发表
运行一下这个看看结果是什么贴出来
C:\>rman nocatalog

Recovery Manager: Release 8.1.6.0.0 - Production

RMAN> connect target /

RMAN-06005: connected to target database: ORCL (DBID=1028 ...

什么意思？

作者: huguoquan 时间: 2007-05-23 21:41
这个实质上就是调用RMAN来检测连接是否成功的 sbt_tape是分配给NBU做备份用的

作者: jxbcpp 时间: 2007-05-23 23:35
你的客户机或者服务器有台是双网卡。你在那台双网卡的机器上修改bp.conf，添加：
REQUIRED_NETWORK = 192.132.28.0 （你要指定网卡的网段）
或者
REQUIRED_INTERFACE = HOSTNAME （你要指定的网卡主机名）

或者
可能你客户端和服务器时间相差太大

作者: hcjia 时间: 2007-05-24 10:36
继续关注!

作者: maping 时间: 2007-05-24 11:30
楼主问题有解决吗？

作者: xiaomao2006 时间: 2007-05-26 00:25
/usr/openv/netbackup/bin/admincmd/bpgetconfig | grep -i disallow

Look for the following in the output:

DISALLOW_CLIENT_LIST_RESTORE = YES
DISALLOW_CLIENT_RESTORE = YES

在 bp.conf中去掉上面两行试试

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)