Hello Roger, daily 1 full DB backup i am keeping . and delete volhistory is also done to get more scratch tapes. its a 3573 lto model library with 44 data slots.
if i generate scratch with in couple of minutes the scratch tapes are using for db bc and comleting with failure. act log ===== >01/27/2015 14:18:23 ANR0299I A full database backup will be started. >The > archive log space used is 82% and the archive >log space > used threshold is 80%. (PROCESS: 28) >01/27/2015 14:18:23 ANR0984I Process 29 for Database Backup started >in the > BACKGROUND at 14:18:23. (PROCESS: 29) >01/27/2015 14:18:23 ANR4559I Backup DB is in progress. (PROCESS: 29) > >01/27/2015 14:18:28 ANR1405W Scratch volume mount request denied - no >scratch > volume available. (PROCESS: 29) Thanks & Regards, Srikanth kola Backup & Recovery IBM India Pvt Ltd, Chennai Mobile: +91 9885473450 From: Roger Deschner <rog...@uic.edu> To: ADSM-L@VM.MARIST.EDU Date: 01/28/2015 01:21 PM Subject: Re: [ADSM-L] req: tsm db backup completed with failure and taking all scratch tapes fro DB BC Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> You've got to free up one or more scratch tape(s) somehow. Either that or decide to write your TSM DB backups somewhere else, such as SAN. There is no way around this. How many Full DB backups are you keeping? Is that more than you need? If so, see the DELETE VOLHISTORY command to get rid of old backups and release scratch tapes. A typical thing is to run a scheduled DELETE VOLHIST TODAY-8 or something like that after a successful rc=0 full database backup. Always make sure you're keeping your most recent FULL database backup and all the incremental backups after it. Do your own inventory of tapes in your tape library, and make sure you can identify what each of them is used for. They will either be VOLUMEs or they'll be listed in the Volume History File for DB backups etc. You may find some free tapes where you did not expect them. Or you may find library slots taken up by defective tapes that can be replaced with good new ones. Just be careful here, not to free a tape with needed data on it. Roger Deschner University of Illinois at Chicago rog...@uic.edu ======I have not lost my mind -- it is backed up on tape somewhere.===== On Wed, 28 Jan 2015, Srikanth Kola23 wrote: >Hi Team, > >Can any one get me out of this problem..... > >tsm server - Version 7, Release 1, Level 1.0 > > Platform: WinNT (windows 2008) > Client OS Level: 6.01 > >DESCRIPTION : DB Backup completing with failure and all scratch volumes >using for DB BC . > >act log >====== > >01/27/2015 14:08:26 ANR0985I Process 28 for Database Backup running >in the BACKGROUND completed with completion state FAILURE at >14:08:26. (PROCESS: 28) >01/27/2015 14:18:23 ANR0299I A full database backup will be started. >The > archive log space used is 82% and the archive >log space > used threshold is 80%. (PROCESS: 28) >01/27/2015 14:18:23 ANR0984I Process 29 for Database Backup started >in the > BACKGROUND at 14:18:23. (PROCESS: 29) >01/27/2015 14:18:23 ANR4559I Backup DB is in progress. (PROCESS: 29) > >01/27/2015 14:18:28 ANR1405W Scratch volume mount request denied - no >scratch > volume available. (PROCESS: 29) >01/27/2015 14:18:30 ANR1626I The previous message (message number >1405) was > repeated 1 times. >01/27/2015 14:18:30 ANR4578E Database backup/restore terminated - >required > volume was not mounted. (PROCESS: 29) >01/27/2015 14:18:30 ANR0985I Process 29 for Database Backup running >in the > BACKGROUND completed with completion state >FAILURE at > 14:18:30. (PROCESS: 29) >01/27/2015 14:18:30 ANR1893E Process 29 for Database Backup completed >with a > completion state of FAILURE. (PROCESS: 29) >01/27/2015 14:21:59 ANR1959I Status monitor collecting current data >at > 14:21:59. >01/27/2015 14:22:15 ANR1960I Status monitor finished collecting data >at > 14:22:15 and will sleep for 15 minutes. >01/27/2015 14:28:26 ANR0299I A full database backup will be started. >The > archive log space used is 82% and the archive >log space > used threshold is 80%. (PROCESS: 29) > > > >Thanks & Regards, > >Srikanth kola >Backup & Recovery >IBM India Pvt Ltd, Chennai >Mobile: +91 9885473450 >
