备份脚本没有问题,因为一直都是用这个脚本来着,由于更换tsm servser端服务器导致我重新建tsm,建好之后测试hosts备份正常,虚拟带库都可以查看,当用rman脚本备份时出现问题,报错如下:
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of crosscheck command on t1 channel at 07/07/2016 14:04:56
ORA-27191: sbtinfo2 returned error
Additional information: 2
也不是密码过期问题,因为我已经update结点的密码。
请各位帮忙查看下,谢谢!
具体信息如下:
@王巧雷
tdpo配置:
DSMI_ORC_CONFIG /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
DSMI_LOG /home/oracle/log
TDPO_FS orc9
TDPO_NODE ora_lydb51
TDPO_OWNER root
TDPO_PSWDPATH /home/oracle
tdpoconf showenv:
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: SERVER1
Server Address: 10.8.48.164
Server Type: Linux/i386
Server Port: 1500
Communication Method: TCP/IP
SESSION INFORMATION
Owner Name: root
Node Name: ora_lydb51
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: /home/oracle
Compression: FALSE
sbttest 1:
$ sbttest 1
The sbt function pointers are loaded from libobk.a(shr.o) library.
-- sbtinit succeeded
Return code -1 from sbtinit, bsercoer = 0, bsercerrno = 0
Message 0 not found; product=RDBMS; facility=SBT
帮忙看看有没有问题。谢谢啊!
特此标注:
问题解决了!
先卖个关子,出现问题后记得一定要问题简单化,能多简单就多简单的想,从基础的查起,这次问题是由于脚本的问题。
下面我把脚本发给大家,记得好好看看,不要像我这样了,
run
{
allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' maxpiecesize 2048m;
allocate channel t2 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' maxpiecesize 2048m;
allocate channel t3 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' maxpiecesize 2048m;
allocate channel t4 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' maxpiecesize 2048m;
backup database filesperset 20 format 'lydb4_full_%T_%u_%p_%c.dbf' (database include current controlfile);
sql 'alter system archive log current';
backup archivelog all format '/arch_lydb51/lydb5_arhc_%T_%t_%p_%c.bdf' delete all input;
backup current controlfile format '/arch_lydb51/cntrl_%s_%p_%s.bdf';
release channel t1;
release channel t2;
release channel t3;
release channel t4;
}
删除脚本命令自己上网查看,我这边也没有写呢。
收起测试备份很正常:
root@lydb51:/usr/tivoli/tsm/client/oracle/bin64# dsmc backup /etc/hosts
IBM Tivoli Storage Manager
Command Line Backup/Archive Client Interface
Client Version 5, Release 3, Level 4.0
Client date/time: 07/07/16 14:53:49
(c) Copyright by IBM Corporation and other(s) 1990, 2006. All Rights Reserved.
Node Name: ORA_LYDB51
Session established with server SERVER1: Linux/i386
Server Version 5, Release 5, Level 5.2
Server date/time: 07/07/16 14:53:07 Last access: 07/07/16 14:38:28
Selective Backup function invoked.
Normal File--> 2,102 /etc/hosts ** Unsuccessful **
ANS1114I Waiting for mount of offline media.
Retry # 1 Normal File--> 2,102 /etc/hosts [Sent]
Selective Backup processing of '/etc/hosts' finished without failure.
Total number of objects inspected: 1
Total number of objects backed up: 1
Total number of objects updated: 0
Total number of objects rebound: 0
Total number of objects deleted: 0
Total number of objects expired: 0
Total number of objects failed: 0
Total number of bytes transferred: 4.16 KB
Data transfer time: 0.00 sec
Network data transfer rate: 260,498.04 KB/sec
Aggregate data transfer rate: 0.65 KB/sec
Objects compressed by: 0%
Elapsed processing time: 00:00:06
root@lydb51:/usr/tivoli/tsm/client/oracle/bin64#
收起