Here you go. Policy Domain Name C1_ORA_AGENT Policy Set Name ACTIVE Mgmt Class Name STANDARD Copy Group Name STANDARD Versions Data Exists 1 Versions Data Deleted 0 Retain Extra Versions 1 Retain Only Version 0 Copy Mode MODIFIED Copy Serialization SHRSTATIC Copy Frequency 0 Copy Destination C1_ORA_DISK_POOL
DSMI_ORC_CONFIG /usr/tivoli/tsm/client/api/bin/dsm.opt DSMI_LOG /tmp TDPO_NODE xyz_oracle_prod816 TDPO_OWNER oracle TDPO_PSWDPATH /usr/tivoli/tsm/client/oracle/bin TDPO_NUM_BUFFERS 10 TDPO_FS xyz_oracle_prod816 * TDPO_TRACE_FLAGS orclevel0 orclevel1 orclevel2 * TDPO_TRACE_FILE /usr/tivoli/tsm/client/oracle/bin64/tdpo_trace.out * TDPO_OWNER <username> * TDPO_AVG_SIZE <user_define> ***Not needed for Oracle 8.1.x * TDPO_MGMT_CLASS_2 <class_name> * TDPO_MGMT_CLASS_3 <class_name> * TDPO_MGMT_CLASS_4 <class_name> Thanks, ----------------------------------------------------- Bruce Kamp Senior Midrange Systems Analyst Memorial Healthcare System E-Mail: [EMAIL PROTECTED] Phone: (954) 987-2020 x4597 Pager: (954) 286-9441 Alphapage: [EMAIL PROTECTED] Fax: (954) 985-1404 ----------------------------------------------------- -----Original Message----- From: Prasad, Mahesh (IDS ECCS) [mailto:[EMAIL PROTECTED] Sent: Thursday, May 27, 2004 9:04 AM To: [EMAIL PROTECTED] Subject: Re: TDP Oracle Question Bruce, The management class you have shown over here is not the default management class. Can you please send the backup copy group details of the default management class and details of the tdpo.opt file? Regards, Mahesh Prasad -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Kamp, Bruce Sent: Thursday, May 27, 2004 8:56 AM To: [EMAIL PROTECTED] Subject: Re: TDP Oracle Question I'm still at a loss.... Here is my setup: Mgmt Class: Policy Domain Name C1_ORA_AGENT Policy Set Name ACTIVE Mgmt Class Name C1_ORACLE_MGMT_CLASS Default Mgmt Class ? No Description C1 Oracle Agent MGMT Class Space Management Technique NONE Auto-Migrate on Non-Use 0 Migration Requires Backup? NO Migration Destination C1_ORA_DISK_POOL Backup Copy Group: Policy Domain Name C1_ORA_AGENT Policy Set Name ACTIVE Mgmt Class Name C1_ORACLE_MGMT_CLASS Copy Group Name STANDARD Versions Data Exists 1 Versions Data Deleted 0 Retain Extra Versions 1 Retain Only Version 0 Copy Mode MODIFIED Copy Serialization SHRSTATIC Copy Frequency 0 Copy Destination C1_ORA_DISK_POOL Disk Storage Pool: Storage Pool Name C1_ORA_DISK_POOL Storage Pool Type PRIMARY Device Class Name DISK Estimated Capacity (MB) 200272.0 Pct Util 15.8 Pct Migr 15.8 Pct Logical 100.0 High Mig Pct 90 Low Mig Pct 70 Migration Processes 4 Next Storage Pool C1_ORA_TAPE_POOL Maximum Size Threshold - Access READWRITE Description C1 Oracle Disk Pool When I look at the disk storage pool it is only 10-15% percent utilized. Also the only migration I see is the one I do during my normal daily processing. Any more ideas? Thanks, ----------------------------------------------------- Bruce Kamp Senior Midrange Systems Analyst Memorial Healthcare System E-Mail: [EMAIL PROTECTED] Phone: (954) 987-2020 x4597 Pager: (954) 286-9441 Alphapage: [EMAIL PROTECTED] Fax: (954) 985-1404 ----------------------------------------------------- -----Original Message----- From: Greg Kemp [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 12:08 AM To: [EMAIL PROTECTED] Subject: Re: TDP Oracle Question TSM does not lock the total required space for a backup in a storage pool before the actual backup starts or while in progress. TSM fills the defined devices for a management class in order of definition until the storage pool is full or the backup completes. Fill your disks and TSM moves on to the tape pool or some other defined device. Bruce.... If the MAXSIZE threshold on your disk pool is set to 200GB (which is excessive) and you have 133GB available there is no reason the backup isn't ending up on disk. Double check your management class for both the backup and archive copy pools. TDP for Oracle uses the 'BACKUP' copy group which in your case should point to the disk pool. TDP does not use the 'ARCHIVE' copy group. I have been bitten by this one in the past. Regards, Greg On May 24, 2004, at 8:53 AM, Wholey, Joseph (IDS DM&DS) wrote: > Bruce, > > You should make sure that the percentage utilized in your storage pool > is 0% prior to running your backup. Also, are any other backups > running. Keep in mind that once TSM sees that it's going to need > 133Gig of disk to backup the Oracle db, it will attempt to lock that > amount of the stg pool. If the full amount is not available, it will > go to the "next" stg pool. > > Regards, Joe > > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of > Kamp, Bruce > Sent: Monday, May 24, 2004 11:34 AM > To: [EMAIL PROTECTED] > Subject: Re: TDP Oracle Question > > > That is set to 200G..... > > > ----------------------------------------------------- > Bruce Kamp > Senior Midrange Systems Analyst > Memorial Healthcare System > E-Mail: [EMAIL PROTECTED] > Phone: (954) 987-2020 x4597 > Pager: (954) 286-9441 > Alphapage: [EMAIL PROTECTED] > Fax: (954) 985-1404 > ----------------------------------------------------- > > -----Original Message----- > From: Hooft, Jeroen [mailto:[EMAIL PROTECTED] > Sent: Monday, May 24, 2004 8:30 AM > To: [EMAIL PROTECTED] > Subject: Re: TDP Oracle Question > > Maybe setting on disk storagepool: "Maximum Size Threshold"? > > Jeroen > > > -----Original Message----- > From: Kamp, Bruce [mailto:[EMAIL PROTECTED] > Sent: maandag 24 mei 2004 14:00 > To: [EMAIL PROTECTED] > Subject: TDP Oracle Question > > > I'm trying to give enough disk to my Oracle backups but have not been > successful. My management classes point to disk. How do I find out > how > much disk TSM is looking for to backup straight to disk? I looked on > the > system & saw that the dbf files added up to about 133G I have given it > 200G. > Or is there something else that could be pointing to tape instead of > disk? > I'm running TSM 5.2.1.2 on AIX 5.1. The client is running TSM > 5.1.5.11 & > TDP Oracle ver 2.2.0.1 with Oracle 8.1.7.4. > > > Thanks, > ----------------------------------------------------- > Bruce Kamp > Senior Midrange Systems Analyst > Memorial Healthcare System > E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > Phone: (954) 987-2020 x4597 > Pager: (954) 286-9441 > Alphapage: [EMAIL PROTECTED] > Fax: (954) 985-1404 > ----------------------------------------------------- > -------------------------------------------------------- > > If you are not an intended recipient of this e-mail, please notify the > sender, delete it and do not read, act upon, print, disclose, copy, > retain or redistribute it. Click here for important additional terms > relating to this e-mail. http://www.ml.com/email_terms/ > -------------------------------------------------------- > ============================================================================ == If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. <http://www.ml.com/email_terms/> ============================================================================ ==
