Chinaunix

标题: tivoli 备份不起.急啊,请大家帮我看看.谢谢了哈, [打印本页]

作者: zzjlzx 时间: 2007-05-30 09:50
标题: tivoli 备份不起.急啊,请大家帮我看看.谢谢了哈,
tivoli 备份不起.急啊,请大家帮我看看.谢谢了哈,
# cat lev0.log

Recovery Manager: Release 10.2.0.1.0 - Production on Wed May 30 09:43:12 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: CDCGK (DBID=667510733)
using target database control file instead of recovery catalog

RMAN> run{

2> allocate channel t1 type 'sbt_tape' connect * parms 'ENV=(tdpo_optfile=/usr/t
ivoli/tsm/client/oracle/bin64/tdpo.opt)';
3> allocate channel t2 type 'sbt_tape' connect * parms 'ENV=(tdpo_optfile=/usr/t
ivoli/tsm/client/oracle/bin64/tdpo.opt)';
4> backup incremental level 0 database format='LEV0_%d_%t_%U' filesperset=3 disk
ratio=0 tag=Weekly_Full_Backup;
5> sql 'alter system archive log current';

6> backup format 'arch%t_%s_%p' diskratio=0 archivelog all delete all input;

7> release channel t1;

8> release channel t2;

9> }
10>
allocated channel: t1
channel t1: sid=118 instance=cdcgk1 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.3.3.0

released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-12001: could not open channel t2
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database
ORA-12520: TNS:listener could not find available handler for requested type of s
erver

Recovery Manager complete.
# ./

作者: jnwwww 时间: 2007-05-30 10:11
目标数据库链接不上

检查ip参数、网络通道、监听是否正常。

作者: zzjlzx 时间: 2007-05-30 10:19

原帖由 jnwwww 于 2007-5-30 10:11 发表
目标数据库链接不上

检查ip参数、网络通道、监听是否正常。

兄弟,怎么检查啊?需要我贴什么吗?我才开始搞AIX.

作者: zzjlzx 时间: 2007-05-30 12:05
# lsdev -Cc tape
rmt0 Available 03-08-00-0,0 LVD SCSI 4mm Tape Drive
rmt1 Defined 05-08-02    IBM 3580 Ultrium Tape Drive (FCP)
rmt2 Defined 05-08-02    IBM 3580 Ultrium Tape Drive (FCP)
smc0 Defined 05-08-02    IBM 3576 Library Medium Changer (FCP)

作者: jnwwww 时间: 2007-05-30 14:05
让你检查到目标数据库的通道，本地数据库和目标数据库的监听是否正常。

不是aix，是让你看看oracle是否正常。

作者: zzjlzx 时间: 2007-05-30 14:17
$ lsnrctl

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 30-MAY-
2007 14:16:35

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                   LISTENER_CGSJK2
Version                TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1
.0 - Production
Start Date             30-MAY-2007 09:25:46
Uptime                   0 days 4 hr. 50 min. 55 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   ON
Listener Parameter File /oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File       /oracle/product/10.2.0/db_1/network/log/listener_cgsjk
2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.192.208.10)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.192.208.5)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "cdcgk" has 2 instance(s).
  Instance "cdcgk1", status READY, has 1 handler(s) for this service...
  Instance "cdcgk2", status READY, has 1 handler(s) for this service...
Service "cdcgkXDB" has 2 instance(s).
  Instance "cdcgk1", status READY, has 1 handler(s) for this service...
  Instance "cdcgk2", status READY, has 1 handler(s) for this service...
Service "cdcgk_XPT" has 2 instance(s).
  Instance "cdcgk1", status READY, has 1 handler(s) for this service...
  Instance "cdcgk2", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>

作者: hp9000a 时间: 2007-05-30 14:23
你的设备都是defined,怎么用，查查光纤线。

作者: jnwwww 时间: 2007-05-30 14:24
用tnsping测试一下。

作者: zzjlzx 时间: 2007-05-30 14:50
$ tnsping cgsjk1

TNS Ping Utility for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production o
n 30-MAY-2007 14:48:55

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=cgsjk1.))(ADDRESS
=(PROTOCOL=TCP)(HOST=10.192.208.4)(PORT=1521)))
OK (120 msec)
$

