Hi,
I am using TDP for SAP R/3 V3.2.0.8 and I would appreciate your help in
accomplishing
the following:
-2 copies of the REDO logs, each copy is to go to a different TSM server
(different sites)
-I would like to switch between the TSM servers on a daily base so that the
on/offline backup on day 1 goes to site A's server and on day 2 goes to site
B (this is easy in the utl except for the fact that 2 days in a week it will
go to the same site)
-If one TSM server isn't available I would like both redolog copies to the
other server and also the on/offline to the other server
All of this to:
-Avoid having to do offsiting through tape to tape copy every day of ~10TB
of SAP data
-To get highly available data as a restore with the new setup should in
worst case involve going back 3 days + redo logs if I have a site failure
(or a TSM server down).
(Tape to tape copy doesn't solve this as it takes ages to do ~10TB a day).
My problem is the setup within one utl file to accomplish both the switch
and the 2 copies of the REDO LOGS. It looks like it is easy for 1 tape drive
used for on/off but it seems that I need to have 3 redolog copies if I would
like to use 2 tape drives for the on/offline backups. (And 4 if using 3
drives). This is a lot of copies to store...
Does anyone of you have a more simpler setup that can do the same trick?
HACMP for TSM will take care of the unavailable TSM server but I will still
need to switch to be able to store the data in two different
libraries/sites. Our SAP gurus prefer to use only one utl file...
Attached is a file with:
-Example 1 with 1 tape drive used for the on/offline backups.
-Example 2 with 2 tape drives used for the on/offline backups, one high
speed LAN.
-Example 3 with 3 tape drives used for the on/offline backups, one high
speed LAN.
-Example 4 with 2 tape drives used for the on/offline backups, one drive per
ATM adapter.
(Redologs goes always first to disk)
<<swich sides.txt>>
Regards,
Jan Norback
Tivoli Certified Consultant: ADSM/TSM
IBM Cert. Adv. Technical Expert RS/6000 AIX
Atos Origin-IT (MS/DS/OSS Unix)
VA-106, PO-box 218, 5600 MD Eindhoven, The Netherlands
Groenewoudseweg 1 5621 BA Eindhoven, The Netherlands
Email: [EMAIL PROTECTED]
Tel: +31 (0)40-2780289
Mobile: +31 (0)6-12994492
Fax : +31 40 2783962
Hi,
I am using TDP for SAP R/3 V3.2.0.8 and I would appreciate your help in accomplishing
the following:
-2 copies of the REDO logs, each copy is to go to a different TSM server (different
sites)
-I would like to switch between the TSM servers on a daily base so that the on/offline
backup on day 1 goes to site A's server and on day 2 goes to site B (this is easy in
the utl except for the fact that 2 days in a week it will go to the same site)
-If one TSM server isn't available I would like both redolog copies to the other
server and also the on/offline to the other server
All of this to:
-Avoid having to do offsiting through tape to tape copy every day of ~10TB of SAP data
-To get highly available data as a restore with the new setup should in worst case
involve going back 3 days + redo logs if I have a site failure (or a TSM server down).
(Tape to tape copy doesn't solve this as it takes ages to do ~10TB a day).
My problem is the setup within one utl file to accomplish both the switch and the 2
copies of the REDO LOGS. It looks like it is easy for 1 tape drive used for on/off but
it seems that I need to have 3 redolog copies if I would like to use 2 tape drives for
the on/offline backups. (And 4 if using 3 drives). This is a lot of copies to store...
Does anyone of you have a more simpler setup that can do the same trick?
HACMP for TSM will take care of the unavailable TSM server but I will still need to
switch to be able to store the data in two different libraries/sites. Our SAP gurus
prefer to use only one utl file...
Below are:
-Example 1 with 1 tape drive used for the on/offline backups.
-Example 2 with 2 tape drives used for the on/offline backups, one high speed LAN.
-Example 3 with 3 tape drives used for the on/offline backups, one high speed LAN.
-Example 4 with 2 tape drives used for the on/offline backups, one drive per ATM
adapter.
(Redologs goes always first to disk)
#####################################################################################
Example 1 with 1 tape drive used for the on/offline backups.
...
MAX_BACK_SESSIONS 1
MAX_ARCH_SESSIONS 2
REDOLOG_COPIES 2
MAX_RESTORE_SESSIONS 1
...
# Days 0 2 4 6 to Site A
#Normal on/offline on 0 2 4 6 and copy 1 of redologs
SERVER SITE_A_DAY_X # Servername
SESSIONS 1 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_1 SAP_LOG_2 # Mngm-Classes
USE_AT 0 2 4 6
#"Failover" on/offline on 0 2 4 6 and copy 2 of redologs
SERVER SITE_B_DAY_X # Servername
SESSIONS 1 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_2 SAP_LOG_1 # Mngm-Classes
USE_AT 0 2 4 6
#Redo log failover on 0 2 4 6 for SITE B
SERVER SITE_A_DAY_X_ALT1 # Servername
SESSIONS 1 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_2 SAP_LOG_1 # Mngm-Classes
USE_AT 0 2 4 6
#Redo log failover on 0 2 4 6 for SITE A
SERVER SITE_B_DAY_X_ALT1 # Servername
SESSIONS 1 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_1 SAP_LOG_2 # Mngm-Classes
USE_AT 0 2 4 6
#Days 1 3 5 to Site B
#Normal on/offline on 1 3 5 and copy 1 of redologs
SERVER SITE_B_DAY_Y # Servername
SESSIONS 1 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_1 SAP_LOG_2 # Mngm-Classes
USE_AT 1 3 5
#"Failover" on/offline on 1 3 5 and copy 2 of redologs
SERVER SITE_A_DAY_Y # Servername
SESSIONS 1 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_2 SAP_LOG_1 # Mngm-Classes
USE_AT 1 3 5
#Redo log failover on 1 3 5 for SITE A
SERVER SITE_B_DAY_Y_ALT1 # Servername
SESSIONS 1 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_2 SAP_LOG_1 # Mngm-Classes
USE_AT 1 3 5
#Redo log failover on 1 3 5 for SITE B
SERVER SITE_A_DAY_Y_ALT1 # Servername
SESSIONS 1 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_1 SAP_LOG_2 # Mngm-Classes
USE_AT 1 3 5
#####################################################################################
Example 2 with 2 tape drives used for the on/offline backups, one high speed LAN.
...
MAX_BACK_SESSIONS 2
MAX_ARCH_SESSIONS 3
REDOLOG_COPIES 3
MAX_RESTORE_SESSIONS 2
...
# Days 0 2 4 6
#Normal on/offline on 0 2 4 6 and copy 1+2 of redologs
SERVER SITE_A_DAY_X # Servername
SESSIONS 2 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_1 SAP_LOG_2 SAP_LOG_3 # Mngm-Classes
USE_AT 0 2 4 6
#"Failover" on/offline on 0 2 4 6 and copy 3 of redologs
SERVER SITE_B_DAY_X # Servername
SESSIONS 2 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_3 SAP_LOG_1 SAP_LOG_2 # Mngm-Classes
USE_AT 0 2 4 6
#Redo log failover on 0 2 4 6 for SITE B
SERVER SITE_A_DAY_X_ALT1 # Servername
SESSIONS 2 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_3 SAP_LOG_1 SAP_LOG_2 # Mngm-Classes
USE_AT 0 2 4 6
#Redo log failover on 0 2 4 6 for SITE A
SERVER SITE_B_DAY_X_ALT1 # Servername
SESSIONS 2 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_2 SAP_LOG_1 SAP_LOG_3 # Mngm-Classes
USE_AT 0 2 4 6
#Days 1 3 5
#Normal on/offline on 1 3 5 and copy 1+2 of redologs
SERVER SITE_B_DAY_Y # Servername
SESSIONS 2 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_1 SAP_LOG_2 SAP_LOG_3 # Mngm-Classes
USE_AT 1 3 5
#"Failover" on/offline on 1 3 5 and copy 3 of redologs
SERVER SITE_A_DAY_Y # Servername
SESSIONS 2 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_3 SAP_LOG_1 SAP_LOG_2 # Mngm-Classes
USE_AT 1 3 5
#Redo log failover on 1 3 5 for SITE A
SERVER SITE_B_DAY_Y_ALT1 # Servername
SESSIONS 2 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_3 SAP_LOG_1 SAP_LOG_2 # Mngm-Classes
USE_AT 1 3 5
#Redo log failover on 1 3 5 for SITE B
SERVER SITE_A_DAY_Y_ALT1 # Servername
SESSIONS 2 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_2 SAP_LOG_3 SAP_LOG_1 # Mngm-Classes
USE_AT 1 3 5
#####################################################################################
Example 3 with 3 tape drives used for the on/offline backups, one high speed LAN.
...
MAX_BACK_SESSIONS 2
MAX_ARCH_SESSIONS 4
REDOLOG_COPIES 4
MAX_RESTORE_SESSIONS 2
...
#
# Days 0 2 4 6
#Normal on/offline on 0 2 4 6 and copy 1+2+3 of redologs
SERVER SITE_A_DAY_X # Servername
SESSIONS 3 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_1 SAP_LOG_2 SAP_LOG_3 SAP_LOG_4 # Mngm-Classes
USE_AT 0 2 4 6
#"Failover" on/offline on 0 2 4 6 and copy 4 of redologs
SERVER SITE_B_DAY_X # Servername
SESSIONS 3 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_4 SAP_LOG_1 SAP_LOG_2 SAP_LOG_3 # Mngm-Classes
USE_AT 0 2 4 6
#Redo log failover on 0 2 4 6 for SITE B
SERVER SITE_A_DAY_X_ALT1 # Servername
SESSIONS 2 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_4 SAP_LOG_1 SAP_LOG_2 SAP_LOG_3 # Mngm-Classes
USE_AT 0 2 4 6
#Redo log failover on 0 2 4 6 for SITE A
SERVER SITE_B_DAY_X_ALT1 # Servername
SESSIONS 2 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_3 SAP_LOG_1 SAP_LOG_2 SAP_LOG_4 # Mngm-Classes
USE_AT 0 2 4 6
#Days 1 3 5
#Normal on/offline on 1 3 5 and copy 1+2 of redologs
SERVER SITE_B_DAY_Y # Servername
SESSIONS 3 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_1 SAP_LOG_2 SAP_LOG_3 SAP_LOG_4 # Mngm-Classes
USE_AT 1 3 5
#"Failover" on/offline on 1 3 5 and copy 4 of redologs
SERVER SITE_A_DAY_Y # Servername
SESSIONS 3 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_4 SAP_LOG_1 SAP_LOG_2 SAP_LOG_3 # Mngm-Classes
USE_AT 1 3 5
#Redo log failover on 1 3 5 for SITE A
SERVER SITE_B_DAY_Y_ALT1 # Servername
SESSIONS 2 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_4 SAP_LOG_1 SAP_LOG_2 SAP_LOG_3 # Mngm-Classes
USE_AT 1 3 5
#Redo log failover on 1 3 5 for SITE B
SERVER SITE_A_DAY_Y_ALT1 # Servername
SESSIONS 2 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_3 SAP_LOG_1 SAP_LOG_2 SAP_LOG_4 # Mngm-Classes
USE_AT 1 3 5
#####################################################################################
Example 4 with 2 tape drives used for the on/offline backups, spread over 2 ATM
adapters.
...
MAX_BACK_SESSIONS 2
MAX_ARCH_SESSIONS 3
REDOLOG_COPIES 3
MAX_RESTORE_SESSIONS 2
...
# Days 0 2 4 6
#Normal on/offline, copy 1, on 0 2 4 6 and copy 1 of redologs
SERVER SITE_A_DAY_X # Servername
SESSIONS 1 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_1 SAP_LOG_2 SAP_LOG_3 # Mngm-Classes
USE_AT 0 2 4 6
#Normal on/offline, copy 2, on 0 2 4 6 and copy 2 of redologs
SERVER SITE_A_DAY_X_ALT1 # Servername
SESSIONS 1 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_2 SAP_LOG_3 SAP_LOG_1 # Mngm-Classes
USE_AT 0 2 4 6
#"Failover" 1 for on/offline on 0 2 4 6 and copy 3 of redologs
SERVER SITE_B_DAY_X # Servername
SESSIONS 1 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_3 SAP_LOG_1 SAP_LOG_2 # Mngm-Classes
USE_AT 0 2 4 6
#"Failover" 2 for on/offline on 0 2 4 6 and failover copy 1 + 2 of redologs
SERVER SITE_B_DAY_X_ALT1 # Servername
SESSIONS 2 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_1 SAP_LOG_2 SAP_LOG_3 # Mngm-Classes
USE_AT 0 2 4 6
#Redo log failover on 0 2 4 6 for SITE B
SERVER SITE_A_DAY_X_ALT2 # Servername
SESSIONS 1 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_3 SAP_LOG_1 SAP_LOG_2 # Mngm-Classes
USE_AT 0 2 4 6
#Days 1 3 5
#Normal on/offline, copy 1, on 1 3 5 and copy 1 of redologs
SERVER SITE_B_DAY_Y # Servername
SESSIONS 1 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_1 SAP_LOG_2 SAP_LOG_3 # Mngm-Classes
USE_AT 1 3 5
#Normal on/offline, copy 2, on 1 3 5 and copy 2 of redologs
SERVER SITE_B_DAY_Y_ALT1 # Servername
SESSIONS 1 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_2 SAP_LOG_3 SAP_LOG_1 # Mngm-Classes
USE_AT 1 3 5
#"Failover" 1 for on/offline on 1 3 5 and copy 3 of redologs
SERVER SITE_A_DAY_Y # Servername
SESSIONS 1 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_3 SAP_LOG_1 SAP_LOG_2 # Mngm-Classes
USE_AT 1 3 5
#"Failover" 2 for on/offline on 1 3 5 and failover copy 1 + 2 of redologs
SERVER SITE_A_DAY_Y_ALT1 # Servername
SESSIONS 2 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_1 SAP_LOG_2 SAP_LOG_3 # Mngm-Classes
USE_AT 1 3 5
#Redo log failover on 1 3 5 for SITE A
SERVER SITE_B_DAY_Y_ALT2 # Servername
SESSIONS 1 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE SID # ADSM Nodename
BRBACKUPMGTCLASS SAP_ON_OFF # Mngm-Classes
BRARCHIVEMGTCLASS SAP_LOG_3 SAP_LOG_1 SAP_LOG_2 # Mngm-Classes
USE_AT 1 3 5
