Oracle Schema backup

Hi, TSMers, Has any one had an experience on backing up a particular schema using RMAN script through TSM scheduler? and also, can any one give an insight of pro and con of running Oracle backup scripts from crontab (AIX) vs. TSM scheduler? Regards, Jin Bae Chi (Gus) Data Center 614-287-2496

Re: TSM client problem with backups using international characters

Hi This problem was solved in the 4.2 client. However, after testing the 5.1 client, I'd suggest that you use this one instead. Should be no problems using 5.1 client against 4.X TSM server. Best Regards Daniel Sparrman --- Daniel Sparrman Exist i Stockholm

Re: Expire data on a server that doesnt exist any longer.

Thanks for your answers. It seems like I miss something here. I copied the domain and updated/validated/activated the policy set and updated the node. When I do a 'dsmc incr' with a modified dsm.opt (NodeName xyz and Exclude E:\...\*) on a different node, STO-LN02, I only backup STO-LN02´s

Re: Bare Metal Restore for TSM

Hi There are two different BMR products for TSM: 1. TKG Bare Metal Restore - Supports Windows NT/2000, AIX, Solaris and HP/UX. - Uses TSM backup/restore client - Requires a UNIX box for the server software. - Can boot from CD or diskett 2. Cristie PC Bax Disaster Recovery - Support Windows NT

Re: Expire data on a server that doesnt exist any longer.

Hi The q fi xyz doesn't show data stored on the backupserver, only the filespaces, and how much each filespace is utilized. Try running a q occ xyz, this will show you how much space each filespace (sto-ln02\e$, xyz\c$ and xyz\e$) takes up on the backupserver. The table you're showing below,

Re: Expire data on a server that doesnt exist any longer.

Hi, What I´m trying to do is to get rid of xyz´s extra version since that is a node that doesnt exist anymore. And let the node expire away. I dont want to delete the filespace. //Henrik

Re: File system not ready.

Hi Christian! The first thing you should do is upgrade to at least 4.2.2.0. If you still receive this error you could check the permissions on the root of F: and X:. I have seen backups fail because the system account had no access to the drive root. Kindest regards, Eric van Loon KLM Royal Dutch

Re: Expire data on a server that doesnt exist any longer.

Henrik, expire inventory throws out versions that were inactive longer than the retention period defined in the domain/mgmtclass the node is defined in. When you want to change mgmtclass in your options for an object there is only a rebind possible for active objects at the next incremental

New Licensing Costs

All Following the change to Tivoli's licensing structure in May, our reseller prices have gone through the roof. I am hoping to determine whether or not we are being charged a 'similar' rate to everyone else. What do you get charged for NT backup clients and TDP for MSSQL backup clients? We

Please Verify..Bare Metal Restore for TSM

Daniel, I have spoken to TSM Tech Support both by phone and through this list serve. They have all said, TSM does not support BMR, nor did they or anyone else have options for this. How is it that you have come up with this information and no one else has? - What is your definition of

Re: Bare Metal Restore for TSM

Mephi, I have spoken with TSM Engineers and with those here on this list serve and a Engineer from TSM B-A Client team TSM has stated in that they do not support a BMR, however they do give restore steps that can be used in a disaster recovery way to obtain your system objects and file

Re: TSM and MS Exchange (MailBox Restore and Exchange 2000 Improv ements)

Actually, we are using Arcserve 2000 to backup Exchange5.5 on W2K member serves. We fought Arcserve for over 8 months to fix their agent and it looks like they have it 95% operational and tolerable. We are seeing through=put speeds of up to 100mb/minute. We are backing up servers with

Re: Expire data on a server that doesnt exist any longer.

Henrik, TSM will do this for you, it just takes time. Let's assume your copy group settings are as such - Ver Exist - 7 Ver Deleted - 7 Retain Extra - 60 Retain Only - 90 First rule is TSM will never delete the active versions of the data on you. It sounds like that's what you want, so

