Question

TSM inclexcl.list is incorrect and I can't seem to get it to exclude what I want. How can I fix this?

Asked by: greatmich

My big goal is that I want nothing under /u01/oradata or /u03/oradata backed up via TSM because they are oracle files, and I don't need them backed up. What is the syntax on how to do that. It is still backing them up. There are other directories under /u01 and / u03 that I want backed up, so I want to just exclude those for right until I understand the syntax of this file.

*EXCLUDE         /u01/*
EXCLUDE.DIR     /u01/oradata/
include         /u01/app/.../*
EXCLUDE         /u02/*
EXCLUDE.DIR     /u02
EXCLUDE.DIR     /u03/oradata
include         /u03/backups/.../*
EXCLUDE         /tsmdb/*
EXCLUDE.DIR     /tsmdb
EXCLUDE         /tsmlog/*
EXCLUDE.DIR     /tsmlog
EXCLUDE         /osupdates/*
EXCLUDE.DIR     /osupdates

                                  
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:

Select allOpen in new window

This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

  • Plus...
  • 30 Day FREE access, no risk, no obligation
  • Collaborate with the world's top tech experts
  • Unlimited access to our exclusive solution database
  • Never be left without tech help again

Subscribe Now

Asked On
2009-05-29 at 05:34:01ID24448037
Tags

TSM

,

inclexcl.list

,

Tivoli

Topics

Tivoli Storage Manager

,

IBM AIX Unix

Participating Experts
2
Points
500
Comments
22

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

  • "The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
  • "Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
  • "Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.

Screenshot of Experts Exchange Knowledgebase

Need individual assistance?

Our experts are ready to help.

If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.

Screenshot of Experts Exchange Knowledgebase

Want to learn from the best?

Read articles from industry experts.

Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.

Screenshot of an Article

Working on a long term project?

Store your work and research.

Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.

Screenshot of Experts Exchange Knowledgebase

Access the answers to your technology questions today.

Subscribe Now

30-day free trial. Register in 60 seconds.

What Makes Experts Exchange Unique?

Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Trusted by the world's most respected brands.

image of each brand's logo

Faithfully serving IT professionals since 1996.

Experts Exchange Logo

Try it out and discover for yourself.

Subscribe Now

30-day free trial. Register in 60 seconds.

Related Solutions

  1. MIN excluding zeros function
    I need a user defined function that works like the MIN function but excludes zeros. I know I can do this via a formula but due to space constraints I need something very short. Thanks!!
  2. tar --exclude
    I want to tar up a large directory. I want to exclude some specific archive sub-directories and previous application release sub-directories. My company does not allow open source tools like gnu tar, which I beieve has an --exclude option to tar. How is the best way to exclu...
  3. excluding MP3
    Hello there. I need to create a batch file where I can copy a users “ My Docs” to a share on the network were I’ll be able to included in the daily backup. Here is my question: how can I accomplish this but at the same time exclude any mp3 and wmp? May be there’s a tool that...
  4. Exclude a table when export
    Hi Experts, I'm using Oracle 8.1.7 on Solaris 9. Currently, to export tables, there's a script do this as below (only part of them, this is to export all tables): $ORACLE_HOME/bin/exp BUFFER=100000 FILE=/export/oradata/${ORACLE_SID}/export/${user}1exp.dmp COMPRESS=Y GRANTS=...

Free Tech Articles

  1. WARNING: 5 Reasons why you should NEVER fix a computer for free.
    It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
  2. SCCM OSD Basic troubleshooting
    SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
  3. Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
    This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
  4. Create a Win7 Gadget
    This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
  5. Outlook continually prompting for username and password
    There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
  6. Backup Exchange 2010 Information Store using Windows Backup
    There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...

Cloud Class Webinars

  1. Avoiding Bugs in Microsoft Access
    Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
  2. Top 10 Best New Features in Visio 2010
    Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
  3. IT Consultant Business Secrets Revealed
    Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
  4. Disaster Recovery and Business Continuity
    Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
  5. Organize Your Visio Diagrams with Containers and Lists
    Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
  6. How to Us Objects, Properties, Events and Methods in Microsoft Access
    Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...

Join the Community

Give a Little. Get a Lot.

Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.

Join the Community

Answers

 

by: woolmilkporcPosted on 2009-05-29 at 05:46:44ID: 24502294

Hi,

first I would recommend that you exclude only files, so that the directory structure can be recovered, if needed.

Second, you'll have to keep in mind thet the exclude/include directives are processed bottom-up, the last entry is processed first, and processing stops when a match is found.

Third, you don't need a separate inclexcl file anymore. Just put the statements into your dsm.sys file under the appropriate server stanza.

OK, I would recommend

EXCLUDE.FILE /u01/oradata/.../*

EXCLUDE.FILE /u03/oradata/.../*

A similar setup works for me without any problem.

I see you're already familiar with the '...' syntax. This is TSM specific and just means 'any directory'.

wmp

 

by: greatmichPosted on 2009-05-29 at 06:00:12ID: 24502407

alright I will try that but will not know until monday. Since I don't have authority to kick it off during the day.  Thanks and will let you know.

 

by: gheistPosted on 2009-05-29 at 15:10:15ID: 24506613

exclude.dir excludes directory and everything behind.

exclude.dir /.../oradata

will exclude all oradata directories

 

by: greatmichPosted on 2009-06-04 at 08:43:51ID: 24548218

still did not work, sorry for the delay
This is the inclexcl.list
EXCLUDE.FILE    /u01/oradata/.../*
include         /u01/app/.../*
EXCLUDE         /u02/*
EXCLUDE.DIR     /u02
include.file    /u03/backups/.../*
EXCLUDE.FILE    /u03/oradata/.../*
EXCLUDE.FILE    /u01/app/oracle/product/10.2.0/rdbms/audit/.../*
EXCLUDE         /tsmdb/*
EXCLUDE.DIR     /tsmdb
EXCLUDE         /tsmlog/*
EXCLUDE.DIR     /tsmlog
EXCLUDE         /osupdates/*
EXCLUDE.DIR     /osupdates

here is some snippets of the output


06/04/09   03:32:40 Normal File-->        52,429,312 /u01/oradata/ODS/redo_ODS_01a.log [Sent]
06/04/09   03:32:44 Normal File-->        52,429,312 /u01/oradata/ODS/redo_ODS_04a.log [Sent]
06/04/09   03:32:49 Normal File-->        52,429,312 /u01/oradata/ODS/redo_ODS_05a.log [Sent]
06/04/09   03:37:24 Retry # 3  Normal File-->         5,980,160 /u03/oradata/APPWORX/ctrl_APPWORX_03.ctl  Changed
06/04/09   03:37:24 Retry # 4  Normal File-->         5,980,160 /u03/oradata/APPWORX/ctrl_APPWORX_03.ctl  Changed
06/04/09   03:37:24 Retry # 5  Normal File-->         5,980,160 /u03/oradata/APPWORX/ctrl_APPWORX_03.ctl [Sent]

I will try the exclude.dir /.../oradata

 

by: woolmilkporcPosted on 2009-06-04 at 09:46:56ID: 24548873

I guess that you use the TSM scheduler and didn't restart it.
- Iocate the dsmc process using 'ps -ef | grep dsmc', kill it, restart it.
- retry.

wmp



 

by: greatmichPosted on 2009-06-08 at 08:36:56ID: 24573213

I stop and started it again, will see tonight

 

by: greatmichPosted on 2009-06-09 at 04:37:15ID: 24580032

I am sorry my Tivoil admin is out, how do I stop and start.

I ran dsmcad start

it shows it running but it did not run last night.

 

by: woolmilkporcPosted on 2009-06-09 at 04:52:41ID: 24580119

Hi again,

so I assume you have the entry

MANAGEDSERVICES SCHEDULE

in your dsm.sys?

If yes, find dsmcad's PID by issuing 'ps -ef | grep dsmcad | grep -v grep' and kill it ('kill [pid as in 2nd row of ps]'), then start it using

'/usr/tivoli/tsm/client/ba/bin/dsmcad'

If you are missing the MANAGEDSERVICES entry in dsm.sys, dsmcad has nothing to do with the scheduler.

In this case find the PID of 'dsmc sched' by issuing 'ps -ef | grep "dsmc sched" | grep -v grep' and kill it ('kill [pid as in 2nd row of ps]'), then start it using as it's done (most probably) in inittab. If you don't find it there, try

'/usr/tivoli/tsm/client/ba/bin/dsmc sched >/dev/null 2>&1 &'

HTH

wmp

 

by: greatmichPosted on 2009-06-09 at 05:08:27ID: 24580216

I did not have it in my dsm.sys.

 

by: greatmichPosted on 2009-06-09 at 05:08:59ID: 24580220

I restarted and wait till tomorrow to see what happens, THANK YOU SO MUCH FOR HELPING me

 

by: woolmilkporcPosted on 2009-06-09 at 05:09:30ID: 24580223

OK, so try the 'dsmc sched' version then.

 

by: woolmilkporcPosted on 2009-06-09 at 05:13:40ID: 24580248

Uh, sorry, did you start dsmc sched as I wrote?

I missed a very important thing - the complete command must be

'nohup /usr/tivoli/tsm/client/ba/bin/dsmc sched >/dev/null 2>&1 &'

else the scheduler will not survive when you exit your shell.

Sorry again!

wmp

 

by: greatmichPosted on 2009-06-10 at 10:13:04ID: 24593820

duh I should have seen that. yeah it died of course. I will kill, resubmit and let you know tomorrow

 

by: gheistPosted on 2009-06-10 at 12:54:29ID: 24595602

Alternatively -
in /etc/inittab:
tsm:once:/usr/tivoli/tsm/client/ba/bin/dsmc sched < /dev/null >/dev/null 2>&1

followed by "kill -HUP 1" to restart.

Also make sure you run latest maintenance level for your TSM client, and appropriate Technology/Maintenance package for AIX:
ftp://ftp.software.ibm.com/storage/tivoli-storage-management/maintenance/client/
I like this AIX site fro ML and PTF frontend:
http://support.bull.com/ols/product/system/aix/fix/

 

by: greatmichPosted on 2009-06-11 at 05:37:06ID: 24601409

what does this mean
06/11/09   05:39:59 ANS1898I ***** Processed   179,500 files *****
06/11/09   05:39:59 Expiring-->            5,980,160 /u03/oradata/APPWORX/ctrl_A                                                                             PPWORX_03.ctl [Sent]
06/11/09   05:39:59 Expiring-->           52,429,312 /u03/oradata/APPWORX/redo_A                                                                             PPWORX_01b.dbf [Sent]
06/11/09   05:39:59 Expiring-->           52,429,312 /u03/oradata/APPWORX/redo_A                                                                             PPWORX_02b.dbf [Sent]

VS

06/11/09   05:39:59 Directory-->                 256 /u03/backups/pmftest [Sent]                                                                            
06/11/09   05:39:59 Directory-->                 256 /u03/backups/APPWORX/archiv                                                                             elog/2009_06_08 [Sent]
06/11/09   05:39:59 Directory-->                 256 /u03/backups/APPWORX/archiv                                                                             elog/2009_06_09 [Sent]
06/11/09   05:39:59 Directory-->                 256 /u03/backups/APPWORX/archiv                                                                             elog/2009_06_10 [Sent]

key word I am see is one is expiring and the other just says sent. I hope it means what I think it means that the expiring is not sending(backing up) but saying it not going to do it anymore.

 

by: woolmilkporcPosted on 2009-06-11 at 07:12:54ID: 24602540

Hi,

I mean you mean the right thing when meaning that expiring means 'not sending'.

Indeed, in view of the log above, TSM just sends out the directories for backup ("[Directory ... Sent]"), while it has recognized that you no longer wish to backup the files, and thus flags them in its inventory as expired ("[Expiring ... Sent]").
The actual removal from the TSM DB will later be done during the next 'Expire Inventory' run on the server, and deletion from physical media will be done in the course of 'Space Reclamation'.

In my opinion it is very desirable to exclude only files and not directories (not everybody sees it that way, it seems).
In case of complete filesystem or disk loss you can later easily recreate the directory structure using standard TSM (dsmc),
while recovery of the database files will be done with TDP or whatever. As far as I know, TDP does not recreate directory structures during recovery!

Short, your EXCLUDE directive works now as it's supposed to, and everything is OK regarding /u01/oradata... and /u03/oradata...

Cheers

wmp



 

by: greatmichPosted on 2009-06-11 at 07:25:08ID: 31586616

excellent teaching session

 

by: gheistPosted on 2009-06-11 at 23:05:53ID: 24609531

Expiring means that old version of file (say 30 changes back) is deleted on server.

 

by: greatmichPosted on 2009-06-12 at 04:14:05ID: 24610999

ok but I don't see that it was sent though, do you still think I have an issue?

 

by: woolmilkporcPosted on 2009-06-12 at 04:22:36ID: 24611036

'Expiring' means in this case that all versions of the file are flagged for deletion on the server. You told TSM by your new "EXCLUDE" directive that you don't want/need the file backed up anymore, and TSM honors that this way.

With 'Expiring' you never send actual file data, but only the deletion request (actually a request to set a deletion flag).

wmp

 

 

by: gheistPosted on 2009-06-12 at 07:17:47ID: 24612544

Nope - policy specifies how long versions are held. Now this timeout kicks in.

 

by: woolmilkporcPosted on 2009-06-12 at 07:24:24ID: 24612618

I wrote 'flagged ...' ! Of course actual deletion depends on policy.

20120131-EE-VQP-002

3 Ways to Join

30-Day Free Trial

The Experts

98% positive feedback on 31,087 answers since March 2000. angeliii is a Microsoft Most Valuable Professional for his work with MS SQL Server & Develoment.

He has also proven his knowledge of Visual Basic Programming, PHP Scripting and Oracle Databases.

The Experts

97% positive feedback on 10,752 answers since July 2000. lrmoore has more than 18 years experience in the networking industry.

The six-time Mircosoft MVPs specialties include firewalls, virtual private networking, and network management.

Testimonials

"...and excellent source for support... Kind of like having your very own IT dept." Electriciansnet

Testimonials

"I was apprehensive at signing up at first. However... it has already made my life as an IT administrator much easier." JaCrews

Testimonials

"WOW! You guys have great, active, and knowledgeable people on here." moore50

Business Clients

Business Clients

In the Press

"If you’ve got a question... Experts Exchange can supply an answer.”

In the Press

"...an invaluable aid for both IT professionals and those who require tech support."

In the Press

"where IT professionals provide quick answers on just about any topic"

Business Account Plans

Loading Advertisement...