TDP for Oracle

hi Geoff, We don't have it planned in the near future. regards, Thiha Date:Wed, 18 Apr 2001 11:22:45 -0700 From:"Gill, Geoffrey L." <[EMAIL PROTECTED]> Subject: TDP for Oracle Does anyone know if TDP for Oracle on True64 is in the works, and if it is a projected release date? Geoff Gi

TDP for Oracle

hi Geoff, We are looking into it. Thanks for the suggestion. regards, Thiha >What about Linux? Is there plans for TDP for Oracle on Linux? >This would be extremely useful, especially since Linux is now a >tier one platform for Oracle. >hi Geoff, > >We don't have it planned in the near future

TDP for ORacle 8i for SUN solaris 2.7 64 bits

Yes, it does. regards, Thiha Date:Fri, 20 Apr 2001 20:33:19 +0800 From:Shen Ou <[EMAIL PROTECTED]> Subject: TDP for ORacle 8i for SUN solaris 2.7 64 bits Can Tivoli Data Protection for Oracle support Oracle 8i (64 bits) on SUN Solaris 2.7 ? Thanks Shen Ou E_mail:[EMAIL PROTECTE

TDP (TDPO 2.1.10) for Oracle 8.1.7 ( 64 Bit) on HPUX 11

hi, TDPO 2.1.10 doesn't support 64 bit on HPUX. We have just released a new release TDPO 2.2 which support 64bit on HPUX. regards, Thiha My Environment: Server -- TSM Version 3.7.4.0 OS : AIX 4.3.2 Client -- Objects Version

How to get detailed Informations from API backups

hi Clemens, It depends on the application using the API. TDPO 2.1 doesn't send such information to the TSM server. There is nothing you can do to see information like what b/a client sent to the server. We've just released TDPO 2.2 which sends some information like what you are looking for.

TSM / Oracle backup problem

hi, Errno 41 from TDP means you have exceeded the maxmimum mount point allowed for your node on the server. Check to see what is the value for "Maximum Mount Points Allowed" for your node on the server by issuing 'q node SSRSPSFP1-ORA f=d' from admin command line. Don't start more sessions than

Re: Question about TDP for Oracle 2.2.0

hi Michael, If you don't have $ORACLE_HOME/lib64, you do not have oracle 64 bit installed. You can issue the command 'file $ORACLE_HOME/bin/oracle' to see if your oracle is 32 bit or 64 bit. Make sure not to link $ORACLE_HOME/lib/libobk.sl to /usr/lib/pa20_64/libobk.sl. regards, Thiha Hi Ne

Upgrade: ADSM 3.1 to TSM 4.1 & Peripheral Software Pre-req Level s

hi, The following responses are related to TDP for Oracle. You have reference to TDP for Oracle 2.2.1. We just released a new TDPO V2.2. Where do you see TDPO V2.2.1? regards, Thiha xx Jupiter: From: ADSMConne

TDP for Oracle

hi, You can take a look at what's new chapter in the user manual. http://www.tivoli.com/support/public/Prodman/public_manuals/storage_mgr/admanual.htm#optional regards, Thiha Hi *SM-ers! We currently use TDP for Oracle 2.1.10 and I saw that version 2.2 is available. I would like to know the

RMAN 806 and TDPO

hi, >allocate channel t1 type 'sbt_tape' parms 'ENV=(DSMO_AVG_SIZE=1000, >DSMI_ORC_CONFIG=/usr/tivoli/tsm/client/api/bin/dsm.sys, >DSMI_LOG=/home/gpfadm/backup,DSMO_NODE=entreprise2)'; I don't know why the error log said password file cannot be read. According to you it's there. The on

TSM/TDP on AIX4.1.5

hi Wang lei, AIX 4.1.5 is not a support level of AIX and so is Oracle7. AIX 4.3.2 and O8.0.5 is supported. The latest TDPO available is 2.2. regards, Thiha Date:Wed, 13 Jun 2001 11:52:13 +0800 From:Lei L Wang <[EMAIL PROTECTED]> Subject: TSM/TDP on AIX4.1.5 Hi all, my customer has

How to setup Oracle backup

hi Ming Lau, I have never used cron to schedule a TDPO backup. But if you look at the user manual where it talks about scheduling backups using TSM scheduler, you will see some example scripts. You can basically invoke these scripts through cron. regards, Thiha Date:Tue, 12 Jun 2001 17:3

TDP-Oracle 2.2 Unix

hi, You might want to make sure which option file you are using. Please use tdpoconf to find out options and their values that you are using. regards, Thiha Hy all, we are trying to set up TDP for Oracle 2.2 on a HP-UX box. We do not manage to assign a separate managment class to the filespa

Oracle Question

hi, You can issue server sql commands to see the information you want. The commands will work for any kind of backup, not only for Oracle. > select * from backups where node_name='your-nodename-in-cap-letters' AND filespace_name='your-file-space-name-as-it-is' another command: > select * from

SQL-BACKTRACK & ORACLE

hi, >Our oracle DBA claims that 'hot' incremental backups of Oracle takes as = >long as 'hot' full backups using SQL-BACKTRACK. Instead he does weekly = >full 'hot' backups of the database and backups of the redo logs thru the = >week. >Is that how others using SQL-BACKTRACK and ORACLE do thier

Re: ADSM-L Digest - 15 Aug 2001 to 16 Aug 2001 (#2001-224)

hi, You can also use TSM API sample program to expire the objects. It's installed in /usr/tivoli/tsm/client/api/bin/sample. You will have to run the make file: make -f makeapi.aix. The executable name is dapismp. Define DSMI_DIR, and DSMI_CONFIG env vars before starting the executable. You wi

RMAN and Resetlogs

hi, Try the following. That's a suggestion from Oracle. You can perform join on RC_BACKUP_PIECE and RC_DATABASE_INCARNATION to get backup pieces for all incarnation. Likewise, for archivelogs of all incarnations use RC_ARCHIVED_LOG. regards, Thiha >Hello everybody, >I'm saving an Orac

TDP for Oracle on AIX

hi, It is OK to use b/a client and TDPs on the same box. We recommend to use a different node name for TDP backups. regards, Thiha >On a AIX client already TSM software is installed. FileSystem backups >scheduled by the server on OS/390 runs just fine. >Now this AIX has TDP for Oracle install

TDP Support on Oracle8.1.7

hi Eric, We support O8.1.7 on available platforms. We are in the process of updating the web pages. regards, Thiha >Is there a plan on Tivoli Data Protection for Oracle (AIX, HP-UX, Sun >Solaris & NT) to support Oracle8.1.7. >If so what is the requirement and planned available date. Thanks.

TDP for ORACLE on NT - ANS0113E

hi, Which TDPO level do you have? The latest available now is 2.1.10. I would use the latest one. I think, the problem you are running into is because of TSM API level and its message file level are out of sync. Older level of agent uses message file out of its installation directory. One qu

TDP for ORACLE on SOLARIS.

hi, There was an APAR (IC27695) opened against TDPO. If there is 'dirmc' option entry defined in your dsm.sys file, TSM API core dump. It is fixed in the PTF coming out very soon. So if you have that entry in your dsm.sys, just removing it will work fine. If you don't have that entry, make su

TDP for Oracle Question

hi, Are you talking about tablespace or table restore? I don't really think that you can backup/restore at the table level. TDPO doesn't support table level backup/restore. regards, Thiha >Does anybody know if the TDP for Oracle agent >can perform table level restores? I have a >customer wh

Flashcopy support in next TDP agent for Oracle

hi, Yes, it will be. regards, Thiha >I just saw the announcement for the next release of the Oracle TDP = >supporting Flashcopy on the ESS server. >In our shop we use the TDP for MS-SQL, but for Oracle we use SQL-BACKTRACK.= > The primary reason for this is that the TDP agent requires configur

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 attemp

Install problem with TDP for Oracle on Solaris

hi, If the TDPO manual says libobk.a for Solaris, it's the problem with the manual. Library suppose to be libobk.so. To link it with Oracle 8.0.x - shutdown all the oracle instances including listeners - make sure there is no libobk.* in any directory under $ORACLE_HOME - from $ORACLE_HOME/

HPUX11 tsm client 3.7.2 message in dsmerror.log

hi Eric, Oracle connect agent 2.1.10 works with TSM 3.7.1 API only. I think you have V3.7.2 b/a client, image library (libPiIMG.sl), and V3.7.1 API installed on your machine. Image library needs API level (3.7.2) to be loaded successfully. That might be the reason that you are seeing the error

TDP for Oracle on SUN

hi, There is a problem with Oracle 8.1.6 on Sun. We've opened an Info APAR (II12668) for this problem. I am sure you are running into situation #1 described in the APAR. APAR text is as follow: ERROR DESCRIPTION: The Tivoli Data Protection for Oracle - Comp ID: 5698DPOCL . W

Re: HPUX11 tsm client 3.7.2 message in dsmerror.log

hi Eric, For now, you cannot use TDPO and Image utility together at 3.7.2 level. We are working on the solution. regards, Thiha >Yes, I have installed HP TDP Oracle v2.1.10 and according to APAR IC27223 >replaced v3.7.2 libApiDS.sl with a v3.7.1 libApiDS.sl. >Yesterday I found that dsmc works

TDP for ORACLE restores

hi Bruce, Your setup for TDPO seems to be fine. Just want to add something to do for RMAN. On location B: % rman RMAN> connect target RMAN> connect rcvcat RMAN> restore controlfile RMAN> sql 'alter database mount' RMAN> restore database RMAN> recover database Of course you will have to alloc

Orphaned Oracle backups

hi, Yes, that happens a lot. Oracle had a bug that it deleted the backups from the catalog database even we returned error to them. I don't exactly remember which Oracle level. Other factors are how you set up your management class, copy groups and whether your node has backup delete access or

Orphaned Oracle backups

hi, So far that's the only way you can delete them. We are working on a tool which will help you delete these orphaned oracle backups. regards, Thiha >How do you recommend cleaning up the problem? >Is using the (unsupported) DELETE OBJECT command the only way?

questions about TDP for Oracle

hi, You will have to setup the scheduler on the machine that you want to backup. You will need two schedulers to backup both RMAN DB and Oracle DB. We don't support Solaris on Intel hardware. Machine requirement varies on the level of Oracle you are installing. You might want to refer to Oracl

RMAN ADSM Errors

hi, When you do incremental backup, Oracle has to scan through the data block to figure out which blocks are changed. If there isn't much change in the database, it takes a while until Oracle finds some changed blocks. On TSM server, if your commtimeout value is set to a low value, and your ses

TDP for Oracle license

hi, Yes, you will need client license file. regards, Thiha >I've registered the server license for TDP for Oracle. Is there also a >client license? >The DBA's haven't been able to get the RMAN script to connect to the TSM >server. They called Oracle and Oracle said the TDP for Oracle must b

TDP for ORACLE restores

hi, Assuming that you have the DSMO_NODE and password file setup correctly, startup no mount database on the second node. % rman RMAN> connect target RMAN> connect rcvcat RMAN> allocate channel... # with correct env vars RMAN> restore controlfile RMAN> sql 'alter database mount' RMAN> restore

TDP oracle

hi, The file space that got created for TDPO backup is only virtual. So there is no way to find out the capacity and pct util. regards, Thiha >When I use TDP for Oracle the backup completes OK. >But when I issue the command >query filespace >TSM tells me the following: >Node Name

Re: RMAN ADSM Errors

e downside of having a huge COMMTIMEOUT? On Mon, 29 Jan 2001 09:53:20 -0800, Thiha Than <[EMAIL PROTECTED]> replied to me: > >Subject: RMAN ADSM Errors > >hi, > >When you do incremental backup, Oracle has to scan through the data block >to figure out which block

Oracle 8.1.7 support

hi, Yes, TDPO works with Oracle 8.1.7. We will be updating the support page soon. regards, Thiha >My DBAs tell me that Oracle has announced end of service for Oracle 8.1.6 = >in October. >Thus they are keen to start rolling out Oracle 8.1.7 across our myriad = >apps. >The Tivoli Web site stat

redirecting node backup

I am sending this for Cai Lam since she lost access to the list. regards, Thiha Hi, You need to define the following before setting up the mgmclass: 1. Define tape device class. 2. Create the tape storage pool. 3 Create a copy group. 4. Activate the copy group, set the mgmclass which is using

Re: TDP Oracle 2.1.10 'libobk.so' problems on Oracle 8.1.7 / Solaris 2.7

hi, Please use TSM 4.1.2.12 API 32 bit not 64 bit. Your problem should be fixed by doing so. regards, Thiha To: [EMAIL PROTECTED] cc: Subject:TDP Oracle 2.1.10 'libobk.so' problems on Oracle 8.1.7 / Solaris 2.7 We have the following configuration (all on same Sun Ultra server ha

Re: include.encrypt statements with TDP

hi, include.encription is not supported by TSM API. So it will not work for any TDP. regards, Thiha Date:Sat, 23 Feb 2002 00:15:14 -0500 From:"Seay, Paul" <[EMAIL PROTECTED]> Subject: Re: include.encrypt statements with TDP I cannot find any reason why the inclexcl dsm.sys cannot have

Re: ADSM-L Digest - 29 Aug 2001 to 30 Aug 2001 (#2001-237)

hi, Error 2400 indicates that you don't have a license file or a valid license file. What is your TDPO level? Backup scripts vary depending on your TDPO and Oracle level. In general, run { # for TDPO 2.1.x allocate channel t1 type 'sbt_tape' parms 'ENV=(DSMI_CONFIG=/home/oracle/dsm.o

Re: Oracle Backup Error

hi, Can you give me more information about your setup and environment? - how the scheduler is setup - your backup script - TSM, TDPO, Oracle levels If you run RMAN backup by itself, does it work? Is there any dsierror.log under $ORACLE_HOME/dbs? regards, Thiha Date:Thu, 30 Aug 2001 11

TDP for Oracle question

hi, Yes it should. But I recommend using 2.1.10 (fixtest 1). You can download it from ftp://service.boulder.ibm.com/storage/tivoli-storage-management/patches/tivoli-data-protection/oracle regards, Thiha >Does anyone know if Oracle 8.1.7 works with TDP for Oracle v2.1.9. >Tia

Management class and TDP for Oracle with RMAN

hi, You can use 'include' option to bind with different management class. It is documented on page 36 of the user manual. But you will have to do a little bit differently than what is documented. I assume that you are using different domain for your TDPO backups. Let's say your default mgmt c

question about TDP for Oracle/RMAN vs. BMC's SQL BackTrack "dry run"

hi, You can use a RMAN command 'validate'. Please see RMAN reference manual to find out more about validate command. regards, Thiha >does anyone know whether TDPO v2.2 allows for "dry run" restores &/or a >preview of a restore to validate the media without writing the data, like >SBT does? (I

Solaris, RMAN and TIVOLI

hi, When you run RMAN backup/restore RMAN looks for a library named libobk.so which got installed when you install TDPO. TDPO uses TSM API to connect to TSM server to send/receive data. > Does RMAN write directly to tape when it is doing a backup? This depends on how you setup your policy for

Management class and TDP for Oracle with RMAN

hi Vicente, Please try to shorten the mgmt class name like Phillip has suggested. If still doesn't work, 1. please turn on the API tracing. Use api and api_detail flags and get me the trace file. 2. please get the output of your copy group values of all the mgmt class in your domain that yo

Management class and TDP for Oracle with RMAN

hi Vicente, After reviewing the information you gave again, I think I found the problem. Your archive log format is '%d_arch_%U' and in your include statement you are matching only '*.arc'. Your include statement should look like: include /adsmorc/.../*arch* regards, Thiha >> INCLEXCL >> i

error validating inserts - agent.lic ?

hi, >by the way, do you know what the agent.lic file is for, in the directory >/usr/tivoli/tsm/client/oracle/bin ? agent.lic is TDPO client license file. Lower level servers don't have server side licensing. We use that file to verify on the client side. TDPO will not run without a valid agent

TDP for oracle maintenance

hi, There are so many ways to delete the backup piece from RMAN. First, use RMAN 'list' command to find out which backup pieces you want to delete. Then you will have to use 'change ... delete' command. These commands are documented in Rman Reference Guide. You can download it from Oracle web

Etherchannel and EBU backups.

hi Eric, I am not sure whether it's feasible or not because I don't know how etherchannel works. Is data going to go through four etherchannels because you start four sessions? If so, your implementation might work. Make sure not to start more sessions than your max mount point for your node on

TDPOracle v2.2 HPUX problem

hi Matt, BACKUP_DIR not set is issued by Oracle internal library. Your oracle is still linked with Oracle internal disk library. Please perform the steps described in the manual to re-link oracle with TDPO. http://www.tivoli.com/support/public/Prodman/public_manuals/storage_mgr/admanual.htm#op

Need help... got error from tdp oracle

hi Thida, If your commtimeout value on TSM server is 60 (seconds), it's too low. Yes it might work for b/a client type of backups not with TDPO. RMAN doesn't backup NULL blocks. So it takes time for RMAN to scan through the Oracle data block to gather data. Increasing commtimeout value doesn't

Need help... got error from tdp oracle

hi Thida, commtimeout value 600 is not a recommended value but it seems to work for most of the customers. I've seen some customers set it to much higher values. It all depends on how full your database is. If it has a lot of NULL blocks, 600 might not be enough. If you are performing increm

rman question

hi, Try using 'filesperset' option in your backup script. regards, Thiha >I use tdp for oracle 2.2 on a tsm4.2 server >I allocate 2 channels for the rman backup, t1 and t2 >when the backup starts, it initially starts to write to 2 tapes. >After a short while, on

oracle backup(linux)

hi, I am not sure where you got the information about TDPO for Linux availability in first half of 2002. We are planning for it but don't count on having it in the first half of 2002. regards, Thiha >I just recently spoke with my IBM rep on this, and the word I got >back that, although there a

NT TDP for Oracle 2.2

hi, Try using 'filesperset' parameter in your backup script. regards, Thiha >Is anybody who is running this TDP having verrry slow performance? Less >than 1 MB/Sec? We ftp'd a file from the client to the TSM server and got >10MB/sec throughput.

Oracle EBU fails on same file

hi, >We use Oracle EBU and it's always failing on the same file with message id >EBU-7009 (see log excerpt below). The file is 1660MB in size (quite >large), but our TSM disk storage pool is configured with no size limit. >Oracle says EBU-7xxx errors are relayed from the underlying backup system

Problem when using API

hi, Since the backups are done using V3.7.1 API, you must use the V3.7.1 API Sample program also. Can you query the objects? Make sure that query is fine before deleting. regards, Thiha >I can compile the API (v.3.1.0.6) now. But I can compile the API (v3.7.1.0). >Error as describe before. >

Oracle EBU fails on same file

hi, V2.1.7 has some problems. Please download the fixtest 2.1.7C or D. It will be the best if you use 2.1.10 latest fix test. But if you move to 2.1.10 it will require you to move your API to higher level also. regards, Thiha >"what /usr/lib/libobk.a" shows the following: >ADSM Oracle API li

TDP for Oracle 2.2 poor restore performance.

hi, It's hard to say why the restore is slow. Also it's hard to say whether Oracle or TSM or both are causing the problem. I would recommend to turn on TSM API tracing and look for dsmGetData() Entry, Exit trace points. Check the time spent between each entry, exit point. If you are seeing big

How to rename a primary pool used by TDP for Oracle?

hi, >my next problem is related to the TDP for Oracle Backup on AIX. I'm trying to >rename the primary pool for the Oracle backups. The old name ist ADSMORC (the >default, afaik). I set up the new name on the TSM server and changed the >variable DSMO_FS accordingly. TDP generates the following e

TDP for Oracle 2.2 for NT - orasbt.dll not found

hi, >has anybody succeedeed to get running TDPO 2.2 on Windows NT? >The connections to the TSM-Server (4.1), i.e. tdpoconf showenv works. >But Oracle uses the dummy API instead of the TSM agent (Warning: Oracle >Test Disk API) if I try to allocate a channel of type sbt_tape. >Obviously Oracle ca

Re: TDPO 2.2 some undesirable behaviour.

hi, >Has anyone seen the following behviour with their sbtio.log under Solaris and TDP for Oracle V2.2. I cant find >anything on Tivoli's Knowledge base.. >Any hints/tip are welcome > the sbtio.log is according to the RMAN documentation the 3rd Party media management log file, and contai

TDP for ORACLE 2.2 on NT - ANS0238E Pls HELP

hi, >we installed and configured TDP 2.2 for ORACLE on NT 4 SP6. We can do >backups but we are getting errors when we try to delete them via an RMAN >"change backuppiece ( or set ) x delete". The piece/set is deleted from the >RMAN catalog but when trying to delete withon TSM errors ANS0228E come

TDP for ORACLE on True64???

hi, >Has Tivoli thought of coming out with a TDP for Oracle on True64 Unix yet? >Anyone else have this configuration or am I the only one? Who can we put >pressure on for this to get done? What good is a SAN when 90% of the data >out there would come back across the network because there is no TD

Problems with TDPO_OPTFILE

hi, >I can't set TDPO_OPTFILE to any other value than tdpo.opt in the default >installation directory, because values like TDPO_NODE etc. are not >recognized. I work with AIX V4.3.3 both TSM server and client, TSM Server >V4.1 and TDP for Oracle V2.2.Can anybody help me? Thanks a lot! I don't q

Tool for ADSM Connect Agent

hi, >Does anybody know a tool for ADSM Connect Agent V2.1 similar to the tdposync >utility of TDP V2.2? Thanks in advance. No, there isn't one. regards, Thiha

API / Client compatible?

hi, >There are many messages on the list referring to the (in)compatibilities >between the api, and the gui. Some refer to needing the same version. >Can anyone answer the question definitively; Is the api compatible with >the gui client? GUI uses API only for image backup on (AIX, Solaris, HP-

ANS0237E TDP for Oracle for Windows

hi, >ANS0237E (RC2033) On dsmInit, the node is not allowed when PASSWORDACCESS=generate. >STOP OUTPUT FROM tdpoconf showenv Please remove TDPO_NODE from tdpo.opt file. You are suppose to use 'nodename' from dsm.opt file not TDPO_NODE to use a different node name. regards, Thiha

TDP Oracle 2.2 with SAP R/3 on HP-UX

hi, >We are trying to use TDP Oracle 2.2 with SAP R/3 4.5 on HP-UX 11.0 and >Oracle 8.0.6. >I know this is not the recommended configuration... we will probably look >at TDP for R/3 next year. In the meantime, our SAP Basis team wants to get >familiar with RMAN, so we're trying TDPO. >The prob

signon failed rc 2230

hi, >We are having large troubles getting our TDP for Oracle on a SUN SOLARIS >running: > Platform: SUN SOLARIS > Client OS Level: 5.6 >Client Version: Version 4, Release 1, Level 2.0 >When we run the aobpswd we get the following message : >si