Backup status
Hi, Currently we run a mixture of System and Oracle backups on our servers which have up until now been running ok. We receive a pregenerated email every day at 2pm which displays the status of the all the backups that have run in the past 24 hours. What I would like to do is to change this so that we get an email when the Oracle backups finish if they return a status of anything but successful (e.g. 'MISSED' or 'FAILED'). Could someone tell me how I could do this? (on an individual backup basis would be preferable). Thanks in advance, Mark Tindall Thompson Scientific
Re: Web GUI problems with TSM 5.2
Thanks Bill - this has solved it On Wed, 23 Mar 2005 07:16:55 -0700, Bill Smoldt [EMAIL PROTECTED] wrote: OK, now, check that your dsm.opt in the client/ba/bin directory contains the line servername edcbkup add this line to the first stanza before the line password access generate execute dsmc and enter your username/password for the client node. Execute dsmcad, connect via web browser to port 1581, enter a valid TSM SERVER username/password (line ADMIN ADMIN). If that doesn't work, post the relevant lines of you client/ba/bin/dsmwebcl.log file. Bill Smoldt STORServer, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Mark Tindall Sent: Wednesday, March 23, 2005 6:57 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Web GUI problems with TSM 5.2 Bill, TSM client software is running on Sun solaris boxes (5.9) - TDP version is 5.2 - current dsm.sys file below :- SErvername edcbkup TCPPort1502 TCPServeraddress xxx.xxx.xxx.xxx Inclexcl/opt/tivoli/tsm/client/ba/bin/adsm.exclude MEMORYEFFICIENTBACKUP yes Nodenamecmsprod COMMMETHOD TCPIP schedlogname /opt/tivoli/tsm/client/ba/bin/dsmsched.log schedlogretention 7,D schedmode prompted SErvername oracle TCPPort1502 TCPServeraddress xxx.xxx.xxx.xxx Inclexcl/opt/tivoli/tsm/client/ba/bin/adsm.exclude MEMORYEFFICIENTBACKUP yes Nodenamecmsprod-oracle COMMMETHOD TCPIP schedlogname /opt/tivoli/tsm/client/oracle/bin/dsmschedtdp.log schedlogretention 7,D *schedmode prompted passwordaccess prompt SErvername oracle-sched TCPPort1502 TCPServeraddress xxx.xxx.xxx.xxx Inclexcl/opt/tivoli/tsm/client/ba/bin/adsm.exclude MEMORYEFFICIENTBACKUP yes Nodenamecmsprod-oracle COMMMETHOD TCPIP schedlogname /opt/tivoli/tsm/client/oracle/bin/dsmschedtdp.log schedlogretention 7,D schedmode prompted passwordaccess generate Thanks, Mark On Wed, 23 Mar 2005 06:23:16 -0700, Bill Smoldt [EMAIL PROTECTED] wrote: Mark, Are you on a Windows or UNIX machine? Do you have passwordaccess generate set in your appropriate dsm.sys stanza (UNIX) or dsm.opt file (Windows)? That is what stores the password locally on the client machine for use with dsmc. If you have a TDP on this same machine and this is a UNIX box, are you using two separate stanzas, one for the TDP and one for the backup/archive client? Are you going to allow users other than TSM admins access through the client web interface? If so, do you have an administrator registered on the server with the same name as nodename? From a TSM admin command line, query admin and look for a match with the node from query node - the one that matches the nodename option in dsm.sys or the hostname from a shell command. Please post your dsm.sys file, version, and the type of TDP you're running on this machine. Bill Smoldt STORServer, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Mark Tindall Sent: Wednesday, March 23, 2005 2:19 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Web GUI problems with TSM 5.2 Bill, apologies for the late reply but I have been really busy trying to recover a production database. What happens is that I enter the dsmc command before i kick off the dsmcad one and I get asked for hostname/passsword login. Once I complete this I kick off the dsmcad command and connect to the host via a web browser. This connects fine until the point I click on anything where I get the message: ANS2604S The Web client agent was unable to authenticate with the server. displayed in a window. You can do nothing else until you click on the Ok prompt in the window. I am very new to TSM having come from a Veritas Netbackup background and so dont really have a good understanding of how to setup the normal file system backups (they were all done by someone else from USA). Is there some way of storing the password locally as like I have done for TDP? Thanks for the help. Mark Tindall Email: [EMAIL PROTECTED] On Tue, 22 Mar 2005 05:42:31 -0700, Bill Smoldt [EMAIL PROTECTED] wrote: If you are not going to allow anyone except TSM administrators use of the web interface, you can use any existing TSM admin account with sufficient privilege to log in at the dsmcad dialogue box. As Richard pointed out to me privately, the command I offered earlier should have been update admin nodename newpassword (rather than set admin) but that only matters if you created the individual node account at node registration time, as Richard describes. Bill Smoldt
Re: Web GUI problems with TSM 5.2
Bill, apologies for the late reply but I have been really busy trying to recover a production database. What happens is that I enter the dsmc command before i kick off the dsmcad one and I get asked for hostname/passsword login. Once I complete this I kick off the dsmcad command and connect to the host via a web browser. This connects fine until the point I click on anything where I get the message: ANS2604S The Web client agent was unable to authenticate with the server. displayed in a window. You can do nothing else until you click on the Ok prompt in the window. I am very new to TSM having come from a Veritas Netbackup background and so dont really have a good understanding of how to setup the normal file system backups (they were all done by someone else from USA). Is there some way of storing the password locally as like I have done for TDP? Thanks for the help. Mark Tindall Email: [EMAIL PROTECTED] On Tue, 22 Mar 2005 05:42:31 -0700, Bill Smoldt [EMAIL PROTECTED] wrote: If you are not going to allow anyone except TSM administrators use of the web interface, you can use any existing TSM admin account with sufficient privilege to log in at the dsmcad dialogue box. As Richard pointed out to me privately, the command I offered earlier should have been update admin nodename newpassword (rather than set admin) but that only matters if you created the individual node account at node registration time, as Richard describes. Bill Smoldt STORServer, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Tuesday, March 22, 2005 5:14 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Web GUI problems with TSM 5.2 Check the error log, as recommended in the message explanation. This is often due to not having an administrative account with owner privileges to the node. Richard Sims On Mar 22, 2005, at 6:04 AM, Mark Tindall wrote: Hi, I am trying to get the web gui client working for 4 of our servers for normal backups/restores but keep getting the following error when I try to do anything with it: ANS2604S The Web client agent was unable to authenticate with the server. I think this has something to do with setting a local password (as like we have done for TDP) but am at a bit of a loss as to how to do this. Could someone explain? Thanks, Mark Tindall Email: [EMAIL PROTECTED]
Re: Web GUI problems with TSM 5.2
Bill, TSM client software is running on Sun solaris boxes (5.9) - TDP version is 5.2 - current dsm.sys file below :- SErvername edcbkup TCPPort1502 TCPServeraddress xxx.xxx.xxx.xxx Inclexcl/opt/tivoli/tsm/client/ba/bin/adsm.exclude MEMORYEFFICIENTBACKUP yes Nodenamecmsprod COMMMETHOD TCPIP schedlogname /opt/tivoli/tsm/client/ba/bin/dsmsched.log schedlogretention 7,D schedmode prompted SErvername oracle TCPPort1502 TCPServeraddress xxx.xxx.xxx.xxx Inclexcl/opt/tivoli/tsm/client/ba/bin/adsm.exclude MEMORYEFFICIENTBACKUP yes Nodenamecmsprod-oracle COMMMETHOD TCPIP schedlogname /opt/tivoli/tsm/client/oracle/bin/dsmschedtdp.log schedlogretention 7,D *schedmode prompted passwordaccess prompt SErvername oracle-sched TCPPort1502 TCPServeraddress xxx.xxx.xxx.xxx Inclexcl/opt/tivoli/tsm/client/ba/bin/adsm.exclude MEMORYEFFICIENTBACKUP yes Nodenamecmsprod-oracle COMMMETHOD TCPIP schedlogname /opt/tivoli/tsm/client/oracle/bin/dsmschedtdp.log schedlogretention 7,D schedmode prompted passwordaccess generate Thanks, Mark On Wed, 23 Mar 2005 06:23:16 -0700, Bill Smoldt [EMAIL PROTECTED] wrote: Mark, Are you on a Windows or UNIX machine? Do you have passwordaccess generate set in your appropriate dsm.sys stanza (UNIX) or dsm.opt file (Windows)? That is what stores the password locally on the client machine for use with dsmc. If you have a TDP on this same machine and this is a UNIX box, are you using two separate stanzas, one for the TDP and one for the backup/archive client? Are you going to allow users other than TSM admins access through the client web interface? If so, do you have an administrator registered on the server with the same name as nodename? From a TSM admin command line, query admin and look for a match with the node from query node - the one that matches the nodename option in dsm.sys or the hostname from a shell command. Please post your dsm.sys file, version, and the type of TDP you're running on this machine. Bill Smoldt STORServer, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Mark Tindall Sent: Wednesday, March 23, 2005 2:19 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Web GUI problems with TSM 5.2 Bill, apologies for the late reply but I have been really busy trying to recover a production database. What happens is that I enter the dsmc command before i kick off the dsmcad one and I get asked for hostname/passsword login. Once I complete this I kick off the dsmcad command and connect to the host via a web browser. This connects fine until the point I click on anything where I get the message: ANS2604S The Web client agent was unable to authenticate with the server. displayed in a window. You can do nothing else until you click on the Ok prompt in the window. I am very new to TSM having come from a Veritas Netbackup background and so dont really have a good understanding of how to setup the normal file system backups (they were all done by someone else from USA). Is there some way of storing the password locally as like I have done for TDP? Thanks for the help. Mark Tindall Email: [EMAIL PROTECTED] On Tue, 22 Mar 2005 05:42:31 -0700, Bill Smoldt [EMAIL PROTECTED] wrote: If you are not going to allow anyone except TSM administrators use of the web interface, you can use any existing TSM admin account with sufficient privilege to log in at the dsmcad dialogue box. As Richard pointed out to me privately, the command I offered earlier should have been update admin nodename newpassword (rather than set admin) but that only matters if you created the individual node account at node registration time, as Richard describes. Bill Smoldt STORServer, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Tuesday, March 22, 2005 5:14 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Web GUI problems with TSM 5.2 Check the error log, as recommended in the message explanation. This is often due to not having an administrative account with owner privileges to the node. Richard Sims On Mar 22, 2005, at 6:04 AM, Mark Tindall wrote: Hi, I am trying to get the web gui client working for 4 of our servers for normal backups/restores but keep getting the following error when I try to do anything with it: ANS2604S The Web client agent was unable to authenticate with the server. I think this has something to do with setting a local password (as like we have done for TDP) but am at a bit of a loss as to how to do this. Could someone explain? Thanks
Web GUI problems with TSM 5.2
Hi, I am trying to get the web gui client working for 4 of our servers for normal backups/restores but keep getting the following error when I try to do anything with it: ANS2604S The Web client agent was unable to authenticate with the server. I think this has something to do with setting a local password (as like we have done for TDP) but am at a bit of a loss as to how to do this. Could someone explain? Thanks, Mark Tindall Email: [EMAIL PROTECTED]
Re: Questions for TSM / Netbackup Survey
I much prefer the Netbackup interface compared to TSM - we were Netbackup and have now switched to Tivoli. The client offers a lot more information and scope to manage all of your backups I feel compared to the TSM one, and is a lot easier to understand and use. We are currently using Netbackup 4.5GA on a Solaris box with the clients deployed on Windows PC's. Mark Tindall Systems Analyst Thomson Scientific On Thu, 17 Mar 2005 09:14:10 -, Iain Barnetson [EMAIL PROTECTED] wrote: 1) No choice here but to use Windows, or rather I'd have retired before a decision was made if I asked for anything else 2) Training? Whats that? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Hart, Charles Sent: 16 March 2005 15:31 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Questions for TSM / Netbackup Survey We have been a TSM shop for years (no problem with it) but are being asked to look at Netbackup. Part of our evaluation is going to consist of a survey to our platform admins who do our Archives / RMAN / Restores etc. We do use NBU at many remote locations which only some of our platform admins have used the NBU interface. The only question on the survey for our platform admins are 1) I have is which client do you prefer to work with? 2) Would you feel you would require formal training.Anyone else have any good questions? Appreciate the help!
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 databases of versions 8.1.7 and above (via RMAN). This presents a huge problem since we still have a number of production instances that are still on versions 7.3.4 and 8.0.6. Can anyone tell me a way that I can perform backups on these databases with TSM 5.2 ? Thanks, Mark Tindall Database Administrator Thomson Scientific Tel: 0207 424 2093 Fax: 0207 424 2815
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 always started / completed before the tablespaces were placed in / taken out of backup mode. As far as I know TSM will only kick off one script which you must use to do the lot. Many thanks for your help, Mark Tindall On Wed, 9 Mar 2005 10:06:35 +0100, Andreas Almroth [EMAIL PROTECTED] wrote: 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 is OK) For most installations #1 would probably the most effective way to do it. There will still be a lot of manual work, and a good backup script. Both ways means you will need to have a good copy group or a dedicated domain in order to keep the backups for the retention period required. Also, using #1 means you will not need to do manual housekeeping in RMAN to synchronise with what you have got in TSM. #1 is also well documented way of doing Oracle backups, and the only thing you will need is to encapsulate those scripts so that they can be called by the TSM scheduler as command. In command script you would put the database tablespaces in backup mode, generating the list of files to be backed up, doing some grep/sort/sed/awk to figure which file systems to backup, then running the dsmc client on the file systems (don't forget any archive log files), and last put the tablespaces back in normal mode. Or instead of using TSM scheduler, just use a cron scheduled script. I'm sure there are other ways, perhaps even better ways... /Andreas Mark Tindall wrote: 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 databases of versions 8.1.7 and above (via RMAN). This presents a huge problem since we still have a number of production instances that are still on versions 7.3.4 and 8.0.6. Can anyone tell me a way that I can perform backups on these databases with TSM 5.2 ? Thanks, Mark Tindall Database Administrator Thomson Scientific Tel: 0207 424 2093 Fax: 0207 424 2815
Oracle RMAN TDP scheduling for Solaris
I am new to Tivoli and am having problems trying to get scheduling working for the TDP side of things via the TSM scheduler. I have so far found out that I need to have 3 stanzas in the dsm.sys file - 1 for normal backups, 1 for Oracle and 1 for the scheduler for Oracle - and that I need to run a second dsmc process which then refers to the severname set up in the dsm.sys file for the scheduler for Oracle. When I schedule stuff to run it seems to acually execute the script listed in the Command section, though this sems to error as it is missing some environment varuables setup? I know I can backup the databaes fine if I either run from the command line or I use the cron facility. Could someone explain how I should setup the scheduling via TSM so that it works?