原帖由 hp9000a 于 2007-5-30 14:23 发表
你的设备都是defined,怎么用，查查光纤线。

我也觉得好像这里有点奇怪,但AIX不熟,麻烦大家帮我分析一下,还需要什么信息,我就贴上来.谢谢了.

[ 本帖最后由 zzjlzx 于 2007-5-30 14:54 编辑 ]

作者: ewhisper 时间: 2007-05-30 14:57
RAC?研究一下listener.ora

作者: zzjlzx 时间: 2007-05-30 15:04
# cat /oracle/product/10.2.0/db_1/network/admin/listener.ora
# listener.ora.cgsjk1 Network Configuration File: /oracle/product/10.2.0/db_1/ne
twork/admin/listener.ora.cgsjk1
# Generated by Oracle configuration tools.

SID_LIST_LISTENER_CGSJK1 =
  (SID_LIST =
(SID_DESC =
   (SID_NAME = PLSExtProc)
   (ORACLE_HOME = /oracle/product/10.2.0/db_1)
   (PROGRAM = extproc)
)
  )

LISTENER_CGSJK1 =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.192.208.9)(PORT = 1521)(IP = FIRST))
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.192.208.4)(PORT = 1521)(IP = FIRST))
)
  )

#

=============================================================================

# cat listener.ora
# listener.ora.cgsjk2 Network Configuration File: /oracle/product/10.2.0/db_1/ne
twork/admin/listener.ora.cgsjk2
# Generated by Oracle configuration tools.

SID_LIST_LISTENER_CGSJK2 =
  (SID_LIST =
(SID_DESC =
   (SID_NAME = PLSExtProc)
   (ORACLE_HOME = /oracle/product/10.2.0/db_1)
   (PROGRAM = extproc)
)
  )

LISTENER_CGSJK2 =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = cgsjk2_vip)(PORT = 1521)(IP = FIRST))
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.192.208.5)(PORT = 1521)(IP = FIRST))
)
  )

#

[ 本帖最后由 zzjlzx 于 2007-5-30 15:07 编辑 ]

作者: ewhisper 时间: 2007-05-30 15:12
你的target是CDCGK啊

作者: zzjlzx 时间: 2007-05-30 15:27

原帖由 ewhisper 于 2007-5-30 15:12 发表
你的target是CDCGK啊

恩,这里有问题哇??

作者: ewhisper 时间: 2007-05-30 15:31
找你们装数据库的人来

作者: zzjlzx 时间: 2007-05-30 15:37
老大,他现在在西藏.5555555555555

作者: lijinshansir 时间: 2007-05-30 16:56
标题: 回复 7楼 hp9000a 的帖子
defined状态设备是正常啊，不要乱说！

作者: herowangzj 时间: 2007-05-30 17:18
3310磁带库都是defined状态，当然不能建立RMAN通道，你的存储设备状态先弄好。

作者: zzjlzx 时间: 2007-05-30 17:41

原帖由 herowangzj 于 2007-5-30 17:18 发表
3310磁带库都是defined状态，当然不能建立RMAN通道，你的存储设备状态先弄好。

我是不是要把4个defined状态的都mkdev -l 喃??

作者: ewhisper 时间: 2007-05-30 20:35
不是这个问题吧，没划zone而已，tsmserver不是也在这机器上吧

作者: zzjlzx 时间: 2007-05-31 09:56
tsmserver好像在一台win2003的服务器上.

作者: cddai 时间: 2007-05-31 15:05
TSM SERVER是在AIX上还是在WINDOWS上？如果是在TSM SERVER上，设备如果是DEFINED，是不能使用的。现在你是备ORACLE有问题，我估计备文件也有问题，因为DEFINED的设备TSM是没有办法使用的。

作者: zzjlzx 时间: 2007-06-02 13:44
这个怎么看啊,WIN2003的服务器可以HTTP到1580端口进行带库的查询什么的,但ORACLE 的归档文件,是在小机上直接运行 lev0.sh备到带库上的.

作者: dteheha 时间: 2007-06-03 21:54
up

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