Correction to my previous message - I asked if you really have that many directories in the Oracle dir, when I meant to say do you really have that many other directories on the E: drive?
Paul On Mon, Jul 18, 2011 at 8:54 AM, Paul Fielding <[email protected]> wrote: > Indeed just using the EXCLUDE as I specified will grab the directory tree > still. It's a longer story, but the Reader's Digest version is that doing so > ensure's the TSM BA client GUI can drill down to any given directory to find > files you may have backed up. > > You can't use EXCLUDE.DIR on the "E:\" directory, otherwise you won't get > the Oracle directory either for the reasons I specified previously. > > You could use the EXCLUDE.DIR on all the other directories in E: as > suggested by Gary, but then (also as he suggested) you'll have more > administrative overhead as you need to check periodically to ensure that all > the dirctories in the E: drive are still being excluded - if someone adds a > dir to the E: drive afterwards without telling you, it'll get backed up. > > Andy's suggestion for doing a separate schedule that targets the directory > is actually pretty good, you'd get only the directory you want and don't > risk someone doing something on the server to inadvertently cause you to > start backing up unwanted data. However then you're maintaining a separate > schedule (not really a big deal). > > As far as fear of the DB growing, I would ask you this - do you really have > that many subdirectories in the Oracle dir that you're going to see any kind > of noticable db growth as a result? Even if you have a hundred or a few > hundred other directories there, it is not going to impact your db in any > way that you could ever notice. If you had thousands of subdirs in there, > then yes, I might be a bit concerned, though I'd be less concerned about the > size of the db growth and more concerned about how long it takes to > traverse the directories unnecessarily. In general, though, I've found > that it hasn't been any kind of a super negative impact. > > I would also re-ask the question - are you really, really sure you don't > want to backup anything else on this server, especially the OS? As I > mentioned previously, in most TSM installations, the size difference that > backing up the rest of the data/OS will make to the total storage is small, > and having the ability to restore the odd file here or there if someone > mucks up is worth it's weight in gold.... > > Paul > > > On Mon, Jul 18, 2011 at 6:04 AM, Andrew Raibeck <[email protected]>wrote: > >> Another solution is to use a customized schedule for this node that >> targets >> the desired directory: >> >> DEFINE SCHEDULE domain schedname OBJECTS=E:\Oracle\ OPTIONS=-SUBDIR=YES >> >> And keep the INCLUDE statement in dsm.opt: >> >> Include "E:\Oracle\...\*" 3mth_grp2_MC >> >> Best regards, >> >> Andy Raibeck >> IBM Software Group >> Tivoli Storage Manager Client Product Development >> Level 3 Team Lead >> Internal Notes e-mail: Andrew Raibeck/Hartford/IBM@IBMUS >> Internet e-mail: [email protected] >> >> IBM Tivoli Storage Manager support web page: >> >> http://www.ibm.com/support/entry/portal/Overview/Software/Tivoli/Tivoli_Storage_Manager >> >> "ADSM: Dist Stor Manager" <[email protected]> wrote on 2011-07-18 >> 07:25:48: >> >> > From: "Lee, Gary D." <[email protected]> >> > To: [email protected] >> > Date: 2011-07-18 07:33 >> > Subject: Re: Backup specific folder only >> > Sent by: "ADSM: Dist Stor Manager" <[email protected]> >> > >> > Try the following. >> > >> > Add >> > >> > Exclude.dir e:\dir1 >> > Exclude.dir e:\dir2 >> > . . . >> > >> > For each major tree on the e: drive. This will keep tsm from >> > traversing the trees at all. >> > More administration, but the only thing I can think of. >> > Exclude.dir is processed before standard excludes, therefore you >> > cannot exclude.dir e:\ then include what you wanted. >> > >> > Hope this helps. >> > >> > >> > >> > Gary Lee >> > Senior System Programmer >> > Ball State University >> > phone: 765-285-1310 >> > >> > >> > -----Original Message----- >> > From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf >> Of >> Gibin >> > Sent: Monday, July 18, 2011 2:26 AM >> > To: [email protected] >> > Subject: [ADSM-L] Backup specific folder only >> > >> > Thanks Paul ,Made the changes in the server dsm.opt >> > >> > >> > DOMAIN E: >> > Exclude "E:\...\*" >> > Include "E:\Oracle\...\*" 3mth_grp2_MC >> > >> > >> > Now only files/folders from "E:\Oracle" get backed up.But i noticed >> > a problem when using the mentioned include/exclude , all the sub >> > folders from all the other excluded folders get backed up as >> > well.This i feel can cause unnecessary TSM DB growth .As each file/ >> > folder backed up consumes 4KB of TSM database space. >> > >> > >> > Is there some way to avoid TSM backing up the sub folder structure >> > from all the other excluded directories...?? >> > >> > +---------------------------------------------------------------------- >> > |This was sent by [email protected] via Backup Central. >> > |Forward SPAM to [email protected]. >> > +---------------------------------------------------------------------- >> > >
