Rana ,
Regenerated password & changed password for node 17 on TSM , - RMAN
and TDP working as expected .
f2n17 />tdpoconf password
-tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/t>
***************************************************************
* Tivoli Data Protection for Oracle Utility *
* Password file initialization/update program *
* ROOT privilege needed to update value *
***************************************************************
Please enter current password:
Please enter new password:
Please reenter new password for verification:
ANS1361E (RC61) Session Rejected: The specified node name is currently
locked
tsm: TSM>unlock node f2n17
ANR2066I Node F2N17 unlocked.
f2n17 />tdpoconf password
-tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/t>
***************************************************************
* Tivoli Data Protection for Oracle Utility *
* Password file initialization/update program *
* ROOT privilege needed to update value *
***************************************************************
Please enter current password:
Please enter new password:
Please reenter new password for verification:
ANU0260I Password successfully changed.
f2n17 /tmp>tail -f bkdb.log
RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel t1: starting full datafile backupset
RMAN-08502: set_count=25 set_stamp=483966944 creation_time=22-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-08013: channel t1: piece 1 created
RMAN-08503: piece handle=df_483966944_25_1 comment=API Version 2.0,MMS
Version 2
RMAN-08502: set_count=26 set_stamp=483967059 creation_time=22-JAN-03
RMAN-08010: channel t1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00007 name=/d10/bkupdata/bkup01.db
RMAN-08522: input datafile fno=00003 name=/d10/orarbs/v8iback/rbs01.dbf
RMAN-08522: input datafile fno=00002 name=/d10/oratemp/v8iback/temp01.dbf
RMAN-08522: input datafile fno=00005
name=/d10/oraidx/v8iback/user_index.dbf
RMAN-08013: channel t1: piece 1 created
RMAN-08503: piece handle=df_483967059_26_1 comment=API Version 2.0,MMS
Version 2
.2.1.0
RMAN-08525: backup set complete, elapsed time: 00:01:05
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: t1
Recovery Manager complete.
tsm: TSM>q ses (last line for TDP and oracle )
Sess Comm. Sess Wait Bytes Bytes Sess Platform Client Name
Number Method State Time Sent Recvd Type
------ ------ ------ ------ ------- ------- ----- --------
--------------------
3 Tcp/Ip Run 0 S 10.5 M 139 Admin AIX ASOOD
1,824 Tcp/Ip Run 0 S 10.1 M 142 Admin AIX SUPADMIN
5,665 Tcp/Ip Run 0 S 7.1 M 138 Admin AIX DAVE
5,983 Tcp/Ip Run 0 S 7.0 M 142 Admin AIX SUPADMIN
12,368 Tcp/Ip Run 0 S 2.9 M 142 Admin AIX SUPADMIN
14,783 Tcp/Ip IdleW 35.1 M 18.6 K 542 Admin AIX DAVE
14,947 Tcp/Ip Run 0 S 110.8 K 3.1 M Node AIX F5N67
14,948 Tcp/Ip IdleW 18 S 10.9 K 8.2 G Node AIX F5N67
14,950 Tcp/Ip Run 0 S 38.5 K 154 Admin WinNT STORSERVER
15,011 Tcp/Ip Run 0 S 3.1 M 1.8 M Node AIX F5N67
15,012 Tcp/Ip Run 0 S 6.8 K 6.4 G Node AIX F5N67
15,014 Tcp/Ip IdleW 1.8 H 198.1 M 3.9 K Node AIX F3N37
15,021 Tcp/Ip IdleW 1.3 H 1.6 K 184 Admin AIX SUPADMIN
15,028 Tcp/Ip IdleW 28.9 M 3.0 K 619 Admin WinNT STORSERVER
15,029 Tcp/Ip IdleW 28.9 M 525 241 Admin WinNT STORSERVER
15,036 Tcp/Ip IdleW 9.5 M 339 263 Node AIX F2N21
15,097 Tcp/Ip RecvW 0 S 6.0 K 12.5 M Node TDP Ora cle AIX -
F2N17
Thanks and Regards
Shekhar Dhotre.
LEnd Lease REI .
Atlanta , GA
Gagan Singh Rana <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
01/21/2003 10:24 PM
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject: Re: RMAN /TDP backup failing with ANS1025E error
Dear Shekhar
Did u try genetrating password file with "tdpoconf passwd" ?? This could
be the possible
reason for not getting authenticated. Also use "tdpoconf showenv" to see
that all the
settings are correct. If u have already created password file, then run
that password
command again, and regeneate the password.
U could also try giving a new password to TDP client on server and then
regenerating it at
client with tdpoconf command.
rgds
Gagan Singh Rana
"Never be afraid to try something new. Remember that a lone amateur built
the Ark. A large
group of professionals built the Titanic."
the Business Enterprise Solutions Team
QuantM Systems Pvt. Ltd.
79 Amrit Nagar, NDSE Part I
New Delhi - 110003
Voice : 91-11-4691575/4602217
Fax : 91-11-4691188
Mobile : 91-9810290940
DISCLAIMER :
The information in this e-mail is confidential and may be legally
privileged. It is
intended SOLELY for the addressee. Access to this e-mail by anyone else is
unauthorized.
If you are NOT the intended recipient, any disclosure, copying,
distribution or any action
taken on it is prohibited and may be unlawful. Any opinions or advice
contained in this
e-mail are subject to the terms and conditions expressed in the governing
client
relationship engagement letter.
______________________________________________________________
Visit us at www.quantm.com
----- Original Message -----
From: "shekhar Dhotre" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 21, 2003 10:38 PM
Subject: RMAN /TDP backup failing with ANS1025E error
> 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
> [EMAIL PROTECTED]
>
>
