Oracle 7.3.4 / 8.0.6 and TSM 5.2

Hi, I am very new to Tivoli having previously used Veritas Netbackup to perform all the backups of our many databases. Our servers our now being relocated and as such will now have to make use of Tivoli for their backup schedules. As I understand it TSM 5.2 can only be used to backup Oracle

Re: space in storage pool

to be absolutely sure run this query : select a.stgpool_name,a.maxscratch as MAX,count(b.volume_name) as USED from stgpools a,volumes b - where a.stgpool_name=b.stgpool_name and a.devclass!='DISK' - group by a.stgpool_name,b.stgpool_name,a.maxscratch okay ? - Original Message - From:

Re: Event Retention Period

If you want to go back 20 days you need to restore database backup that is 10 days old Then to go back 30 days you need another restore database backup that is 20 days old If you haven't got database backups that go back that far, you can't do it. Norita binti Hassan [EMAIL PROTECTED] Sent

Re: Oracle 7.3.4 / 8.0.6 and TSM 5.2

Hi, I at least see two ways of doing it; 1) Put tablespaces in backup mode and run the TSM backup on the file systems where the data files are, or 2) Use RMAN (at least for your 8.x.x instances) to disk, and then have TSM to backup the RMAN backup pieces (If you have a lot of extra disk space this

Re: Oracle 7.3.4 / 8.0.6 and TSM 5.2

Andreas, this was sort of the way I had thought of but I still have one problem and that is how to take the tablespaces out of backup mode after the backup has finished. With Netbackup there were 2 scripts which were used - one pre backup and one post backup - which made sure tha backups were

Re: space in storage pool

I've run that select statement.. and here it is tsm: TIVOLISVRselect a.stgpool_name,a.maxscratch as MAX,count(b.volume_name) as USED from stgpools a,volumes b where a.stgpool_name=b.stgpool_name and a.devclass!='DISK' group by a.stgpool_name,b.stgpool_name,a.maxscratch STGPOOL_NAME

Re: Oracle 7.3.4 / 8.0.6 and TSM 5.2

Mark, Well, TSM allows for pre-backup and post-backup scripts as well for a given stanza. But I still think a cron/TSM scheduled job executing a script that will put the tablespaces in backup mode, followed by executing the dsmc client locally, and then putting the tablespaces back in normal is a

Re: Query Contents

Terry, Yeah I realise that I will only get which volume is on which tapes. How ever what I can't do is get that information with out specifying a tape ID. I want to get information about all the tapes without having to specify maually a tape ID. So that I can run a command or query that will tell

TDP for SQL error

Hi *SM-ers! One of our SQL guys tries to backup his SQL node to our test server. Everything works fine when he uses our production server, but when he backs up to the test server he receives the following error: ANS1309W (RC9) Requested data is offline In the tdpsql.log I see the following

Volume sequence

Hi, Is there any select statement that can display the volume sequence number so that I can list all the volumes in sequence that has been used by specific node. NORITA BINTI HASAN Senior Programmer Enterprise Systems Services Information Communication Tech.Div 6th Floor, Pos Malaysia Berhad

Can't restore Exchange

Hi all, I use TDP for Mail ver 5.2.1 to backup Echange 2000. I implement : a.. restore system drive and system state. b.. reinstall Exchange using setup /Disaster Recovery c.. using TDP restore database. When restore mail server, i receive error message: ACN0151E Errors occurred while

Commands Issued

Hi experts, Is there any script for Solaris that I can schedule to identify the commands issued in Tivoli at regular intervals? Regards Akash

QUERY FILESPACE: No match found using this criteria

Hi, I dont get this logic when I do a 'q fi'. Anyone who knows what might be wrong or seen this before? I´m not doing anything else except q fi againt thoose filespaces. TSM 5.2.2.5 on w2k3. Thanks Henrik tsm: xq fi sto-tw01 Node Name Filespace FSID Platform Filespace

Re: QUERY FILESPACE: No match found using this criteria

Henrik, Add nametype=unicode at the end of the command line. tsm: xq fi sto-tw02 \\sto-tw02\c$ nametype=unicode Regards, Samiran Das -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Henrik Wahlstedt Sent: Wednesday, March 09, 2005 7:00 AM To:

Re: Commands Issued

On Mar 9, 2005, at 6:58 AM, Akash Jain wrote: Is there any script for Solaris that I can schedule to identify the commands issued in Tivoli at regular intervals? You need to explain more what you are trying to get... If you mean that you seek to report all the dsm* and like commands issued at the

Re: Volume sequence

you can try this ... it givec a lot more and it's useful i think select vu.node_name,vo.status,vu.copy_type,vo.est_capacity_mb,vo.pct_utilized,vo.volume_name - from volumeusage vu,volumes vo - where vo.volume_name=vu.volume_name - group by

Re: TDP for SQL error

Eric - Do the ADSM QuickFacts notes on that msg meet your conditions? It's exasperating that so many TSM messages are this vague. Richard On Mar 9, 2005, at 5:10 AM, Loon, E.J. van - SPLXM wrote: ANS1309W (RC9) Requested data is offline

Re: QUERY FILESPACE: No match found using this criteria

Thanks. //Henrik Das, Samiran

Re: Can't restore Exchange

Nghiatd, HRESULT: 0xc7ff1004 is returned when the Exchange Server encounters something that it did not expect. Many times this means that there was a missed step during the rebuild of the Exchange Server. I would check the specific disaster recovery steps for Exchange 2000 here:

Re: TDP for SQL error

Eric, If Richard's pointers provide no help, go to: http://www.ibm.com/us/ and in the Search box, enter: ANS1309W There are a few hits that might help. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 03/09/2005

TSM 5.1.5 Client TSM 5.3 restore compatiblity

Hello, Can a TSM 5.1.5 client be restored to a 5.3 server using the Backup/Restore/ Java Gui? Or it has to be done from the command line only? Also, If I wanted to restore a file to it's original location for example cd/usx/mvm/qamp I would type in the following from the command line in the

JR-RH 7.2 Enterprise Cluster using IPVS

I have a 2 node Red Hat 7.2 cluster using IPVS and I would like to know the following: How to configure TSM to backup data on the cluster. My experience with clustering is Active-Passive, my understanding with IPVS is it's Active-Active. Typically I would setup a clustered resource and back it up

Re: TDP for SQL error

Hi Richard! Actually they do! Why didn't I check them first... Thank you (and Dell too) for the solution. I thought the mountwait only applies to restores, but apparently it's also backup related. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From:

Re: SUSPECT: (MSW) Re: Directory path backed up again and again ...

Andy, I tried to activate the traceflag FIOATTRIBS, however to simulate the same conditions as usual, I had to issue an incremental backup command without specifying any object : the output was huge ! I then tried to understand it, and found out that only the objects having Mod Time different:

Listserver subscription hosed

My apologies to the list, but I can't seem to do this another way. Can someone who manages this listserver please contact me. I have sent two emails to Marist and can't seem to get a response. We (another co-worker is also on this list and has the same problem) have stopped getting ADSM-L mail

Multi-process Reclamtion/migration 5.3

Hello, Has anyone set up Multi-process Reclamation/Migration for TSM 5.3? If so is there any documentation on how to set it up? where? I only found bits and pieces of it being talked about. TSM 5.3.0.1 RS/6000 Aix5.2 p670 Thanks for any assistance!

Re: space in storage pool

Daft to ask but have you any scratch tapes in the library? Regards Neil Sharp [EMAIL PROTECTED], Norita binti Hassan [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu 09/03/2005 09:25 Please respond to ADSM: Dist Stor Manager ADSM-L@vm.marist.edu To

Re: Multi-process Reclamtion/migration 5.3

From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Hughes Has anyone set up Multi-process Reclamation/Migration for TSM 5.3? If so is there any documentation on how to set it up? where? I only found bits and pieces of it being talked about. Read the Fine Manual. def

Re: Listserver subscription hosed

From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Zoltan Forray My apologies to the list, but I can't seem to do this another way. Can someone who manages this listserver please contact me. I have sent two emails to Marist and can't seem to get a response. This is the

Re: Listserver subscription hosed

I already checked with our email system administrators (first thing I do since we have had issues in the past where our anti-spam/anti-virus systems got hung up). Nothing on their end. The last email I got from ADSM-L was 3/2/2005. I do recall a few message being echoed-duplicated. I also

Re: Need a script

Very sorry for the delay in reply. Also sorry for the unattractive format - they do not make it easy to get the TECHNOTE into a form you can mail. 1166289 How to remove a single file from a TSM backup tape volume Technote (FAQ) Problem For customers with security sensitive files already

Export feasibility

Hello all, We are investigating replacing our old backup systems with TSM. We don't want to give up storing away a complete snapshot of our systems off site every few months, over time maybe reusing the off site tapes so that we finally save a snapshot a year. I think that the most logical way to

Backup time taking too high ... how to solve

Hi All, To day the backup time for 180 GB is taking more time for us. Normally it will take around 2hrs 15 mnts. If i see in q actlog, one attention message is appearing like === more than 1mb of database changes use backup db to provide for database recovery ... = The above

Re: Retrieves failing on files with future archive attributes

Thanks Andy. I'll talk to support but I'm still curious about if TSM looks at the archive attribute at all. Andrew Ferris Network Support Analyst iCAPTURE Research Centre University of British Columbia [EMAIL PROTECTED] 3/8/2005 3:19:20 PM Hmmm. it seems odd to me that you'd get ANS1301E

Re: Volume sequence

I've tried that script, but I need to know the file sequence. Eg. I have a large database of 170GB.It should occupied more than 1 tape. How do I know which tape is the first one, and which is next . ~Norita Hasan~ -Original Message- From: goc [mailto:[EMAIL PROTECTED] Sent: Wednesday,

Re: Export feasibility

On 10/03/2005, at 8:15 AM, Ragnar Sundblad wrote: We don't want to give up storing away a complete snapshot of our systems off site every few months, over time maybe reusing the off site tapes so that we finally save a snapshot a year. I think that the most logical way to accomplish this with TSM

Re: LTO Volume

Hi After running and observation from past so many days it has been observed that backup is going on two LTO volumes i.e. TAPE LEAKING as per the term used. Now please update me the resolution for the same? Output of the query in my set up is as follows: - STORAGE POOL : TAPEPOOL

Re: Backup time taking too high ... how to solve

It's very difficult to guide you on backup performance without knowing the configuration of servers used or operating system. Regarding the message of database changes, it is not related to your backup time as its means that you need to take a TSM database backup. Regards Akash -Original