On the first part, nope, not that I've found...
if you elect to go directly to tape, you want to make sure you have enough
tape drives available when it starts...
This is why I like to go to a diskpool first (even though we are about to
roll out our first "direct to tape" environment)
On the BKI, it is just a warning...
but if you are only using a single archive management class the data
will go to the same storage pool and thus stand a high probability of being
on the same piece of media, main reason to request two copies is to protect
against loss due to media failure. If you are making two copies via backup
storage pool you don't need the TDP side to make two copies but if you are
using backup storage pool to make the copy you still stand the chance of
finding out your media is bad when you go to make the copy.
If you have a bad backup (archive) of a data base file you can go back to
an earlier copy of it and still bring it up to where you need if you have
the archive redo logs... if you don't have your archive redo logs, you can
go no further.
(that is why TDP allows for a push of multiple copies, with the intent of
going to different management classes and thus, hopefully, different pieces
of physical media)
later,
Dwight
-----Original Message-----
From: Gill, Geoffrey L. [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 8:21 AM
To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
Phone: (858) 826-4062
Pager: (888) 997-9614
