Defrag Database
Hi, *** ---> Q DB F=D Available Space (MB): 3.320 Assigned Capacity (MB): 3.320 Maximum Extension (MB): 0 Maximum Reduction (MB): 20 Pct Util: 43,2 Max. Pct Util: 52,0 Physical Volumes: 13 Because the database is around 50% utililized, i want to reduce the database, the by the spacetrigger made volumes can be deleted. Is there a way to "defrag" the database? Tia, Maurice
Rename file on ADSM
Hi there I need to know if anyone has renamed the DB2/UDB filespace name on ADSM. I am using the API to back up the DB2 database. I am aware when using the API, ADSM keeps only one filespace name. Full database backups are done on a daily basis of the DB2/UDB database. My intention is to rename the file on a daily basis with the date and time. I have done test's and can rename the file on ADSM but when I try to restore the data the DB2 database does not know about this data on ADSM. We currently keep 3 months of data for DB2. The reason I need to rename the file as I want to use the export command to keep certain UDB data for two years offsite. Current ADSM server version is 3.1.2.5 and client version is 3.1.20.7 Thks Sean Ramnarayan ADSM Administrator EDS South Africa
Re: Defrag Database
Hi Maurice! An online defrag utility is on all our wish lists for some time! The only way to defrag your database is a offline dump and reload... Note that this is quite a lengthy process! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Maurice van 't Loo [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 09:22 To: [EMAIL PROTECTED] Subject: Defrag Database Hi, *** ---> Q DB F=D Available Space (MB): 3.320 Assigned Capacity (MB): 3.320 Maximum Extension (MB): 0 Maximum Reduction (MB): 20 Pct Util: 43,2 Max. Pct Util: 52,0 Physical Volumes: 13 Because the database is around 50% utililized, i want to reduce the database, the by the spacetrigger made volumes can be deleted. Is there a way to "defrag" the database? Tia, Maurice ** This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: cannot cancel a session
I actually opened a PMR on this same problem (PMR#45713,519) and they told me that (this is almost a direct quote) "...that is the way it works." In asking, of course, they wouldnt put any of that in writing, but here is some text cut out from the PMR itself... Action Taken:Explained that Select statements are database intensive and use up a lot of resources. Depending on complexity of the query it quite possible for the server to hang. If cancel session doesn't work then recycling Tsm is the only way out. Customer wants something in writing confirming this. Directed to the Admin Guide: Monitoring TSM server subsection entilted Using Sql to Query the TSM DB, issuing select commands where it states that complicat ed queries can interfere with normal server operations. The problem I was having is that a select that worked on one system would hang on another. According to the Admin Guide, it is perfect acceptable to cancel that session with another administrator session; however from what I have seen I wouldnt recommend it - unless you have the time to cycle your TSM_server process. -Dustin = Dustin Hamilton; EDS Auburn Hills SMC; Enterprise Backup and Restore Phone: 248/276.5717 Pager: 248/316.5089 Schedule and more info: http://205.239.25.218/ Backup Client Software: ftp://205.239.25.218/ = eMail: [EMAIL PROTECTED] Text-Pager: [EMAIL PROTECTED] = -Original Message- Date:Sun, 16 Sep 2001 16:17:59 -0700 From:Joel Fuhrman <[EMAIL PROTECTED]> Subject: Re: cannot cancel a session My experience is that the select processes all the data. The cancel only stops the display. On Fri, 14 Sep 2001, Guan, Phillip wrote: > Hi all, > > When I run 'select * from backups' or ' select * from archives', it will > list a lots of records. Because it is a very long list, I press 'C' to quit > but it hung there for long time; and finally I press CTRL-C to exit to > shell. Now that session is still there and I run the 'cancel session' > command to stop it. Does anyone have such experience before? > > My TSM server is 4.1.2.0 and I know our backup and archive table is very > big. > > Appreciated your help. > > Best regards, > Phillip Guan > -- End of ADSM-L Digest - 15 Sep 2001 to 16 Sep 2001 (#2001-254) *
Re: Rename file on ADSM
Rename filespace node_name filespacename new_filespacename -- Joshua S. Bassi Independent IT Consultant IBM Certified - AIX/HACMP, SAN, Shark Tivoli Certified Consultant- ADSM/TSM Cell (408)&(831) 332-4006 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Ramnarayan, Sean A [EDS] Sent: Monday, September 17, 2001 3:59 AM To: [EMAIL PROTECTED] Subject: Rename file on ADSM Hi there I need to know if anyone has renamed the DB2/UDB filespace name on ADSM. I am using the API to back up the DB2 database. I am aware when using the API, ADSM keeps only one filespace name. Full database backups are done on a daily basis of the DB2/UDB database. My intention is to rename the file on a daily basis with the date and time. I have done test's and can rename the file on ADSM but when I try to restore the data the DB2 database does not know about this data on ADSM. We currently keep 3 months of data for DB2. The reason I need to rename the file as I want to use the export command to keep certain UDB data for two years offsite. Current ADSM server version is 3.1.2.5 and client version is 3.1.20.7 Thks Sean Ramnarayan ADSM Administrator EDS South Africa
Re: Defrag Database
Maurice, Delete the "spacetrigger made volumes" and the data on these database volumes will be moved to other database volumes. You may have to create some more database volumes of your own first but since you are only using 43.2 % of your database now there should be enough space. Quoting Maurice van 't Loo <[EMAIL PROTECTED]>: > Hi, > > *** ---> Q DB F=D > > Available Space (MB): 3.320 > Assigned Capacity (MB): 3.320 > Maximum Extension (MB): 0 > Maximum Reduction (MB): 20 > Pct Util: 43,2 > Max. Pct Util: 52,0 > Physical Volumes: 13 > > Because the database is around 50% utililized, i want to reduce the > database, the by the spacetrigger made volumes can be deleted. > > Is there a way to "defrag" the database? > > Tia, >Maurice >
Re: W2K AD Restore Question?
I use the following in your DSM.OPT file: Include.SystemObject ALL STANDARD STANDARD is just my policy name which includes 2 revisions..etc.. My config is TSM 4.1.3 on NT Server 4.0 sp6a and client 4.2 on the 2000 servers. Joe Cascanette -Original Message- From: taford [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 3:37 PM To: [EMAIL PROTECTED] Subject: W2K AD Restore Question? Does anyone know what needs to be done to backup an Active Directory with use of scheduling and a dsm.opt file? I can run dsmc backup activedirectory and all is well, but I would like to put this on a schedule. The documentation I have looked at so far doesn't reference AD as a backup parameter in the dsm.opt file? -Tim
Re: BIG RESTORE
Robert, Set the CommTimeOut and IdleTimeOut values fairly large. I completed a migration from one server to another about 3 months ago and these seemed to be the things that 'bit' me the most. Of course I was doing IMPORT-- not the same but similar. The worst was 462 GB, but I got it on 3rd try by bumping mentioned timeout values to very high numbers. Sam Schrage TRW Systems 615-360-4716 [EMAIL PROTECTED] Robert Fijan <[EMAIL PROTECTED]> on 09/14/2001 05:50:28 AM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: (bcc: Sam Schrage/Nashville) Subject: BIG RESTORE Hi folks. I've the following problem: I start a restore for a Fileserver with about 20 GB data to restore. We have a 16 MB TokenRing, so we make maybe 1 GB per hour. So the restore would take 20 Hours. Now my problem is: how can I automatically restart the restore when the session ends because of time-outs or other reasons? The TSM-Client is a NT-Fileserver, the TSM-Server is OS/390. with kind regards Mit freundlichen Grüßen Robert Fijan Sitz Stuttgart Tel. (0 7 11) 8 48-23 39 Fax. (0 7 11) 8 48 44-33 11 Internet-Mail: [EMAIL PROTECTED]
Restoring Large Files
I have a single file I need to restore. It is a .bkf file froma winnt backup. It is 178g. The restore runs at about 20g an hour until it reaches about 60 or 70 gig. It then slow to 1g per hour. It will finish in about 28 hours, but the Winnt restore can't restore it. Does anyone have any experience restoreing a large file with tsm? No comments about restoreing a nt backup please. Scott G. Davis 4001 Rodney Parham Rd. Bldg 2 Flr 1, 2147b Little Rock, AR 72212 (501)220-6338
ANS1357S - Anybody see this error before?
We recently upgraded our TSM Server to 4.2.0.1 (AIX)and now we have a few clients that will not connect to the server and spit out the following error: ANS1357S Session rejected: Downlevel client code version I am getting these errors on 3.1, 3.7 and 4.1 clients, all Windows (NT and 2000). It would appear that I need to upgrade the client level. But why do some servers with the same client level still work while others do not. Any ideas out there? Thanks! Dwight Wood AEP Columbus, OH _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
Re: P2000 questions
Well, then I would suggest contacting ATL tech support. Maybe they've seen it before... RS "Coviello, Paul" cc:(bcc: Robin Sharpe/WA/USR/SHG) Subject: 09/15/01 Re: P2000 questions 09:51 AM Please respond to "ADSM: Dist Stor Manager" yes the tab is actually being set to write protect! That's what I thought but the operator is claiming that this is happening. bizzare yes!! thanks Paul > -Original Message- > From: Robin Sharpe [SMTP:[EMAIL PROTECTED]] > Sent: Friday, September 14, 2001 1:16 PM > To: [EMAIL PROTECTED] > Subject: Re: P2000 questions > > Hi Paul, > > We have a P3000, which is basically the same architecture as a P2000, I > think. Do they mean the tapes are coming out with the write protect tab > moved? I can't imagine how that could happen... I know there is no > mechanism in the P3000 that can do that! If they mean that the tapes are > being set to read-only mode in TSM, there are several conditions that can > cause that to happen, probably the most common are read or write errors. > > Robin Sharpe > Berlex Laboratories > > > > "Coviello, > Paul" > C-NH.ORG> cc:(bcc: Robin Sharpe/WA/USR/SHG) > Subject: > 09/14/01 P2000 questions > 08:39 AM > Please > respond to > "ADSM: Dist > Stor Manager" > > > > > > > > Hi, we have a ATL P2000 with 4 DLT tape drives. the operators are telling > me that some of the tapes are coming out write protected! Does anyone > know > if this is possible and if so why? > > thanks > Paul > > Paul J Coviello > Sr Systems Analyst > Catholic Medical Center > 2456 Brown Ave > Manchester NH 03103 > (603) 663-5326 > [EMAIL PROTECTED]
Re: W2K AD Restore Question?
Thanks for the info. I'll try that. If I have no policy domain can I just leave it off and it still work successfully? So, I would use a statement like Include.SystemObject ALL This only works with 4.2 codebase correct? -Tim -Original Message- From: Joe Cascanette [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 8:29 AM To: [EMAIL PROTECTED] Subject: Re: W2K AD Restore Question? I use the following in your DSM.OPT file: Include.SystemObject ALL STANDARD STANDARD is just my policy name which includes 2 revisions..etc.. My config is TSM 4.1.3 on NT Server 4.0 sp6a and client 4.2 on the 2000 servers. Joe Cascanette -Original Message- From: taford [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 3:37 PM To: [EMAIL PROTECTED] Subject: W2K AD Restore Question? Does anyone know what needs to be done to backup an Active Directory with use of scheduling and a dsm.opt file? I can run dsmc backup activedirectory and all is well, but I would like to put this on a schedule. The documentation I have looked at so far doesn't reference AD as a backup parameter in the dsm.opt file? -Tim
Re: Defrag Database
I just had a thought. If you defined new dbvols and deleted the previous dbvols, that would move the db data over to the new volume. Could that possibly defrag the db at the same time? I would expect so because the manual says you can cancel the delete dbvol process, but some of the data may have moved. It makes sense to me that this implies it moves db objects, not just vast tracts of raw dbspace. Any thoughts? (Andy? Are you out there? Any chance on developer feedback on this one?) Alex -Original Message- From: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 2:06 AM To: [EMAIL PROTECTED] Subject: Re: Defrag Database Hi Maurice! An online defrag utility is on all our wish lists for some time! The only way to defrag your database is a offline dump and reload... Note that this is quite a lengthy process! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Maurice van 't Loo [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 09:22 To: [EMAIL PROTECTED] Subject: Defrag Database Hi, *** ---> Q DB F=D Available Space (MB): 3.320 Assigned Capacity (MB): 3.320 Maximum Extension (MB): 0 Maximum Reduction (MB): 20 Pct Util: 43,2 Max. Pct Util: 52,0 Physical Volumes: 13 Because the database is around 50% utililized, i want to reduce the database, the by the spacetrigger made volumes can be deleted. Is there a way to "defrag" the database? Tia, Maurice ** This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. ** "WorldSecure " made the following annotations on 09/17/01 09:29:03 -- [INFO] -- Content Manager: The information contained in this communication is confidential and intended solely for the use of the individual to whom it is addressed and others authorized to receive it. If you are not the intended recipient, any disclosure, copying, distribution or taking of any action in reliance on the contents of this information is prohibited. If you have received this communication in error, please immediately notify the sender by phone if possible or via email message. ==
Re: W2K AD Restore Question?
If you leave off the STANDARD it will take your default policy. (your syntax is correct) You can use the "BackupRegistry Yes" with earlier version of Tivoli however Active Directory would not be included. Joe Cascanette -Original Message- From: taford [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 12:25 PM To: [EMAIL PROTECTED] Subject: Re: W2K AD Restore Question? Thanks for the info. I'll try that. If I have no policy domain can I just leave it off and it still work successfully? So, I would use a statement like Include.SystemObject ALL This only works with 4.2 codebase correct? -Tim -Original Message- From: Joe Cascanette [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 8:29 AM To: [EMAIL PROTECTED] Subject: Re: W2K AD Restore Question? I use the following in your DSM.OPT file: Include.SystemObject ALL STANDARD STANDARD is just my policy name which includes 2 revisions..etc.. My config is TSM 4.1.3 on NT Server 4.0 sp6a and client 4.2 on the 2000 servers. Joe Cascanette -Original Message- From: taford [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 3:37 PM To: [EMAIL PROTECTED] Subject: W2K AD Restore Question? Does anyone know what needs to be done to backup an Active Directory with use of scheduling and a dsm.opt file? I can run dsmc backup activedirectory and all is well, but I would like to put this on a schedule. The documentation I have looked at so far doesn't reference AD as a backup parameter in the dsm.opt file? -Tim
Re: Management class and TDP for Oracle with RMAN
Hello Thiha.
Thanks for your help.
I'm still stuck with this issue. I have followed your instructions but it
doesn't work. Whenever I start a script to backup the archivelog files, it
keeps going to the default mgmt class.
These are my configuration files:
TDPO.CONF
DSMI_ORC_CONFIG /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
DSMI_LOG/usr/tivoli/tsm/client/oracle/bin64/dsierror.log
TDPO_NODE dsiaja02_ora
TDPO_PSWDPATH /usr/tivoli/tsm/client/oracle
DSM.OPT
SErvernamedsiaja04
DSM.SYS
SErvername dsiaja04
nodename dsiaja02_ora
COMMmethod TCPip
TCPPort1500
TCPServeraddress dsiaja04a
passwordaccess prompt
inclexcl /usr/tivoli/tsm/client/oracle/bin64/inclexcl
INCLEXCL
include /adsmorc/.../*.arc rman_archive_log
The script that I use is:
run{
allocate channel 'tsm0' type 'sbt_tape';
sql "alter system archive log current" ;
backup archivelog all format '%d_arch_%U' delete input;
}
Is there anything wrong?
Thank you for your cooperation !!
[EMAIL PROTECTED]
~
-Mensaje original-
De: Thiha Than [mailto:[EMAIL PROTECTED]]
Enviado el: viernes, 14 de septiembre de 2001 18:21
Para: [EMAIL PROTECTED]
Asunto: 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 class's storage pool is pointing to disk pool. So
you don't have to do anything for your database backups. As for the
archive log file, let's say you have the pattern "log_archive_format =
arch%t_%s.dbf" in your init.ora file. In your include definition file, add
include /adsmorc/.../arch* tapemgmt
This will bind the archive logs to 'tapemgmt' class.
If you don't use different domain for your TDPO backups and/or mgmt class
pointing to disk pool is not the default, you can add another line in your
include definition file:
include /adsmorc/.../arch* tapemgmt
include /adsmorc/.../* diskmgmt
Make sure that these statements appear in the exact order.
regards,
Thiha
>I'm trying to configure RMAN and need some help. My scenario is AIX 4.3,
>Oracle 8.1.6 and TDP for Oracle 2.2 64 bits.
>My question is if it is possible to have differents management classes
when
>making backups with RMAN. In the TDP manual there's only reference to
>TDPO_MGMT_CLASS_2, 3 and 4 but only for the duplex copy option.
>I'd like to have one management class for archive log files (sending it
to
>disk storage pools) and another for database files (sending it to tape
>storage pools).
Re: append a file to mksysb image
As an aside, they're also really handy for altinst_rootvg work during testing. I was able to boot under the original system, restore the disk file mksysb to the altinst_rootvg, reboot, test, reboot, restore the original system to altinst_rootvg, test something else, etc, much more quickly than I would have had I used the 4mm tape for my mksysb's. Plus I was able to keep multiple mksysb images without having to jog over to the data center to swap tapes. Alex -Original Message- From: Fujinaga, Cal [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 15, 2001 3:52 AM To: [EMAIL PROTECTED] Subject: Re: append a file to mksysb image back it up again. The man pages says these file mksysb are only good for NIM restores and are not bootable as a tape would be. "WorldSecure " made the following annotations on 09/17/01 09:25:58 -- [INFO] -- Content Manager: The information contained in this communication is confidential and intended solely for the use of the individual to whom it is addressed and others authorized to receive it. If you are not the intended recipient, any disclosure, copying, distribution or taking of any action in reliance on the contents of this information is prohibited. If you have received this communication in error, please immediately notify the sender by phone if possible or via email message. ==
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 your TDPO node. Think of RMAN backups as data coming from another TSM node. We recommend using a different nodename other than the machine name for TDPO operations. > Does anyone know where the RMAN backup pieces are on tape and the sizes of the files? Log on to TSM server through admin client and issue: tsm: TSMSERV1> select * from backups where node_name='node name in capitalized letters' AND filespace_name='/yourfs' example: tsm: TSMSERV1> select * from backups where node_name='TDPO' AND filespace_name='/adsmorc' Another command: tsm: TSMSERV1> select * from contents where node_name='node name in capitalized letters' AND filespace_name='/yourfs' example: tsm TSMSERV1> select * from contents where node_name='TDPO' AND filespace_name='/adsmorc' > Will Tivoli be able to reclaim tape space if the RMAN recovery catalog is lost? You should be more worried about reclaiming the tape space than how you are going to restore/recover your databases if your RMAN catalog is lost. :} If you lost your RMAN catalog, you can rebuild another one, and re-register your target database. Your target control file has backup piece information. During the database registering process, these backup piece information will be stored in RMAN catalog again. There are two ways to reclaim your tape: 1. You can run RMAN delete command to delete the data from TSM server through TDPO. 2. Sometimes, you end up having more backup piece entries on the TSM server than RMAN catalog. TDPO 2.2 has a utility called tdposyn to reclaim tape in this kind of situation. All the information mentioned above except SQL statements are documented in the TDPO 2.2 user manual. You can find it at: http://www.tivoli.com/support/public/Prodman/public_manuals/storage_mgr/admanual.htm#optional regards, Thiha >Dear Friends: >We are using Oracle 8.1.6 and Solaris 2.6 with TSM 4.1.1 (for AIX-RS/6000 with a 3575 tape library) and TDP. We use >RMAN to do the backups for our Sun Solaris systems. We have the following questions for the experts around the >world on the communication between RMAN and Tivoli. >Does RMAN write directly to tape when it is doing a backup? >Does anyone know where the RMAN backup pieces are on tape and the sizes of the files? >If it is Tivoli, is there a way to view this information? >Will Tivoli be able to reclaim tape space if the RMAN recovery catalog is lost? >Does anyone know in more detail what TDP does besides let RMAN talk to Tivoli?
Re: Management class and TDP for Oracle with RMAN
I had a problem like this and it was because the management class name was
too long. I don't remember what version or *sm I ran into it with but I
shortened all my management classes to 10 character. I found this on a
class called performance which I shortened to performanc.
Hope this helps
--
Phillip Ford
Senior Software Specialist
Corporate Computer Center
Schering-Plough Corp.
(901) 320-4462
(901) 320-4856 FAX
[EMAIL PROTECTED]
-Original Message-
From: De Blas Bellido, Vicente [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001 12:15 PM
To: [EMAIL PROTECTED]
Subject: Re: Management class and TDP for Oracle with RMAN
Hello Thiha.
Thanks for your help.
I'm still stuck with this issue. I have followed your instructions but it
doesn't work. Whenever I start a script to backup the archivelog files, it
keeps going to the default mgmt class.
These are my configuration files:
TDPO.CONF
DSMI_ORC_CONFIG /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
DSMI_LOG/usr/tivoli/tsm/client/oracle/bin64/dsierror.log
TDPO_NODE dsiaja02_ora
TDPO_PSWDPATH /usr/tivoli/tsm/client/oracle
DSM.OPT
SErvernamedsiaja04
DSM.SYS
SErvername dsiaja04
nodename dsiaja02_ora
COMMmethod TCPip
TCPPort1500
TCPServeraddress dsiaja04a
passwordaccess prompt
inclexcl /usr/tivoli/tsm/client/oracle/bin64/inclexcl
INCLEXCL
include /adsmorc/.../*.arc rman_archive_log
The script that I use is:
run{
allocate channel 'tsm0' type 'sbt_tape';
sql "alter system archive log current" ;
backup archivelog all format '%d_arch_%U' delete input;
}
Is there anything wrong?
Thank you for your cooperation !!
[EMAIL PROTECTED]
~
-Mensaje original-
De: Thiha Than [mailto:[EMAIL PROTECTED]]
Enviado el: viernes, 14 de septiembre de 2001 18:21
Para: [EMAIL PROTECTED]
Asunto: 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 class's storage pool is pointing to disk pool. So
you don't have to do anything for your database backups. As for the
archive log file, let's say you have the pattern "log_archive_format =
arch%t_%s.dbf" in your init.ora file. In your include definition file, add
include /adsmorc/.../arch* tapemgmt
This will bind the archive logs to 'tapemgmt' class.
If you don't use different domain for your TDPO backups and/or mgmt class
pointing to disk pool is not the default, you can add another line in your
include definition file:
include /adsmorc/.../arch* tapemgmt
include /adsmorc/.../* diskmgmt
Make sure that these statements appear in the exact order.
regards,
Thiha
>I'm trying to configure RMAN and need some help. My scenario is AIX 4.3,
>Oracle 8.1.6 and TDP for Oracle 2.2 64 bits.
>My question is if it is possible to have differents management classes
when
>making backups with RMAN. In the TDP manual there's only reference to
>TDPO_MGMT_CLASS_2, 3 and 4 but only for the duplex copy option.
>I'd like to have one management class for archive log files (sending it
to
>disk storage pools) and another for database files (sending it to tape
>storage pools).
***
This message and any attachments is solely for the intended recipient. If
you are not the intended recipient, disclosure, copying, use, or
distribution of the information included in this message is prohibited --
please immediately and permanently delete this message.
Bare Metal Restore sizing.
Hi All. Has anyone of you ever sized an BMR solution? I have several doubts about it. A) Space requirements for BMR software installation TKG says the following: "The BMR server requires 4 megabytes of disk space plus approximately 1 KB of disk space for every 2 clients. Each Boot image on the Boot Server will require 100 to 800 KB of disk space." How much space am I going to need for each boot image? Is a boot image created for each of my clients? if so, am BMR is going to backup a boot image each time the client is backed up? in this case I have to calculate the space on disk according the backup policies for each one of my clients. or am I going to create ONLY one boot image per platform I 'm going to backup (one image for SUN, another for NT, another for AIX)? This way I'm going to use much less space than the above scenario. How often are the boot images refreshed? How BMR is going to realize that a client has upgraded its OS, when others have not? B) Shared Root Tree For the SRT TKG states: "Each Shared Root Tree (SRT) on the File server will require 200 to 400 MB of disk space". The same questions as above. Is a SRT created each time a client is backed up? I've calculated the space Im going to need considering I have 6 clients (2 sun, 2 aix and 2 NTs), also that I only need one boot image per platform (3 in this case), and also one SRT per platform too. This makes a total of 606 MB. Are this calculations right? BMR Server BMR Server 1 4MB BMR Client 6 3.0Kb Boot Server Boot image 3 2MB File Server Shared Root Tree (SRT) 3 600 MB Total 606MB Thanks in advance. = "Do or Do Not, there is no try" -Yoda. The Empire Strikes Back ___ Do You Yahoo!? Yahoo! Messenger: Comunicacisn instantanea gratis con tu gente - http://messenger.yahoo.es
Re: Defrag Database
The question is "what is a reorg?" I would think moving the db to a new volume would just move the db blocks - not changing their contents. It would collapse the unused db blocks, but I think this would be different result than a unload/load, which would recreate all db objects. Kind of like the difference between moving a logical volume to a different disk and defraging a filesystem. On a move logical volume the physical partitions are moved, but their contents are left alone. To defrag the filesystem requires tinkering with the contents of the physical partition. Just a guess . . . . Rick On 17 Sep 2001, at 9:42, Alex Paschal wrote: > I just had a thought. If you defined new dbvols and deleted the previous > dbvols, that would move the db data over to the new volume. Could that > possibly defrag the db at the same time? I would expect so because the > manual says you can cancel the delete dbvol process, but some of the data > may have moved. It makes sense to me that this implies it moves db objects, > not just vast tracts of raw dbspace. Any thoughts? > > (Andy? Are you out there? Any chance on developer feedback on this one?) > > Alex > > -Original Message- > From: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 17, 2001 2:06 AM > To: [EMAIL PROTECTED] > Subject: Re: Defrag Database > > > Hi Maurice! > An online defrag utility is on all our wish lists for some time! > The only way to defrag your database is a offline dump and reload... Note > that this is quite a lengthy process! > Kindest regards, > Eric van Loon > KLM Royal Dutch Airlines > > > -Original Message- > From: Maurice van 't Loo [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 17, 2001 09:22 > To: [EMAIL PROTECTED] > Subject: Defrag Database > > > Hi, > > *** ---> Q DB F=D > > Available Space (MB): 3.320 > Assigned Capacity (MB): 3.320 > Maximum Extension (MB): 0 > Maximum Reduction (MB): 20 > Pct Util: 43,2 > Max. Pct Util: 52,0 > Physical Volumes: 13 > > Because the database is around 50% utililized, i want to reduce the > database, the by the spacetrigger made volumes can be deleted. > > Is there a way to "defrag" the database? > > Tia, >Maurice > > > ** > This e-mail and any attachment may contain confidential and privileged > material intended for the addressee only. If you are not the addressee, you > are notified that no part of the e-mail or any attachment may be disclosed, > copied or distributed, and that any other action related to this e-mail or > attachment is strictly prohibited, and may be unlawful. If you have received > this e-mail by error, please notify the sender immediately by return e-mail, > and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its > subsidiaries and/or its employees shall not be liable for the incorrect or > incomplete transmission of this e-mail or any attachments, nor responsible > for any delay in receipt. > ** > > "WorldSecure " made the following > annotations on 09/17/01 09:29:03 > -- > > [INFO] -- Content Manager: > The information contained in this communication is confidential and intended solely >for the use o f the individual to whom it is addressed and others authorized to receive it. If you are not the i ntended recipient, any disclosure, copying, distribution or taking of any action in reliance on the contents of this information is prohibited. If you have received this communication in error, plea se immediately notify the sender by phone if possible or via email message. > > == >
DNS Domain change effect on TSM
Our current internal network has a bunch of dns domains resulting from poor planning, mergers, etc. A decision has been made to re-domain(?) our network. We are going to move all our network under one new domain. IP numbers are NOT changing, just the domain. The plan is to put all hosts in the the new domain, and keep the old domain around for a while. This should allow for a quick conversion, but eliminate a big-bang conversion. I'm interested in issues/thoughts/comments on problems with TSM that might come up in relation with this domain change. Thanks Rick
ANR7821S Thread 30 (tid 52) terminating on signal 11 (Segmentatio n violation).
Well, in the following environment Session established with server TSMSRV10: Solaris 2.6 Server Version 4, Release 1, Level 4.0 Server date/time: 09/17/01 14:27:09 Last access: 09/17/01 14:25:39 I've found that a "show archive " of a node that was renamed will kill the tsm server every time ! seems to work OK on straight nodes... only on a node that I renamed does it kill the tsm server process. Not worth calling into tivoli since "show archive" is an unsupported, undocumented, debug command. Just throught I'd pass along advance notice ! "Kids, don't try this at home!" ;-) Dwight
DLT M1500, DLT8000 advice needed
Hi, We want to buy DLT M1500 tape library (with DLT8000 tape drives) to be used for ADSM Version 3.1 server on AIX 4.1 but I would like to confirm that ADSM 3.1 supports DLT M1500 before we buy it. Could someone help me confirm that? Thanks in advance for your help, Mira Jung [EMAIL PROTECTED]
Re: DLT M1500, DLT8000 advice needed
I would be very surprised if ADSM V 3.1 supports the drives in question. That is a very old release. Also, if the library is new, it is unlikely that support for it will be there as well. Kelly J. Lipp Storage Solutions Specialists, Inc. PO Box 51313 Colorado Springs CO 80949-1313 (719) 531-5926 Fax: (240) 539-7175 Email: [EMAIL PROTECTED] or [EMAIL PROTECTED] www.storsol.com www.storserver.com -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Mira Jung Sent: Monday, September 17, 2001 12:49 PM To: [EMAIL PROTECTED] Subject: DLT M1500, DLT8000 advice needed Hi, We want to buy DLT M1500 tape library (with DLT8000 tape drives) to be used for ADSM Version 3.1 server on AIX 4.1 but I would like to confirm that ADSM 3.1 supports DLT M1500 before we buy it. Could someone help me confirm that? Thanks in advance for your help, Mira Jung [EMAIL PROTECTED]
Re: Defrag Database
No, it doesn't. Jim Sporer At 09:42 AM 9/17/2001 -0700, you wrote: >I just had a thought. If you defined new dbvols and deleted the previous >dbvols, that would move the db data over to the new volume. Could that >possibly defrag the db at the same time? I would expect so because the >manual says you can cancel the delete dbvol process, but some of the data >may have moved. It makes sense to me that this implies it moves db objects, >not just vast tracts of raw dbspace. Any thoughts? > >(Andy? Are you out there? Any chance on developer feedback on this one?) > >Alex > >-Original Message- >From: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED]] >Sent: Monday, September 17, 2001 2:06 AM >To: [EMAIL PROTECTED] >Subject: Re: Defrag Database > > >Hi Maurice! >An online defrag utility is on all our wish lists for some time! >The only way to defrag your database is a offline dump and reload... Note >that this is quite a lengthy process! >Kindest regards, >Eric van Loon >KLM Royal Dutch Airlines > > >-Original Message- >From: Maurice van 't Loo [mailto:[EMAIL PROTECTED]] >Sent: Monday, September 17, 2001 09:22 >To: [EMAIL PROTECTED] >Subject: Defrag Database > > >Hi, > >*** ---> Q DB F=D > >Available Space (MB): 3.320 >Assigned Capacity (MB): 3.320 >Maximum Extension (MB): 0 >Maximum Reduction (MB): 20 >Pct Util: 43,2 >Max. Pct Util: 52,0 >Physical Volumes: 13 > >Because the database is around 50% utililized, i want to reduce the >database, the by the spacetrigger made volumes can be deleted. > >Is there a way to "defrag" the database? > >Tia, >Maurice > > >** >This e-mail and any attachment may contain confidential and privileged >material intended for the addressee only. If you are not the addressee, you >are notified that no part of the e-mail or any attachment may be disclosed, >copied or distributed, and that any other action related to this e-mail or >attachment is strictly prohibited, and may be unlawful. If you have received >this e-mail by error, please notify the sender immediately by return e-mail, >and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its >subsidiaries and/or its employees shall not be liable for the incorrect or >incomplete transmission of this e-mail or any attachments, nor responsible >for any delay in receipt. >** > >"WorldSecure " made the following > annotations on 09/17/01 09:29:03 >-- > >[INFO] -- Content Manager: >The information contained in this communication is confidential and >intended solely for the use of the individual to whom it is addressed and >others authorized to receive it. If you are not the intended recipient, >any disclosure, copying, distribution or taking of any action in reliance >on the contents of this information is prohibited. If you have received >this communication in error, please immediately notify the sender by phone >if possible or via email message. > >==
Re: DLT M1500, DLT8000 advice needed
You are running really old code versions (both of AIX and TSM). I would upgrade to AIX 4.3.3 and TSM 4.1 before you ever try installing this new device. -- Joshua S. Bassi Independent IT Consultant IBM Certified - AIX/HACMP, SAN, Shark Tivoli Certified Consultant- ADSM/TSM Cell (408)&(831) 332-4006 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Mira Jung Sent: Monday, September 17, 2001 11:49 AM To: [EMAIL PROTECTED] Subject: DLT M1500, DLT8000 advice needed Hi, We want to buy DLT M1500 tape library (with DLT8000 tape drives) to be used for ADSM Version 3.1 server on AIX 4.1 but I would like to confirm that ADSM 3.1 supports DLT M1500 before we buy it. Could someone help me confirm that? Thanks in advance for your help, Mira Jung [EMAIL PROTECTED]
Re: TDP for Exchange V1.1
http://www.tivoli.com/support/public/Prodman/public_manuals/storage_mgr/v3pubs/v1_pdf/msexc/h2641100.pdf Thanks, Bill William Degli-Angeli IGS TDP Development Endicott, NY (607) 752-6749 TieLine: 852-6749 Internet: [EMAIL PROTECTED] "Gill, Geoffrey L."To: [EMAIL PROTECTED] Subject: TDP for Exchange V1.1 Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] T.EDU> 09/17/2001 15:52 Please respond to "ADSM: Dist Stor Manager" I'm looking for an electronic manual of the Exchange V1.1 software and can't find it on Tivoli's site. Is it there somewhere and I'm missing it? I do have it in paperback but want an electronic link for the email folks. Thanks, Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (888) 997-9614
TDP for Exchange V1.1
I'm looking for an electronic manual of the Exchange V1.1 software and can't find it on Tivoli's site. Is it there somewhere and I'm missing it? I do have it in paperback but want an electronic link for the email folks. Thanks, Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (888) 997-9614
Re: TDP for Exchange V1.1
Go to the http://www.tivoli.com/products/solutions/storage/news.html link, then click on "Publications" (on the right-hand side). On the publications page, click the "Prior versions" link, then scroll down to find the 1.1 version. Regards, Andy Andy Raibeck IBM Tivoli Systems Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "Gill, Geoffrey L." <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 09/17/2001 12:52 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:TDP for Exchange V1.1 I'm looking for an electronic manual of the Exchange V1.1 software and can't find it on Tivoli's site. Is it there somewhere and I'm missing it? I do have it in paperback but want an electronic link for the email folks. Thanks, Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (888) 997-9614
STORServer Backup Appliance Tool & Manager
We are looking into a product called STORServer Manager, an interface with client status reporting, tape management and scheduling control that layers on top of TSM to increase its functionality and ease-of-use. The STORServer backup appliance integrates a backup server, tape library, disk cache and operator display, including TSM, and STORServer Manager. Does anyone have any knowledge (pros or cons) of this backup solution? Thanks! Karen Mikacenic TSG- Information Systems 425 945 5137 (new phone number!!!) 425 562 5257 (fax) [EMAIL PROTECTED] --- Unigard Insurance 15805 NE 24th St. Bellevue, WA 98008
empty tape question
Hi, I have a question about empty tapes needed when TSM does reclamation or migration. We have some empty tapes inside the library and some are outside. How do I force TSM to use the inside one? I found it requested to mount outside empty tapes even there were still some inside the library. Thanks for your help! Best regards, Phillip Guan
Slow restores on Unix
Hello Everybody, We have a customer which can backup up a file of 300mb and get around 12mb/sec but then when they do a restore they only see around 2mb/sec. They also have a number of NT machines when they backup they get around 8-9mb/sec but the restores are the same. The TSM server is an NT4 box running 4.1.3 The client machine is an IBM RS/6000 M80 (AIX 4.3.3) with a TSM client 4.1.3 Any help with the above would be greatly appreciated Cheers Paul http://www.phoenixitgroup.com **Internet Email Confidentiality Footer*** Phoenix IT Group Limited is registered in England and Wales under company number 3476115. Registered Office: Technology House, Hunsbury Hill Avenue, Northampton, NN4 8QS Opinions, conclusions and other information in this message that do not relate to the official business of our firm shall be understood as neither given nor endorsed by it. No contracts may be concluded on behalf of our firm by means of email communications. Confidentiality: Confidential information may be contained in this message. If you are not the recipient indicated (or responsible for delivery of the message to such person), you may not take any action based on it, nor should you copy or show this to anyone; please reply to this email and highlight the error to the sender, then delete the message from your system. Monitoring of Messages: Please note that we reserve the right to monitor and intercept emails sent and received on our network. Warning: Internet email is not 100% secure. We ask you to understand and observe this lack of security when emailing us. We do not accept responsibility for changes made to this message after it was sent Viruses: Although we have taken steps to ensure that this email and any attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free.
Slow restores on Unix
Hello Everybody, We have a customer which can backup up a file of 300mb and get around 12mb/sec but then when they do a restore they only see around 2mb/sec. They also have a number of NT machines when they backup they get around 8-9mb/sec but the restores are the same. The TSM server is an NT4 box running 4.1.3 The client machine is an IBM RS/6000 M80 (AIX 4.3.3) with a TSM client 4.1.3 Any help with the above would be greatly appreciated Cheers Paul http://www.phoenixitgroup.com **Internet Email Confidentiality Footer*** Phoenix IT Group Limited is registered in England and Wales under company number 3476115. Registered Office: Technology House, Hunsbury Hill Avenue, Northampton, NN4 8QS Opinions, conclusions and other information in this message that do not relate to the official business of our firm shall be understood as neither given nor endorsed by it. No contracts may be concluded on behalf of our firm by means of email communications. Confidentiality: Confidential information may be contained in this message. If you are not the recipient indicated (or responsible for delivery of the message to such person), you may not take any action based on it, nor should you copy or show this to anyone; please reply to this email and highlight the error to the sender, then delete the message from your system. Monitoring of Messages: Please note that we reserve the right to monitor and intercept emails sent and received on our network. Warning: Internet email is not 100% secure. We ask you to understand and observe this lack of security when emailing us. We do not accept responsibility for changes made to this message after it was sent Viruses: Although we have taken steps to ensure that this email and any attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free.
Dave Cannon/Tucson/IBM is out of the office.
I will be out of the office starting September 17, 2001 and will not return until October 8, 2001. I will be out of the office from September 17 until October 8 and will have only limited access to e-mail during this period. My schedule: Sept 17 - Sept 21: Business meetings and Oxford TSM Symposium. Sept 24 - Oct 7: Vacation. For urgent issues relating to Tivoli Data Protection for NDMP, please contact Matt Anglin. For other urgent issues, please contact my manager, Kathy Mitton.
Re: ANR7821S Thread 30 (tid 52) terminating on signal 11 (Segmentatio n violation).
I was unable to recreate the problem in a test environment: However I've found a strange (for me) behavior: Server v4.1.4.1 on AIX 4.3.3ML6 (pumba.acit.bg) Client v4.1.3 on AIX (pumba.acit.bg) Client v3.7.2 on OS/2 (pc300-os2.acit.bg) 1. No any backup or archive data tsm: PUMBA.ACIT.BG>show archive pumba.acit.bg * Conversion status for node PUMBA.ACIT.BG (False) tsm: PUMBA.ACIT.BG>show archive pc300-os2.acit.bg * Conversion status for node PC300-OS2.ACIT.BG (False) 2. Backup of single file from AIX client tsm: PUMBA.ACIT.BG>show archive pumba.acit.bg * Conversion status for node PUMBA.ACIT.BG (False) ANR2034E SHOW: No match found using this criteria. 3. Archive of single file from AIX client tsm: PUMBA.ACIT.BG>show archive pumba.acit.bg * Conversion status for node PUMBA.ACIT.BG (False) /home : (DIR) / goldie (MC: DEFAULT) Inserted 09/18/01 08:42:13 /home : (FILE) /goldie/ TSM4140README.DEV (MC: DEFAULT) Inserted 09/18/01 08:42:13 4. Archive of single file from OS/2 client tsm: PUMBA.ACIT.BG>show archive pc300-os2.acit.bg * Conversion status for node PC300-OS2.ACIT.BG (False) OS2 : (DIR) \ (MC: DEFAULT) Inserted 09/18/01 08:46:11 OS2 : (FILE) \ README (MC: DEFAULT) Inserted 09/18/01 08:46:11 BUT: tsm: PUMBA.ACIT.BG>show archive pumba.acit.bg * Conversion status for node PUMBA.ACIT.BG (False) /home : (DIR) / goldie (MC: DEFAULT) Inserted 09/18/01 08:42:13 /home : (FILE) /goldie/ TSM4140README.DEV (MC: DEFAULT) Inserted 09/18/01 08:42:13 (fsId=5) : (DIR) \ (MC: DEFAULT) Inserted 09/18/01 08:46:11 (fsId=5) : (FILE) \ README (MC: DEFAULT) Inserted 09/18/01 08:46:11 So the question is - why it shows data from ANOTHER fileset which resides on ANOTHER node? Zlatko Krastev IT Consultant "Cook, Dwight E" <[EMAIL PROTECTED]> on 17.09.2001 22:31:50 Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject:ANR7821S Thread 30 (tid 52) terminating on signal 11 (Segmentatio n violation). Well, in the following environment Session established with server TSMSRV10: Solaris 2.6 Server Version 4, Release 1, Level 4.0 Server date/time: 09/17/01 14:27:09 Last access: 09/17/01 14:25:39 I've found that a "show archive " of a node that was renamed will kill the tsm server every time ! seems to work OK on straight nodes... only on a node that I renamed does it kill the tsm server process. Not worth calling into tivoli since "show archive" is an unsupported, undocumented, debug command. Just throught I'd pass along advance notice ! "Kids, don't try this at home!" ;-) Dwight
Re: Restoring Large Files
>>The only cure I know of is to move to Win2K. Or to restore that particular file on W2k node and move it over the LAN afterwards. Zlatko Krastev IT Consultant Mark Stapleton <[EMAIL PROTECTED]> on 18.09.2001 08:11:38 Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject:Re: Restoring Large Files On Mon, 17 Sep 2001 09:52:57 -0500, it was written: >I have a single file I need to restore. It is a .bkf file froma winnt >backup. It is 178g. The restore runs at about 20g an hour until it >reaches about 60 or 70 gig. It then slow to 1g per hour. It will >finish in about 28 hours, but the Winnt restore can't restore it. Does >anyone have any experience restoreing a large file with tsm? No >comments about restoreing a nt backup please. (Why are you backing up a Windows backup file? Why not just use TSM to backup your original files?) A thought here... NT has a file size limit of (I think) somewhere in the 190 GB range. You might be butting head awfully close to that wall. The only cure I know of is to move to Win2K. -- Mark Stapleton ([EMAIL PROTECTED])
Re: Restoring Large Files
On Mon, 17 Sep 2001 09:52:57 -0500, it was written: >I have a single file I need to restore. It is a .bkf file froma winnt >backup. It is 178g. The restore runs at about 20g an hour until it >reaches about 60 or 70 gig. It then slow to 1g per hour. It will >finish in about 28 hours, but the Winnt restore can't restore it. Does >anyone have any experience restoreing a large file with tsm? No >comments about restoreing a nt backup please. (Why are you backing up a Windows backup file? Why not just use TSM to backup your original files?) A thought here... NT has a file size limit of (I think) somewhere in the 190 GB range. You might be butting head awfully close to that wall. The only cure I know of is to move to Win2K. -- Mark Stapleton ([EMAIL PROTECTED])
