ADSM-L

Re: TDP Oracle Question

2004-05-27 08:56:36
Subject: Re: TDP Oracle Question
From: "Kamp, Bruce" <bkamp AT MHS DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 27 May 2004 08:56:00 -0400
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: bkamp AT mhs DOT net
Phone: (954) 987-2020 x4597
Pager: (954) 286-9441
Alphapage: 9542869441 AT archwireless DOT net
Fax: (954) 985-1404
-----------------------------------------------------

-----Original Message-----
From: Greg Kemp [mailto:gkemp AT MAC DOT COM]
Sent: Wednesday, May 26, 2004 12:08 AM
To: ADSM-L AT VM.MARIST DOT EDU
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:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Kamp, Bruce
> Sent: Monday, May 24, 2004 11:34 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: TDP Oracle Question
>
>
> That is set to 200G.....
>
>
> -----------------------------------------------------
> Bruce Kamp
> Senior Midrange Systems Analyst
> Memorial Healthcare System
> E-Mail: bkamp AT mhs DOT net
> Phone: (954) 987-2020 x4597
> Pager: (954) 286-9441
> Alphapage: 9542869441 AT archwireless DOT net
> Fax: (954) 985-1404
> -----------------------------------------------------
>
> -----Original Message-----
> From: Hooft, Jeroen [mailto:Jeroen.Hooft AT ATOSORIGIN DOT COM]
> Sent: Monday, May 24, 2004 8:30 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: TDP Oracle Question
>
> Maybe setting on disk storagepool: "Maximum Size Threshold"?
>
> Jeroen
>
>
> -----Original Message-----
> From: Kamp, Bruce [mailto:bkamp AT MHS DOT NET]
> Sent: maandag 24 mei 2004 14:00
> To: ADSM-L AT VM.MARIST DOT EDU
> 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: bkamp AT mhs DOT net <mailto:bkamp AT mhs DOT net>
> Phone: (954) 987-2020 x4597
> Pager: (954) 286-9441
> Alphapage: 9542869441 AT archwireless DOT net
> 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/
> --------------------------------------------------------
>

<Prev in Thread] Current Thread [Next in Thread>