ADSM-L

Re: SAP backup

2001-09-24 10:32:26
Subject: Re: SAP backup
From: "Kauffman, Tom" <KauffmanT AT NIBCO DOT COM>
Date: Mon, 24 Sep 2001 09:20:37 -0500
The backup will run as you wish. Your problem seems to be that you have
MAX_SESSIONS set to 4 but your server stanza down at the bottom of the
config only has SESSIONS 2. The way backint works, MAX_SESSIONS is the true
control - you WILL run this many sessions, and if you don't have that many
available, the backup fails. The servers will be used in the order specified
in the init<SID>.utl file until MAX_SESSIONS is reached.

My servers list looks like this:

SERVER          thames-bu1                                # Servername
    SESSIONS            2                               # Max sessions
    PASSWORDREQUIRED    YES                             # Use a password
    BRBACKUPMGTCLASS    prdsap-lt-orig                     # Mngm-Classes
    BRARCHIVEMGTCLASS   prdlog1 prdlog2                 # Mngm-Classes
    USE_AT              0 1 2 3 4 5 6                   # Days for backup

SERVER          thames-bu2                                # Servername
    SESSIONS            3                               # Max sessions
    PASSWORDREQUIRED    YES                             # Use a password
    BRBACKUPMGTCLASS    prdsap-lt-orig                     # Mngm-Classes
    BRARCHIVEMGTCLASS   prdlog1 prdlog2                 # Mngm-Classes
    USE_AT              0 1 2 3 4 5 6                   # Days for backup

SERVER          thames                                # Servername
    SESSIONS            1                               # Max sessions
    PASSWORDREQUIRED    YES                             # Use a password
    BRBACKUPMGTCLASS    prdsap-lt-orig                     # Mngm-Classes
    BRARCHIVEMGTCLASS   prdlog1 prdlog2                 # Mngm-Classes
    USE_AT              0 1 2 3 4 5 6                   # Days for backup

SERVER          thames-pri                                      # Servername
    SESSIONS            2                               # Max sessions
    PASSWORDREQUIRED    YES                             # Use a password
    BRBACKUPMGTCLASS    prdsap-lt-orig                     # Mngm-Classes
    BRARCHIVEMGTCLASS   prdlog1 prdlog2                 # Mngm-Classes
    USE_AT              0 1 2 3 4 5 6                   # Days for backup

These are all server names listed in my dsm.sys
(/usr/lpp/adsm/api/bin/dsm.sys or /usr/tivoli/tsm/client/api/bin/dsm.sys).
Thames-bu1 and thames-bu2 are gigabit ethernet; thames and thames-pri are
100Mb ethernet. Normal mode will run two sessions over thames-bu1 and two
over thames-bu2; if thames-bu1 is not available for some reason, I'll have
three sessions over thames-bu2 and a session on thames. Each session goes
direct to tape. If a tape drive is not available, the session will hang
waiting media (status MEDIAW). I've had sessions in MEDIAW for over four
hours with no problem.

My database is currently 565 GB and backs up in about 2 hours 45 minutes
with LTO tape drives.

Tom Kauffman
NIBCO, Inc

