tivoli 備份不起.急啊,請大家?guī)臀铱纯?謝謝了哈,

zzjlzx

tivoli 備份不起.急啊,請大家?guī)臀铱纯?謝謝了哈,
# 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

目標(biāo)數(shù)據(jù)庫鏈接不上

檢查ip參數(shù)、網(wǎng)絡(luò)通道、監(jiān)聽是否正常。

zzjlzx

原帖由 jnwwww 于 2007-5-30 10:11 發(fā)表
目標(biāo)數(shù)據(jù)庫鏈接不上

檢查ip參數(shù)、網(wǎng)絡(luò)通道、監(jiān)聽是否正常。

兄弟,怎么檢查啊?需要我貼什么嗎?我才開始搞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

讓你檢查到目標(biāo)數(shù)據(jù)庫的通道，本地數(shù)據(jù)庫和目標(biāo)數(shù)據(jù)庫的監(jiān)聽是否正常。

不是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

你的設(shè)備都是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 發(fā)表
你的設(shè)備都是defined,怎么用，查查光纖線。

我也覺得好像這里有點奇怪,但AIX不熟,麻煩大家?guī)臀曳治鲆幌?還需要什么信息,我就貼上來.謝謝了.

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

ewhisper

RAC?研究一下listener.ora