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 <mlargedellt...@googlemail.com> To: ADSM-L@VM.MARIST.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 <mlargedellt...@googlemail.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 <. > mlargedellt...@googlemail.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 <ddca...@gmail.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 < >>> mlargedellt...@googlemail.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 >>> > >>> >>> >>> >>> >>> >>> >>>
