Hi Shekbar,
Where is your encrypted passwordfile? (TDPO_PSWDPATH in
/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt file!) Have you any read
right?
The passwordaccess generate option in your API dsm.sys file will not work
with TDP Oracle..
Please check your Oracle sbtio.log file for further informations.
If possible upgrade your TSMP API to 4.2.1 version.
best regards,
Sandor Maklari
User Consulting Ltd
Hungary
E-mail: smaklari AT user DOT hu
shekhar Dhotre
<Shekhar.Dhotre@LENDLE To:
ADSM-L AT VM.MARIST DOT EDU
ASEREI.COM> cc:
Sent by: "ADSM: Dist Subject: RMAN /TDP
backup failing with ANS1025E error
Stor Manager"
<ADSM-L AT VM.MARIST DOT EDU>
01/21/03 06:08 PM
Please respond to
"ADSM: Dist Stor
Manager"
Hi all,
client
AIX -4.3.3.10 - (One of the Node of SP complex ) TSM client 4.1.1.3 .
oracle 8.1.7.0
server : AIX (4.3.3.10 ) TSM server - 5.1.1.4
I have configured RMAN/TDP 2.2.1.0 for oracle 8.1.7 database. and It
worked fine first time .Today I tried to run this backup manually and it
is failing with ORA-19511: ANS1025E (RC137) Session rejected:
Authentication failure .
oracle or TSM error ?
f2n17 /d01/app/oracle > dsmc q f
Tivoli Storage Manager
Command Line Backup Client Interface - Version 4, Release 1, Level 3.0
(C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved.
Node Name: F2N17
Session established with server TSM: AIX-RS/6000
Server Version 5, Release 1, Level 1.4
Data compression forced on by the server
Server date/time: 01/21/03 11:56:10 Last access: 01/21/03 11:30:49
Num Last Incr Date Type File Space Name
--- -------------- ---- ---------------
1 01/16/03 20:00:53 JFS /
2 01/16/03 20:00:56 JFS /best1
3 01/16/03 20:01:36 JFS /d01
4 01/16/03 20:01:39 JFS /d10
5 11/28/02 20:07:09 JFS /d11
6 01/16/03 20:01:39 JFS /d80
7 01/16/03 20:00:55 JFS /home
8 11/29/02 02:00:39 API:ORACLE /orc_v8back
9 00/00/00 00:00:00 JFS /tmp
10 01/16/03 20:00:55 JFS /tsmserv
11 01/16/03 20:00:54 JFS /usr
12 01/16/03 20:00:55 JFS /var
f2n17 /d01/app/oracle >
SVRMGR> select * from v$database;
DBID NAME CREATED RESETLOGS_ RESETLOGS PRIOR_RESE PRIOR_RES
LOG_MOD
E CHECKPOINT ARCHIVE_CH CONTROL CONTROLFI CONTROLFIL CONTROLFIL
CONTROLFI OP
EN_RESETL VERSION_T OPEN_MODE
---------- --------- --------- ---------- --------- ---------- ---------
-------
----- ---------- ---------- ------- --------- ---------- ----------
--------- --
--------- --------- ----------
3101863237 V8IBACK 24-OCT-02 1 24-OCT-02 0 ARCHIVE
LOG 43947 43125 CURRENT 24-OCT-02 373 44025
21-JAN-03 NO
T ALLOWED 24-OCT-02 READ WRITE
1 row selected.
SVRMGR> quit
Server Manager complete.
f2n17 /d01/app/oracle > more /tmp/bkdb.log
Recovery Manager: Release 8.1.7.0.0 - Production
RMAN-06005: connected to target database: V8IBACK (DBID=3101863237)
RMAN-06008: connected to recovery catalog database
RMAN> run {
2> allocate channel t1 type 'sbt_tape' parms
3> 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
4> backup
5> filesperset 4
6> format 'df_%t_%s_%p'
7> (database);
8>
9> release channel t1;
10> }
11>
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=9 devtype=SBT_TAPE
RMAN-08526: channel t1: Tivoli Data Protection for Oracle: version 2.2.1.0
RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel t1: starting full datafile backupset
RMAN-08502: set_count=23 set_stamp=483881448 creation_time=21-JAN-03
RMAN-08010: channel t1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00006 name=/d11/ora/rcv01.dbf
RMAN-08522: input datafile fno=00001 name=/d10/oradata/v8iback/system.dbf
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=00004
name=/d10/oradata/v8iback/user_data.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel t1
RMAN-10035: exception raised in RPC: ORA-19506: failed to create
sequential file
, name="df_483881448_23_1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: ANS1025E (RC137) Session rejected: Authentication failure
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.BACKUPPIECECRE
ATE
Recovery Manager complete.
f2n17 /d01/app/oracle >
Thanks and regards .
Shekhar Dhotre .
Sr.Unix Admin
Lend lease REI
shekhar.dhotre AT lendleaserei DOT com
|