> -----Original Message-----
> From: Gill, Geoffrey L. [mailto:GEOFFREY.L.GILL AT SAIC DOT COM]
> Sent: Monday, September 24, 2001 8:21 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: SAP backup
>
>
> Our first try with the SAP backup resulted in a failure
> because of only 2
> tape drives available when it requested 4. This doesn't make
> sense to me so
> maybe someone can explain. Why wouldn't the backup run and
> just start using
> the 2 drives. Then when the other 2 came available it pick
> them up instead
> of just failing?
>
> Is there something I can tell the SAP people that will remedy this?
>
> Is this a problem or just an information message?
> BKI0120W: If you want 2 REDOLOGCOPIES on the ADSM-Servers used
>           you should give me at least 2 different Archive Management
> Classes.
>
> Thanks for the help...
> Geoff
>
>
> ****************************************
> SAP ONLINE BACKUP DATABASE
> Fri Sep 21 20:00:01 PDT 2001
> BR051I BRBACKUP 4.5B (40)
> BR055I Start of database backup: bdggtxzu.pnf 2001-09-21 20.00.02
> Call to sslssreghdlr Succeeded
>
> BR319I Control file copied to /oracle/D11/sapbackup/cntrl.dbf
>
> BR280I Time stamp 2001-09-21 20.00.22
> BR057I Backup of database: D11
> BR058I BRBACKUP action ID: bdggtxzu
> BR059I BRBACKUP function ID: pnf
> BR110I Backup mode: PARTIAL
> BR060I Tablespaces for backup:
> PSAPCLUD,PSAPSTABI
> BR077I Database file for backup: /oracle/D11/sapbackup/cntrl.dbf
> BR061I 11 files found for backup, total size 19946.148 MB
> BR143I Backup type: online
> BR130I Backup device type: util_file
> BR109I Files will be saved by backup utility
> BR126I Unattended mode active - no operator confirmation required
> Call to sslssreghdlr Succeeded
>
> BR280I Time stamp 2001-09-21 20.00.23
> BR315I 'Alter tablespace PSAPCLUD begin backup' successful
>
> BR280I Time stamp 2001-09-21 20.00.23
> BR315I 'Alter tablespace PSAPSTABI begin backup' successful
>
> BR280I Time stamp 2001-09-21 20.00.23
> BR229I Calling backup utility...
> BR278I Command output of '/usr/sap/D11/SYS/exe/run/backint -u
> D11 -f backup
> -i /oracle/D11/sapbackup/.bdggtxzu.lst -t file -p
> /oracle/D11/dbs/initD11.utl -c':
>
>
>   You have installed a wrong NLS message catalog file (backint.cat).
>   Now we use the default language settings.
>
>
>                    BACKINT/ADSTAR Distributed Storage Manager
>
>   Interface between SAPDBA Utilities and IBM ADSTAR
> Distributed Storage
> Manager
>                  - Version 2, Release 3, Level 5.1 for OSF/1 -
>         (c) Copyright IBM Corporation, 1993, 1998, All Rights
> Reserved.
>
>                            Program Number : 5799-QZG
>
>
> BKI0016E: Not enough sessions available (4 required and 2 available).
> BKI0120W: If you want 2 REDOLOGCOPIES on the ADSM-Servers used
>           you should give me at least 2 different Archive Management
> Classes.
>
>   -- Parameters --
> Input File         : /oracle/D11/sapbackup/.bdggtxzu.lst
> Output File        : stdout
> Profile            : /oracle/D11/dbs/initD11.utl
> Configfile         : /oracle/D11/dbs/initD11.bki
> Parallel sessions  : 4
> RL compression     : disabled
> Exit on error      : disabled
> BATCH              : enabled
> Versioning         : disabled
> Backup Type        : file
> ADSM server        : ADSM with 2 sessions configured, using 2 sessions
>  Days for backups  : Sun Mon Tue Wed Thu Fri Sat
>  Backup mgmt class : [MDB] DEFAULT
>  Archiv mgmt class : [MLOG1] [MLOG2] DEFAULT
>
>
> BKI0020I: End of backint program at: Fri Sep 21 20:00:25 2001.
> BKI0021I: Elapsed time: 01 sec.
> BR280I Time stamp 2001-09-21 20.00.25
> BR279E Return code from '/usr/sap/D11/SYS/exe/run/backint -u
> D11 -f backup
> -i /oracle/D11/sapbackup/.bdggtxzu.lst -t file -p
> /oracle/D11/dbs/initD11.utl -c': 2
>
> BR232E 0 of 11 files saved by backup utility
> BR231E Backup utility call failed
> Call to sslssreghdlr Succeeded
>
> BR280I Time stamp 2001-09-21 20.00.28
> BR317I 'Alter tablespace PSAPCLUD end backup' successful
>
> BR280I Time stamp 2001-09-21 20.00.28
> BR317I 'Alter tablespace PSAPSTABI end backup' successful
>
> BR056I End of database backup: bdggtxzu.pnf 2001-09-21 20.00.25
> BR054I BRBACKUP terminated with errors
> ****************************************
> ****************************************
> CAT LOG TO HISTORY
> Fri Sep 21 20:00:28 PDT 2001
> ****************************************
> ****************************************
> Fri Sep 21 20:00:28 PDT 2001
> END OF ONLINE BACKUP
> ****************************************
>
> Geoff Gill
> TSM Administrator
> NT Systems Support Engineer
> SAIC
> E-Mail:   gillg AT saic DOT com
> Phone:  (858) 826-4062
> Pager:   (888) 997-9614
>
<Prev in Thread] Current Thread [Next in Thread>