It is possible that RMAN backup and tdpoconf use different dsm.opt (and
different dsm.sys server stanzas). One way to check if the same stanza is
used:
1. Add an invalid "option" to dsm.sys stanza that you use. E.g
...
bad_option 1
..
2. Run tdpoconf showenv - should fail with "ANS0220E (RC400) An invalid
option was found during option parsing."
3. Run RMAN backup - should also fail with the same error
If you get different behavior in #2 and 3, you are using different server
stanzas in dsm.sys
Is passwordaccess set to generate or prompt?
Regards,
Mark L. Yakushev
Advisory Software Engineer
Tivoli Storage Manager Development
IBM Corporation
Almaden Research Center
From: Matthew Large <mlargedellteam AT GOOGLEMAIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: 05/28/2009 06:17 AM
Subject: Re: [ADSM-L] TDP Oracle failures
Guys, I have some new info, with a slightly different problem, I hope it
can
help:
This is the message in the rman output file:
RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at
05/28/2009 13:55:26
ORA-19506: failed to create sequential file, name="688053317_5871_1.arc",
parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
ANS1025E (RC137) Session rejected: Authentication failure
It says authentication failure, but I'm absolutely sure the tdpoconf
password process is working as I run the
TSM> upd no bidwp1-zp1-ora <password>
and the
UNIX> tdpoconf password <tdpo file>
with no errors. I even deleted the password file, and recreated it.
Running 'tdpoconf showenv <tdpo file>' returns succesfully:
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 4, Level 1.0
(C) Copyright IBM Corporation 1997, 2007. All rights reserved.
Data Protection for Oracle Information
Version: 5
Release: 4
Level: 1
Sublevel: 0
Platform: 64bit TDP Oracle SUN
Tivoli Storage Manager Server Information
Server Name: TSM1-LANFREE
Server Address: TSM1
Server Type: Solaris SPARC
Server Port: 1500
Communication Method: TCP/IP
Session Information
Owner Name:
Node Name: BIDWP1-ZP1-ORA
Node Type: TDP Oracle SUN
DSMI_DIR: /opt/tivoli/tsm/client/api/bin64
DSMI_ORC_CONFIG:
/usr/local/unixsup/backup/tsm/dsm.opt-SWISP012-BIDWP1-ZP1
TDPO_OPTFILE:
/usr/local/dba/scripts/backup/rman/tdpo/tdpo.opt-BIDWP1-BIDWP1-ZP1.
Password Directory: /opt/tivoli/tsm/client/oracle/bin64
Compression: FALSE
License Information: License file exists and contains valid license data.
Of course, tdpoconf password used the TDPO_OPTFILE mentioned above.
What authentication stage am I missing?
The data should go over the storage agent path, and if that was the problem
(I do not believe it is) errors associated with the Storage Agent would
appear instead.
Any ideas? Or elimination processes?
Much appreciated,
Matthew
On 5/26/09, Matthew Large <mlargedellteam AT googlemail DOT com> wrote:
>
> D'oh!
>
> Sorry - both the client and the server are SunOS 5.10.>
>
> My bad
>
>
> On Tue, May 26, 2009 at 10:57 AM, Matthew Large <.
> mlargedellteam AT googlemail DOT com> wrote:
>
>> Hi Dave,
>>
>> Sure - the clients are on Sun 5.10 and the servers are W2003sp2.
>>
>> Much appreciated
>>
>>
>> On Fri, May 22, 2009 at 5:31 PM, Dave Canan <ddcanan AT gmail DOT com>
>> wrote:
>>
>>> Could you please include the client and server OS platform and level?
>>> Thanks.
>>>
>>> On Fri, May 22, 2009 at 7:37 AM, Matthew Large <
>>> mlargedellteam AT googlemail DOT com> wrote:
>>>
>>> > Hi,
>>> >
>>> > I'm unable to ascertain the cause of this backup failure - the Oracle
>>> > errors
>>> > point to a disk problem, but then 'inappropriate ioctl for device'
>>> looks
>>> > like there is a problem with the destination device, not the source.
>>> >
>>> > Starting backup at 22-may-2009 14:44:34
>>> > current log archived
>>> > allocated channel: ORA_SBT_TAPE_1:
>>> > channel ORA_SBT_TAPE_1: sid=139 devtype=SBT_TAPE
>>> > channel ORA_SBT_TAPE_1: Data Protection for Oracle: version 5.4.1.0.
>>> > RMAN-00571:
===========================================================
>>> > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
>>> > RMAN-00571:
===========================================================
>>> > RMAN-03002: failure of backup command at 05/22/2009 14:45:08
>>> > ORA-19587: error occurred reading 512 bytes at block number 1
>>> > ORA-27091: unable to queue I/O
>>> > ORA-27072: File I/O error
>>> > SVR4 Error: 25: Inappropriate ioctl for device
>>> > Additional information: 4
>>> > Additional information: 1
>>> >
>>> > Recovery Manager complete.
>>> > + STATUS=1
>>> >
>>> > STATUS=1
>>> > Fri May 22 14:45:08 BST 2009: Backup failed
>>> > Fri May 22 14:45:08 BST 2009: Finished
>>> > swisp012#
>>> >
>>> >
>>> > Any help wholly appreciated!:
>>> >
>>> > Cheers,
>>> > Matthew
>>> >
>>>
>>>
>>>
>>>
>>>
>>>
>>>
|
