Re: Oracle/rman tdp failing
Thanks as usual, to all who responded. It turned out the DBA recycled the DB and all problems cleared up. He must have read that it was required after I pointed him to the TSM/RMAN documentation. Thanks again, Jim - Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products.
Re: Oracle/rman tdp failing
I seem to remember that upon upgrading the client code from 3.1 to 3.7, that the default entered by the installation for MAXNUMMP was "unlimited"- which is not correctly interpreted as 999, which is what I ended up changing the value to. |+ || Terry Barth | || Terry.Barth@MORTGAGEF| || AMILY.COM| ||| || 12/02/2000 06:02 AM | || Please respond to | || "ADSM: Dist Stor | || Manager" | ||| |+ | || | To: [EMAIL PROTECTED] | | cc: (bcc: Lisa Cabanas/SC/MODOT) | | Subject: Re: Oracle/rman tdp failing | | Hi James - I just got done updating all of my oracle clients to TDP and we had this same problem on 2 clients and it was the cause of 2 different issues. On 1 client, the database needed to be relinked with the libobk.a. On the other client, for some reason, we had lost the maxnum mount points and therefore, had to reset it by using "update nodename maxnummp=number of mount points All of my upgrades were 8.05, 8.06, 8.1.5, and 8.1.6 clients - everything went find, except for the 2 issues above. Also, have the oracle dba's make sure that all their scripts are pointing to the right directory if this is a change from IBM's to Tivoli's. We had some problems with our first upgrade due to misdirection in the scripts that were missed. -Original Message- From: James Healy [mailto:[EMAIL PROTECTED]] Sent: Friday, December 01, 2000 12:25 PM To: [EMAIL PROTECTED] Subject: Oracle/rman tdp failing Can anyone help with the error messages I'm grtiing from my oracle dba's attempt to run Rman backups tiot tsm uping the TDP. ORA-19506: failed to create sequential file, name="HRMP11292000HRMP.270.1.bkp", parms="" ORA-27006: sbtremove returned error Additional information: 4110 Additional information: 1 I had the dba open this as a problem to Oracle and this was their response: *** These types of errors deal with linking problems of the MML. Note:1062184.6 Circulation: PUBLISHED (EXTERNAL) Folder: server.Rdbms.Recovery.RMan Topic: Reference Articles Title: ORA-19506: FAILED TO CREATE SEQUENTIAL FILE, USING ADSM TO BACKUP TO TAPE. A search on metalink will retrieve some bulletins on some well known linking issues with various MML providers (Veritas, Legato, etc..), and those are typically useful but somewhat generic. Oracle Supports Rman's ability to successfully backup to disk. If there exists a problem backing up to tape the MML vendor should be contacted fot those issues. I called the ct to discuss the issue. They have been successfully backing up to tape for months. This machine is logically divided up into several different logical nodes and the target and catalog reside on different nodes. So, this may be a linking issue (as is typical in this situation). The ct states that his libobk is linked to the one provided byt the vendor. He can contact them to ensure that it is linked correctly etc... * So they're claiming its a TYM issue. I'm able to backup a normal TSM client no problem. So I insist to the DBA's its in the RMAN setup which I have no control over and he doesn't know very well. anyone? - Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products.
Oracle/rman tdp failing
hi, What is your oracle level? Which platform are you running on? What is your TDPO level? Please look for sbtio.log in all the sub-directories under $ORACLE_HOME. Is there any error message in it? regards, Thiha Can anyone help with the error messages I'm grtiing from my oracle dba's attempt to run Rman backups tiot tsm uping the TDP. ORA-19506: failed to create sequential file, name ="HRMP11292000HRMP.270.1.bkp", parms="" ORA-27006: sbtremove returned error Additional information: 4110 Additional information: 1
Oracle/rman tdp failing
Can anyone help with the error messages I'm grtiing from my oracle dba's attempt to run Rman backups tiot tsm uping the TDP. ORA-19506: failed to create sequential file, name="HRMP11292000HRMP.270.1.bkp", parms="" ORA-27006: sbtremove returned error Additional information: 4110 Additional information: 1 I had the dba open this as a problem to Oracle and this was their response: *** These types of errors deal with linking problems of the MML. Note:1062184.6 Circulation: PUBLISHED (EXTERNAL) Folder: server.Rdbms.Recovery.RMan Topic: Reference Articles Title: ORA-19506: FAILED TO CREATE SEQUENTIAL FILE, USING ADSM TO BACKUP TO TAPE. A search on metalink will retrieve some bulletins on some well known linking issues with various MML providers (Veritas, Legato, etc..), and those are typically useful but somewhat generic. Oracle Supports Rman's ability to successfully backup to disk. If there exists a problem backing up to tape the MML vendor should be contacted fot those issues. I called the ct to discuss the issue. They have been successfully backing up to tape for months. This machine is logically divided up into several different logical nodes and the target and catalog reside on different nodes. So, this may be a linking issue (as is typical in this situation). The ct states that his libobk is linked to the one provided byt the vendor. He can contact them to ensure that it is linked correctly etc... * So they're claiming its a TYM issue. I'm able to backup a normal TSM client no problem. So I insist to the DBA's its in the RMAN setup which I have no control over and he doesn't know very well. anyone? - Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products.
Re: Oracle/rman tdp failing
What level of Oracle are you running. If it is 8.0.5 or 8.0.6 you can try running the makefile again to relink the library file. If it is 8.1.5 or 8.1.6, check to make sure the symbolic link in the Oracle path points to the library file in the TSM path. find / -name libobk.a -exec ls -l {} \; Will search for all the libobk.a so that you can see if a wrong library file is being used. What level of TDP for Oracle are you using? If in the Rman script you specify DSMO_DEBUG=49, you will generate a file orcagent.log which is fairly easy to read. You may spot the error there. Also check for a dsierror.log being generated. And of course check the ADSM activity log to see if a sesssion was opened on the ADSM server. James Thompson From: James Healy [EMAIL PROTECTED] Reply-To: "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Oracle/rman tdp failing Date: Fri, 1 Dec 2000 09:25:03 -0800 Can anyone help with the error messages I'm grtiing from my oracle dba's attempt to run Rman backups tiot tsm uping the TDP. ORA-19506: failed to create sequential file, name="HRMP11292000HRMP.270.1.bkp", parms="" ORA-27006: sbtremove returned error Additional information: 4110 Additional information: 1 I had the dba open this as a problem to Oracle and this was their response: *** These types of errors deal with linking problems of the MML. Note:1062184.6 Circulation: PUBLISHED (EXTERNAL) Folder: server.Rdbms.Recovery.RMan Topic: Reference Articles Title: ORA-19506: FAILED TO CREATE SEQUENTIAL FILE, USING ADSM TO BACKUP TO TAPE. A search on metalink will retrieve some bulletins on some well known linking issues with various MML providers (Veritas, Legato, etc..), and those are typically useful but somewhat generic. Oracle Supports Rman's ability to successfully backup to disk. If there exists a problem backing up to tape the MML vendor should be contacted fot those issues. I called the ct to discuss the issue. They have been successfully backing up to tape for months. This machine is logically divided up into several different logical nodes and the target and catalog reside on different nodes. So, this may be a linking issue (as is typical in this situation). The ct states that his libobk is linked to the one provided byt the vendor. He can contact them to ensure that it is linked correctly etc... * So they're claiming its a TYM issue. I'm able to backup a normal TSM client no problem. So I insist to the DBA's its in the RMAN setup which I have no control over and he doesn't know very well. anyone? - Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. _ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com