Re: Scheduled TSM Policy Will Not Run

Ken, A node can belong to only one policy domain at a time, and I definitely do not recommend bouncing a node between two policy domains. Since I do not know the rationale for creating the new policy domain with the BACKUP_DAVINCI_DAILY node, I can not advise you on the best course of action.

experience in DB Adm

Hi Last weekend we had a problem with DB capacity as follow : ANR0362W Database usage exceeds 98 % of its assigned capacity. ANR0131E dftxn.c838: Server DB space exhausted. ANR1181E dftxn.c200: Data storage transaction 0:424803852 was aborted. After this, the TSM server frozen and we

expire inventory question

Hi All Everyday I run the following command line : expire inventory skipdir=no duration=300 and the result is : ANR0812I Inventory file expiration process 582 completed:examined 229248 objects, deleting 1004 backup objects, 756 archive objects, 0 DB backup volumes, and 0 recovery plan files.

Re: experience in DB Adm

Hi Luciano, in order to expand capacity of your database, you must (after creating db volume) assign this new space to db with command: extend db 1000 Ing. Jozef Zatko Login a.s. Dlha 2, Stupava tel.: (421) (2) 60252618 Luciano Ariceto [EMAIL PROTECTED] Sent by: ADSM: Dist

sybase agent

Hi All, Are there any TSM Agents for Sybase available? Anyone using them, and if so, are they reliable? Thanks, Steve Roder, University at Buffalo HOD Service Coordinator VM Systems Programmer UNIX Systems Administrator (Solaris and AIX) TSM/ADSM Administrator ([EMAIL PROTECTED] |

Re: Bare Metal Restore for TSM

Hi Tony It's true that TSM itself does not have a real BMR capability (what a shame!) and thus it is probably correct when the TSM folks you have spoken to say that they do not 'support' a BMR method, but instead refer you to a description of some procedures to follow if you have to do a BMR on

Re: experience in DB Adm

If you do a q db then you will see a line that shows the Maximum Extension then just do an extend db number with the number being a number the same size or smaller then the available space in the extension column. -Original Message- From: Luciano Ariceto [mailto:[EMAIL PROTECTED]] Sent:

Re: experience in DB Adm

You must extend the database capacity. help extend db for more info. At 10:05 AM 7/18/2002 -0300, you wrote: Hi Last weekend we had a problem with DB capacity as follow : ANR0362W Database usage exceeds 98 % of its assigned capacity. ANR0131E dftxn.c838: Server DB space exhausted. ANR1181E

Re: TSM 5.1 Performance Tuning Guide - Where?

Hmm, that tunig one db is much like tuning another is not really surprising, right. Want to know why, it's all more: memory, spindles and last cpu, it's all about separating recovery log and database (and indices). This does not mean the tsm db is anything like db2, it most likely isn't since

Re: Solaris client

On maandag, juli 15, 2002, at 10:48 , Mark Stapleton wrote: From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Gill, Geoffrey L. Can anyone relate this extremely slow backup to any issues they know about TSM or Solaris. The client has 10GB of data, the first 2GB of which

Re: sybase agent

We're quite satisfied with SQL-Backtrack as a product. It's easy to install and use for SYBASE. Not so thrilled with BMC though. At 09:22 AM 7/18/2002 -0400, you wrote: Hi All, Are there any TSM Agents for Sybase available? Anyone using them, and if so, are they reliable? Thanks,

Re: Please Verify..Bare Metal Restore for TSM

Hi Tony Don't know who you have been talking to at Tivoli Client Support(I guess, as this has nothing to do with server version). To clarify some things: 1. Yes, there is supported BMR products for Tivoli. However, as theese products are not produced by Tivoli, Tivoli has no support

Re: New Licensing Costs

Hi Theese prices seems correct. The problem is, that a month(or two) ago, Tivoli changed it's pricing again. Best Regards Daniel Sparrman --- Daniel Sparrman Exist i Stockholm AB Propellervägen 6B 183 62 HÄGERNÄS Växel: 08 - 754 98 00 Mobil: 070 -

TDP for Lotus Domino : bufffer settings ?

HI, Can anyone tell me what the optimal settings are for the number of buffers and their size for 'TDP for Lotus Domino' clients ? I think the default settings are 3 buffers with size 1024 Can backup speed be improved by re-setting this default to another value ? Can backup sped be improved by

performace problem in restore stg pool from an other server

Hi, Environment: we have 2 servers TSM (TSMSCI and TSMSEC) running on 2 aix machines with aix 5.1.0.0-ML01 (32bits) and using 2 libraries 3584 with LTO SCSI drives. TSM server version is 4.2.2.4. The 2 machines have a dedicated network to communicate and use ethernet 100 full duplex. . Problem

Re: TDP Lotus Domino

Shannon, Our TDP Lotus Domino backup is about 20GB daily; and it is direct to tape, which is colocated. Colocated is best because data on tapes expire at a rapid rate(depending on your retention policy), and very little reclamation process time is required to bring tapes back to scratch. Bill

Re: Please Verify..Bare Metal Restore for TSM

Consiglio, Tony wrote: Daniel, I have spoken to TSM Tech Support both by phone and through this list serve. They have all said, TSM does not support BMR, nor did they or anyone else have options for this. How is it that you have come up with this information and no one else has? - What

Re: Bare Metal Restore for TSM

Good luck! Ever since Veritas bought The Kernel Group development for the product integration with TSM died, it's now being used with their offering. Myself and many others in the San Francisco bay area are concerned with IBM's marketing strategy in some key points such as bare-metal restore

Set access problems after export/import

Here is the scenario : Client : AIX 4.3.3 TSM 4.2.1.21 Server : Z/OS TSM 4.2.1.15 - An archive is created on client1 to server1 with user1 - A set access command is done to give access to user2 to the files - server1 exports the archive - server2 imports the archive - user2 on client2 tries to

Restore TDP Domino data cross-platform??

I had a client ask me this. They are running Domino on S/390 which runs as a USS application. They use the TDP agent to backup the databases and archive logs. What he would like to do is to have a single NT/2K box available to restore databases to instead of the production LPAR(s). He says that

Re: New Licensing Costs

Andrew, I hope I'm reading this wrong -- but if I'm not, SOMEONE is doing a very good job of price gouging. You're talking the vanilla, standard, downloadable TSM NT client at four hundred fifty pounds Sterling? The client that was one hundred dollars US in version 2? And (while we *never* got a

Server-to-Server DB backup and recovery

We are working on setting up multiple TSM servers at offsite locations, to DR type processing. We plan to do server-to-server to handle both the DB backup and COPY POOLS. My question is (I have been digging through the manuals but haven't found a clear answer): Lets say the SOURCE SERVER

Re: Temporary Backup

Hey Jack- Just a thought. Why not just do an archive then delete the data when you are finished? Greg A. Garrison Account Storage Manager IBM Global Services, Service Delivery Center - West 9022 S. Rita Road, Rm 2785, Tucson, AZ 85744 Phone (520) 799-5429 Internal 321-5429 Pager 800-946-4646

how does sun communicate with lmcpd to access atl mgr?

I have a sun box running solaris 8 connected via fibre to an atl 3494. I've installed the IBMtape driver, the lmcpd driver and configured the /usr/kernel/drv/IBMtape.conf and the /etc/ibmatl.conf. In /var/log/lmcpd_atl.log, I show 8 to 10 lines similar to AF_INET xxx call ok, fd 1 and

Help with select statement

Hello - I wrote the following select statement (with a lot of plagiarism). /* --- Query Summary Table */ select cast(entity as varchar(12)) as Node Name, \ cast(activity as varchar(10)) as Type, \ cast(affected as decimal(7,0)) as files, \ cast(bytes/1024/1024 as decimal(12,4)) as Phy_MB \

Re: Bare Metal Restore for TSM

I have some documents on BMR for TSM (User Guide) etc. If you interested ao this document, send me a note. Philippe Joshua S. Bassi [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 18/07/2002 01:24 PM Please respond to ADSM: Dist Stor Manager To: [EMAIL

Re: Restore TDP Domino data cross-platform??

I had a client ask me this. They are running Domino on S/390 which runs as a USS application. They use the TDP agent to backup the databases and archive logs. What he would like to do is to have a single NT/2K box available to restore databases to instead of the production LPAR(s). He says

adic scalar 100

Guys, I recently emailed the list asking if the scalar 100 was supported under aix 4.3.3 and in tsm 4.2 and the response was yes. I have yet to see it work in our current environment. The drives are detected correctly (rmt0, rmt1) but the autoloader is not detected (smc0). AIX doesnt see it,

Another TDP for Lotus Domino question

Shannon, To keep 5 weeks on DB backups, set your versions to 5 in the copy group for the management class used to back up the DB's. The full backups done weekly will keep track of the logs that belong to that full backup. When you back up the 6th time, the 1st backup will go away, and it's

Re: adic scalar 100

Rick, As I understand things (and have seen on my own system), the Atape.driver, smc devices, and rmt devices are all for IBM-brand equipment. To use other brands, you have to defind lb and mt devices using the adsmtape driver. You will still have the rmt devices because the drives answer

Re: Help with select statement

I'll take a stab: select cast(entity as varchar(12)) as Node Name, \ cast(activity as varchar(10)) as Type, \ sum(cast(affected as decimal(7,0))) as files, \ sum (cast(bytes/1024/1024 as decimal(12,4))) as Phy_MB \ from summary where end_time=timestamp(current_date -1 days, '09:00:00') \ and

Re: adic scalar 100

Thanks for the quick responses guys.. this helps me understand quite a bit more .. Would anyone have any idea how to use the lbtest tool or tapeutil to manipulate the library ?? I just need a simple test to confirm if this is working or not .. and yes Tab you were right about the whos on first

Problems with moving tapes OFFSITE

We currently have a problems with our TSM server in regards to ARCHIVE tapes which we store offsite. Today while trying to load some new scratch tapes into our Dell PowerVault 136T Library we got a error back saying the ANR8314E Library ATL is full. Our library can physically hold 72 tapes

Re: Problems with moving tapes OFFSITE

Gordon, The way to manage a full library is to use the move media command. This will mark the tapes as out of the library and optionally record where they are. Take a look at the admin guide section on managing a full library. Ring me if you get stuck Steve Harris AIX and TSM Admin

Re: how does sun communicate with lmcpd to access atl mgr?

Hi First, you should have a lmcpd daemon running. This is the daemon that communicats with the IBM 3494 ATL. Second, you should have a device called lmcpX (normally, you can self decide which number to use, for example lmcp0). Third, have you configured TSM to use the lcmp device as

Re: Bare Metal Restore for TSM

Hi I was in contact with Veritas only a few weeks ago, and I can insure you that they are still developing the product (and supporting it) for TSM. We've got two large customers running approx. 70 BMR clients, and I don't think Veritas is interested in making this customers unhappy. I also

Re: adic scalar 100

Rick, To use lbtest, run lbtest -d lib_name Ex. lbtest -d /dev/lb0 If the library is already defined to the TSM server, make sure that the server is not running.. Then select 1 for manual test.. In the manual test menu, select 6 to open the library 8 to get element count 9 to get library

Re: Problems with moving tapes OFFSITE

Thanks for the reply Mark, read below to answer some of your questions: You have several different issues here to deal with. First and foremost are you licensed to use DRM, it is a separate purchasable product. If you are then I highly recommend that you configure it and use it to its fullest.