I like Kyle's order, especially if you don't have time to do the migrate
before your tape handlers arrive to move the tapes off-site.
Two other minor points: the first dbbackup is good but doesn't quite reflect
what's what as tapes will not be in the correct places after the restore.
The last of the dr tapes will show in the database as having been on-site
when in fact they were not. Minor problem. This shows up especially when
using DRM. The last of the these DR tapes will be marked destroyed by the
DRM scripts. So, you have to fix up the scripts a bit.
Another point is you can use a backup db type=dbsnapshot to make one of the
backups. This does not disturb the backup "series".
Kelly J. Lipp
Storage Solutions Specialists, Inc.
PO Box 51313
Colorado Springs CO 80949-1313
(719) 531-5926
Fax: (719) 260-5991
Email: [EMAIL PROTECTED]
www.storsol.com
www.storserver.com
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Werner Nussbaumer
Sent: Monday, August 14, 2000 7:39 AM
To: [EMAIL PROTECTED]
Subject: Re: BACKUP STGPOOL and BACKUP DB Question
Thank you also for your information.
Kind regards
Werner Nussbaumer
-----Original Message-----
From: payne [mailto:[EMAIL PROTECTED]]
Sent: Freitag, 11. August 2000 17:28
To: ADSM-L
Cc: payne
Subject: Re: BACKUP STGPOOL and BACKUP DB Question
We do:
1) Backup Disk
2) Backup Tape
3) Backup DB
4) Run checkouts to get tapes off site.
5) Migrate
6) Expire
7) Backup DB
8) Run Checkin of scratch tapes to fill library (This could be done as part
of step 4 as well).
The first DB backup will be use for Disaster Recover of the server. There
is no need to migrate data on onsite storage pools because you won't be
using the primary pools at a DR. The second DB backup will be used if you
have to restore your DB because of corruption. In this case it is best to
have the data migrated so you don't have to restore data to disk.
Kyle
[EMAIL PROTECTED]
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Werner Nussbaumer
Sent: Friday, August 11, 2000 9:20 AM
To: [EMAIL PROTECTED]
Subject: BACKUP STGPOOL and BACKUP DB Question
Hello All
I set up a storage pool DISKPOOL, a tape pool DLTPOOL1 (4 tapes) and a
copypool
DLTPOOL2 (4 tapes).
DISKPOOL is migrated to the next pool DLTPOOL1. After that I would do a
BACKUP STGPOOL DISKPOOL1 DLTPOOL2
and
BACKUP STGPOOL DLTPOOL1 DLTPOOL2
and finally
BACKUP DB DEVCLASS=DLTCLASS1 SCRATCH=NO TYPE=FULL VOLUMENAMES=TAPE1,TAPE2
BACKUP DB DEVCLASS=DLTCLASS2 SCRATCH=NO TYPE=FULL
VOLUMENAMES=TAPE101,TAPE102
What is the best scenario to
1) Migrate
2) backup the diskpool
3) backup the tape pool
4) Backup DB
5) Create a second backup of the DB?
Thanks for any information
Regards
Werner Nussbaumer
