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 <bkupmstr AT YAHOO DOT COM>
Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
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