ADSM-L

Re: Storage pool usage

2005-11-17 12:17:06
Subject: Re: Storage pool usage
From: Richard Mochnaczewski <Richard.Mochnaczewski AT STANDARDLIFE DOT CA>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 17 Nov 2005 12:13:10 -0500
Hi William,

I checked the activity log for those messages and added them up to 306Gb ( 8 
channels were being used ). The size of the database is actually 540Gb, so we 
are only sending actual used dbf file data to TSM.

Rich

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
William Boyer
Sent: Thursday, November 17, 2005 12:09 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Storage pool usage


Look in the TSM server activity log for these messages that will tell you how 
much data RMAN sent for each backup piece:

ANE4991I (Session: 31803, Node: ORA_HMERPTDB01)  TDP
 Oracle AIX ANU0599 ANU2535I File /adsmorc//0sh3re6u_1_1 =
 20457193472 bytes sent (SESSION: 31803)

Plus, even though the database is allocated at 306GB, RMAN only send you the 
used data, not the whole DBF file that makes up the
database(s).


Bill Boyer
"Some days you're the bug, some days you're the windshield" - ??

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Leigh Reed
Sent: Thursday, November 17, 2005 12:04 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Storage pool usage

Richard,

What did the accounting log say for the transfer ?
I know that you said there was no compression set, but it would be good to know 
that the results from the accounting log for the
session matched that of what was reported in the activity log. You can check 
the accounting log with the following

select bytes,entity,number from summary where entity='nodename' and 
number=session number

Leigh

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Richard Mochnaczewski
Sent: 17 November 2005 15:57
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Storage pool usage

But I never saw any tapes being used by the backup process ?

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of 
David E Ehresman
Sent: Thursday, November 17, 2005 10:30 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Storage pool usage


The client sends an estimate of the amount of data it is sending.  If a file is 
calculated to be too big to fit in the 1st
storagepool, it is written to the 2ndard stgpool (usually tape) instead.

>>> Richard.Mochnaczewski AT STANDARDLIFE DOT CA 11/17/05 10:22 AM >>>
Hi *,

I have a 300Gb storage pool which I used last night to send a 306Gb Oracle 
database using RMAN ( no compression on the backup ). I
checked the usage of the storage pool after the backup, and it only shows 60% 
used. However,I checked the activity log and I
condfirmed that 306Gb of data was sent to the server and I did a q con on the 
volumes in the storage pool and all the files are
there. Shouldn't the storage pool show 100% used ? No migrations ever happened 
during the backup the whole time it ran. Shouldn't a
migration to tape have kicked off as I had exceeded the storage pool capacity ( 
we set migration to 100 during the night to not
allow migrations unless absolutely necessary ) ?

Rich

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