ADSM-L

Re: RMAN /TDP backup failing with ANS1025E error - resolved

2003-01-22 11:40:49
Subject: Re: RMAN /TDP backup failing with ANS1025E error - resolved
From: shekhar Dhotre <Shekhar.Dhotre AT LENDLEASEREI DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 22 Jan 2003 11:33:23 -0500
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 <gagan AT QUANTM DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
01/21/2003 10:24 PM
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        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" <Shekhar.Dhotre AT LENDLEASEREI DOT COM>
To: <ADSM-L AT VM.MARIST DOT EDU>
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
> shekhar.dhotre AT lendleaserei DOT com
>
>

<Prev in Thread] Current Thread [Next in Thread>
  • Re: RMAN /TDP backup failing with ANS1025E error - resolved, shekhar Dhotre <=