Re: Database backups
On Fri, 21 Apr 2006, David E Ehresman wrote: If you are able to afford to lose up to a weeks worth of data this seems like a reasonable approach. Since you are only sending your copypools tapes off once a week, if you lose your primary pool you will only be able to restore up to the most recent Friday. We did an back-of-the-envelope for recoverability to expense, and it was shown to not be worth the cost to recover more than one week or so. Our daily incrementals on our main user data servers weigh in at about 5G a day, total. --Jim
Re: Database backups
If you are able to afford to lose up to a weeks worth of data this seems like a reasonable approach. Since you are only sending your copypools tapes off once a week, if you lose your primary pool you will only be able to restore up to the most recent Friday. >>> [EMAIL PROTECTED] 4/21/2006 11:57:16 AM >>> Hi folks, I'm considering a database backup strategy something like this: a. Every day write incremental backups to a FILE devclass on a remote server. b. Every Friday write a full backup to the same remote FILE devclass. c. We take our copypool tapes out on Friday as well, so I would additionally generate a db snapshot to tape and remove it from the library at the same time. Does this seem to pass muster? My reasoning for the FILE backups is that I'd like to have a db backup in case the RAID/filesystem holding my online DB breaks, but I'm uninterested in buying a number of LTO2 tapes just to write a 24 gigabyte file to them. --Jim
Re: Database Backups
Hello, On Montag, 18. November 2002 20:39, Taha, Hana wrote: > Hello TSMers, > > This is probably a very basic question to some of you, but one that has had > me going crazy for the last two weeks. > > My problem is this I have two schedules to perform database backups. > One is full and the other is incremental. See my schedules below. > - snip .. > > > My question is this: Why am I getting database backups on days that I am > not supposed to get dbb's? On saturday, I logged in and I had delete 8 > dbb's to free up some tapes for our full backups. This mess is eating up > all my scratch tapes. > This morning, I logged in and I had a backup done on Sunday and two done > today. Are you running your recovery log in rollforward mode and have you defined a backup trigger? Then you will get backups of the db if the rec.log fills up. Greetings from Hamburg Rolf Meyer Info Business Systems GmbH 22607 Hamburg, Germany
Re: Database Backups
Do you have roll-forward mode enabled or database backup trigger enabled? Do a 'Q ST' and see if you do. If so, you might have to set your database backup trigger higher than its set now. Rob. From: "Taha, Hana" <[EMAIL PROTECTED]> on 11/18/2002 02:39 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: Database Backups Hello TSMers, This is probably a very basic question to some of you, but one that has had me going crazy for the last two weeks. My problem is this I have two schedules to perform database backups. One is full and the other is incremental. See my schedules below. Schedule NameADSM_DATABASE_BACKUP Description Full backup of ADSM Database Command backup db dev=8mmexdev type=full Priority 5 Start date 2002-06-24 Start time 06:00:00 Duration 10 Duration units MINUTES Period 1 Period units DAYS Day of Week MONDAY Expiration - Active? YES Last Update Date/Time2002-06-25 13:47:24.00 Last Update by (administrator) HANA Managing profile - Schedule NameADSM_DATABASE_BACKUP_INCR Description Incremental Backup of ADSM Database on Thurs. ONLY Command ba db dev=8mmexdev t=incr Priority 5 Start date 2002-03-18 Start time 06:00:00 Duration 15 Duration units MINUTES Period 1 Period units DAYS Day of Week THURSDAY Expiration - Active? YES Last Update Date/Time2002-06-25 13:47:40.00 Last Update by (administrator) HANA Managing profile - My question is this: Why am I getting database backups on days that I am not supposed to get dbb's? On saturday, I logged in and I had delete 8 dbb's to free up some tapes for our full backups. This mess is eating up all my scratch tapes. This morning, I logged in and I had a backup done on Sunday and two done today. I was only expecting to see one backup performed this morning at 6am. So where am I going wrong. Is the schedule working as it should, or am I correct that I have a problem? Please review the Activity log below for more information. Thanks in advance! Date/Time: 11/17/02 08:00:11 Volume Type: BACKUPFULL Backup Series: 396 Backup Operation: 0 Volume Seq: 1 Device Class: 8MMEXDEV Volume Name: 0021 Volume Location: Command: Date/Time: 11/18/02 06:00:10 Volume Type: BACKUPFULL Backup Series: 397 Backup Operation: 0 Volume Seq: 1 Device Class: 8MMEXDEV Volume Name: 0050 Volume Location: Command: Date/Time: 11/18/02 08:00:04 Volume Type: BACKUPFULL Backup Series: 398 Backup Operation: 0 Volume Seq: 1 Device Class: 8MMEXDEV Volume Name: 0076 Volume Location: Command: Operation Results Date/Time Message -- 11/11/02 15:30:18 ANR2017I Administrator HANA issued command: QUERY EVENT ADSM_DATABASE_BACKUP TYPE=ADMIN BEGINDATE=11/11/2002 BEGINTIME=00:00 ENDDATE=11/11/2002 ENDTIME="15:30:06 " EXCEPTIONSONLY=NO FORMAT=STANDARD 11/12/02 08:00:12 ANR0984I Process 330 for DATABASE BACKUP started in the BACKGROUND at 08:00:12. 11/12/02 08:00:12 ANR2280I Full database backup started as process 330. 11/12/02 08:01:50 ANR4554I Backed up 8496 of 68093 database pages. 11/12/02 08:01:57 ANR4554I Backed up 16992 of 68093 database pages. 11/12/02 08:02:03 ANR4554I Backed up 25488 of 68093 database pages. 11/12/02 08:02:11 ANR4554I Backed up 33984 of 68093 database pages. 11/12/02 08:02:17 ANR4554I Backed up 42480 of 68093 database pages. 11/12/02 08:02:24 ANR4554I Backed up 50976 of 68093 database pages. 11/12/02 08:02:30 ANR4554I Backed up 59472 of 68093 database pages. 11/12/02 08:02:50 ANR4554I Backed up 67968 of 68093 database pages. 11/12/02 08:02:59 ANR4550I Full database backup (process 330) complete, 68093 pages copied. 11/12/02 08:02:59 ANR0985I Process 330 for DATABASE BACKUP running in the BACKGROUND completed with completion state SUCCESS at 08:02:59. 11/13/02 08:00:16 ANR0984I Process 337 for DATABASE BACKUP started in the BACKGROUND at 08:00:16. 11/13/02 08:00:16 ANR2280I Full database backup started as process 337. 11/13/02 08:01:32 ANR4554I Backed up 8512 of 68099 database pages. 11/13/02 08:01:41 ANR4554I Backed up 17024 of 68099 database pages. 11/13/02 08:01:50 ANR4554I Backed up 25536 of 68099 database pages. 11/13/02 08:01:59 ANR4554I Backed up 34048 of 68099 database pages. 11/13/02 08:02:09 ANR4554I Backed up 42560 of 68099 database pages. 11/13/02 08:02:18 ANR4554I Backed up 51072 of