ADSM-L

Re: [ADSM-L] Help on TDP_R3 Oracle - AIX

2009-08-27 04:30:46
Subject: Re: [ADSM-L] Help on TDP_R3 Oracle - AIX
From: Steven Langdale <Steven.Langdale AT CAT DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 27 Aug 2009 09:29:20 +0100
Yudi

The max throughput of LTO3 is 80 MB/s and LTO4 is 120 - so you've lost 
throughput there.

It looks like (from my very rough calcs) that you were getting approx 
55MB/s average from your LTO3's and LESS than 67MB/s (that's if it 
finished at 10 hours which it isn't)

It looks like the host/backup process is not able to push the drives any 
faster, perhaps you should look here 1st for some perf increases.  Though 
it would be interesting to see the total backup time if you are able to 
let it finish.

The TS3100 is only a single drive lib isn't it....  you may have an issue 
with that.  As an aside, how are you doing reclaims and offsite backups?

Did you or someone else architect this solution, if someone else, get them 
back to fix it...

Thanks

Steven Langdale
Global Information Services
EAME SAN/Storage Planning and Implementation
( Phone : +44 (0)1733 584175
( Mob: +44 (0)7876 216782
ü Conference: +44 (0)208 609 7400 Code: 331817
+ Email: steven.langdale AT cat DOT com

 



Yudi Darmadi <yudi AT NIAGAPRIMA DOT COM> 
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
27/08/2009 06:53
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
Re: [ADSM-L] Help on TDP_R3 Oracle - AIX




Caterpillar: Confidential Green Retain Until: 26/09/2009 



Hi all,

After checkin the anf file, i figure out that there's no error, it's just
slow backup problem..
Our environment has just change the library from 3573 library lto 3 with 2
tape drive, to TS3100 LTO4 with just 1 tape drive, and upgrade TSM version
from v5.3 to v5.5.
Before the change, the SAP backup using 2 LTO cartridge and it takes 6 
hours
(using LANFree backup)
And now the backup takes more than 10 hours i think (it start in 10PM, and
the backup never finished, because we cancel the backup in 8 AM - we don't
do backups in offiice hour, still using LANFree backup). Our DB size is
approx 2.3 TB.
Do you have any idea to increase the backup performance?


Best Regards,


Yudi Darmadi
PT Niagaprima Paramitra
Jl. KH Ahmad Dahlan No.25  Kebayoran Baru, Jakarta Selatan 12130
Phone: 021-72799949; Fax: 021-72799950; Mobile: 081905530830
http://www.niagaprima.com

----- Original Message -----
From: "Gary Bowers" <gbowers AT ITRUS DOT COM>
To: <ADSM-L AT VM.MARIST DOT EDU>
Sent: Friday, August 21, 2009 9:59 PM
Subject: Re: [ADSM-L] Help on TDP_R3 Oracel - AIX


> The alter tablespace command is an Oracle command, not a TSM command.
> If you were getting error with the library manager (TSM), you would
> see problems with allocating a channel.  I would get with your DBA to
> do some investigation on this table.  The BRBACKUP command just issues
> Oracle commands under the covers.
>
> Gary
> Itrus Technologies
>
> On Aug 21, 2009, at 3:10 AM, Yudi Darmadi wrote:
>
>> Dear TSM'ers
>>
>> I have a TDP_R3 Oracle on AIX V5.5.0.0 - and  when
>> I think this is not TSM issue, but i just wanna know does anyone had
>> been
>> experince this case?
>>
>>
>> BR0280I BRCONNECT time stamp: 2009-08-21 08.43.17
>> BR0301E SQL error -600 at location db_file_switch-11
>> ORA-00600: internal error code, arguments: [3664], [3], [1], [4], [0],
>> [1954909839], [0], [1954909839]
>> BR0316E 'Alter tablespace PSAPWPR begin backup' failed
>> BR0280I BRCONNECT time stamp: 2009-08-21 08.43.17
>>
>>
>> Best Regards,
>>
>>
>> Yudi Darmadi
>> PT Niagaprima Paramitra
>> Jl. KH Ahmad Dahlan No.25  Kebayoran Baru, Jakarta Selatan 12130
>> Phone: 021-72799949; Fax: 021-72799950; Mobile: 081905530830
>> http://www.niagaprima.com

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