Just use a small script that checks wether the database is in primary
mode on the node and launch just then the online backup towards TSM.
Then the script can be scheduled on both the primary and standby
database server and you've got yourself always a backup independent
whether a failover was initiated or not.
Regards,
Kurt
-----Oorspronkelijk bericht-----
Van: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Namens
Jacques Van Den Berg
Verzonden: maandag 27 april 2009 20:56
Aan: ADSM-L AT VM.MARIST DOT EDU
Onderwerp: Re: [ADSM-L] DB2 - HADR and TSM
Hi Rainer,
We use HADR in our SAP environment. I tread both nodes as separate TSM
clients. Both nodes have its own node names. You can only backup the
primary node of course. When we do failover we point all our SAP clients
to the secondary system. I then run a scheduled backup on the secondary
node.
Hope this helps.
Kind Regards,
Jacques van den Berg
TSM / Storage / SAP Basis Administrator
Pick 'n Pay IT
Email : jvandenberg AT pnp.co DOT za
Tel : +2721 - 658 1711
Fax : +2721 - 658 1676
Mobile : +2782 - 653 8164
Dis altyd lente in die hart van die mens wat God
en sy medemens liefhet (John Vianney).
-----Original Message-----
From: rainer_holzinger AT web DOT de [mailto:rainer_holzinger AT web DOT de]
Sent: 27 April 2009 08:27 PM
To: Jacques Van Den Berg
Cc: 'ADSM: Dist Stor Manager'
Subject: RE: [ADSM-L] DB2 - HADR and TSM
Hello Jacques,
I was more asking about the ongoing backup procedures if your primary
HADR nodes goes down for some reason and the DB2 database(s) is/are
continued on your standby HADR node. How do you 'failover/failback' your
DB2 backup clients in these situations?
DB2 HADR looks like some Software cluster and backup procedures are
therefore a bit more 'tricky' to implement as this is in HACMP or MSCS
clusters.
Did you manage this somehow?
Best regards,
Rainer
> -----Original Message-----
> From: jvandenberg AT pnp.co DOT za [mailto:jvandenberg AT pnp.co DOT za]
> Sent: Monday, April 27, 2009 4:45 PM
> To: rainer_holzinger AT web DOT de; ADSM-L AT VM.MARIST DOT EDU
> Subject: RE: [ADSM-L] DB2 - HADR and TSM
>
>
> Hi Rainer,
>
> We backup the primary database as per normal with the db2 command to
> TSM. We do a full online backup everyday and archive logs to TSM as
> well. Nothing special.
>
> Kind Regards,
>
> Jacques van den Berg
> TSM / Storage / SAP Basis Administrator
> Pick 'n Pay IT
> Email : jvandenberg AT pnp.co DOT za
> Tel : +2721 - 658 1711
> Fax : +2721 - 658 1676
> Mobile : +2782 - 653 8164
>
> Dis altyd lente in die hart van die mens wat God
> en sy medemens liefhet (John Vianney).
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of
> Rainer Holzinger
> Sent: 27 April 2009 03:33 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: [ADSM-L] DB2 - HADR and TSM
>
> Hi all,
>
>
>
> is somebody having experience to backup DB2 HADR environments with
> TSM?
>
> Or is there some publication available about this scenario?
>
>
>
> Thank you and best regards,
>
> Rainer
>
>
>
> --------------------------------
>
> RHo-Consulting
>
> Rainer Holzinger
>
> Alter Bahnhof 13
>
> D-93093 Donaustauf
>
> phone: +49 9403 969174
>
> mobile: +49 162 2807 888
>
> email: <mailto:rainer.holzinger AT t-online DOT de>
> rainer.holzinger AT t-online DOT de
>
>
>
> CONFIDENTIALITY NOTICE:
>
> This e-mail is confidential and may also be privileged. If you are not
> the intended recipient, please notify the sender IMMEDIATELY; you
> should
> not copy the e-mail or use it for any purpose or disclose its contents
> to any other person.
>
>
>
> VIRUSES:
>
> Although there have been taken steps to ensure that this e-mail and
> attachments are free from any viruses, the recipient should at its
> sole
> discretion take the necessary measures to ensure that the received
> messages are actually virus free.
>
> Read our disclaimer at:
> http://www.picknpay.co.za/pnp/view/pnp/en/page5093?
> If you don't have web access, the disclaimer can be mailed to you on
> request.
> Disclaimer requests to be sent to it-security AT pnp.co DOT za
>
Read our disclaimer at:
http://www.picknpay.co.za/pnp/view/pnp/en/page5093?
If you don't have web access, the disclaimer can be mailed to you on
request.
Disclaimer requests to be sent to it-security AT pnp.co DOT za
*** Disclaimer ***
Vlaamse Radio- en Televisieomroep
Auguste Reyerslaan 52, 1043 Brussel
nv van publiek recht
BTW BE 0244.142.664
RPR Brussel
http://www.vrt.be/disclaimer
|
