tivoli 备份不起.急啊,请大家帮我看看.谢谢了哈,

zzjlzx

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

目标数据库链接不上

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

zzjlzx

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

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

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

zzjlzx

# 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

让你检查到目标数据库的通道，本地数据库和目标数据库的监听是否正常。

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

zzjlzx

$ 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

你的设备都是defined,怎么用，查查光纤线。

jnwwww

用tnsping测试一下。

zzjlzx

$ 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

RAC?研究一下listener.ora