免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 4163 | 回复: 5
打印 上一主题 下一主题

[备份软件] tsm5.3+oracle10g+aix5309无法正常备份,请大虾看一下! [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2009-08-27 14:15 |只看该作者 |倒序浏览
RMAN> run {
2> allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/
client/oracle/bin64/tdpo.opt)';
3> allocate channel t2 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/
client/oracle/bin64/tdpo.opt)';
4> backup
5> format 'ctl_%t_%s_%p'
6> tag controlfile_bk
7> (current controlfile);
8> backup
9> full
10> tag oradb1_backup
11> filesperset 5
12> format 'df_%t_%s_%p'
13> (database);
14> #sql "alter system switch logfile";
15> #backup
16> #format 'df_%t_%s_%p'
17> #(archivelog all delete input);
18> release channel t1;
19> release channel t2;
20> }
21>
allocated channel: t1
channel t1: sid=291 instance=gzptdb1 devtype=SBT_TAPE
channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0

allocated channel: t2
channel t2: sid=300 instance=gzptdb1 devtype=SBT_TAPE
channel t2: Tivoli Data Protection for Oracle: version 5.2.0.0

Starting backup at 19-AUG-09
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
including current control file in backupset
channel t1: starting piece 1 at 19-AUG-09
channel t1: finished piece 1 at 19-AUG-09
piece handle=ctl_695296918_17_1 tag=CONTROLFILE_BK comment=API Version 2.0,MMS V
ersion 5.2.0.0
channel t1: backup set complete, elapsed time: 00:00:35
Finished backup at 19-AUG-09

Starting backup at 19-AUG-09
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00003 name=/dev/rdbsysaux
input datafile fno=00001 name=/dev/rdbsystem
channel t1: starting piece 1 at 19-AUG-09
channel t2: starting full datafile backupset
channel t2: specifying datafile(s) in backupset
input datafile fno=00002 name=/dev/rdbundotbs1
input datafile fno=00004 name=/dev/rdbundotbs2
input datafile fno=00005 name=/dev/rdbusers
channel t2: starting piece 1 at 19-AUG-09
RMAN-03009: failure of backup command on t2 channel at 08/19/2009 10:09:12
ORA-19513: failed to identify sequential file
ORA-27206: requested file not found in media management catalog
ORA-19502: write error on file "df_695296956_19_1", blockno 415745 (blocksize=51
2)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
   ANS1017E (RC-50)  Session rejected: TCP/IP connection failure
channel t2 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on t1 channel at 08/19/2009 10:10:07
ORA-19513: failed to identify sequential file
ORA-27206: requested file not found in media management catalog
ORA-19502: write error on file "df_695296956_18_1", blockno 1192449 (blocksize=5
12)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
   ANS1017E (RC-50)  Session rejected: TCP/IP connection failure
channel t1 disabled, job failed on it will be run on another channel
released channel: t1
released channel: t2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on t1 channel at 08/19/2009 10:10:07
ORA-19513: failed to identify sequential file
ORA-27206: requested file not found in media management catalog
ORA-19502: write error on file "df_695296956_18_1", blockno 1192449 (blocksize=5
12)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
   ANS1017E (RC-50)  Session rejected: TCP/IP connection failure
RMAN-03009: failure of backup command on t2 channel at 08/19/2009 10:09:12
ORA-19513: failed to identify sequential file
ORA-27206: requested file not found in media management catalog
ORA-19502: write error on file "df_695296956_19_1", blockno 415745 (blocksize=51
2)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
   ANS1017E (RC-50)  Session rejected: TCP/IP connection failure

Recovery Manager complete.

论坛徽章:
0
2 [报告]
发表于 2009-08-27 14:29 |只看该作者
tdpo配置

IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 2, Level 0.0
(C) Copyright IBM Corporation 1997, 2003. All rights reserved.


DATA PROTECTION FOR ORACLE INFORMATION
Version:              5
Release:              2
Level:                0
Sublevel:             0
Platform:             64bit TDP Oracle AIX

TSM SERVER INFORMATION
Server Name:          TSMSVR
Server Address:       10.100.2.5
Server Type:          Windows
Server Port:          1500
Communication Method: TCP/IP

SESSION INFORMATION
Owner Name:           root
Node Name:            gzptdb1
Node Type:            TDP Oracle AIX
DSMI_DIR:             /usr/tivoli/tsm/client/api/bin64
DSMI_ORC_CONFIG:      /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
TDPO_OPTFILE:         /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt
Password Directory:   /usr/tivoli/tsm/client/oracle/bin64
Compression:          FALSE

论坛徽章:
0
3 [报告]
发表于 2009-08-27 17:42 |只看该作者
问题解决
ANR0481W 节点 节点名称 (客户机平台) 的会话 会话编号 终止 — 客户机未在 公共超时秒数 秒内响应。  

说明: 服务器终止客户机会话,因为客户机已挂起数据库锁定(正在进行事务),并且客户机在由服务器选项文件中的参数 COMMTIMEOUT 指定的秒数内没有响应。

系统操作: 服务器回滚正在进行的事务并终止会话。服务器操作继续。

用户响应: 如果同时出现大量的此类消息,那么您可能想增大在服务器选项文件中指定的 COMMTIMEOUT 值并且重新启动服务器。客户机响应所用的时间取决于客户机的速度、客户机处理器的负荷和网络负荷。

把COMMTIMEOUT 值设大些

论坛徽章:
0
4 [报告]
发表于 2009-09-02 10:43 |只看该作者
可以试试看做如下修改:

1- update node <节点名称> maxnummp=2
2- set serverpassword <password>,这里的口令要跟你的客户机上设置的一样。

论坛徽章:
1
CU十二周年纪念徽章
日期:2013-10-24 15:41:34
5 [报告]
发表于 2009-09-02 16:46 |只看该作者
学习学习。

论坛徽章:
1
荣誉版主
日期:2011-11-23 16:44:17
6 [报告]
发表于 2009-09-03 02:02 |只看该作者
Message GUide里的东西要手边必备的

开始搞TSM了?
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP