1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

Exclude not working?

Discussion in 'Backup / Archive Discussion' started by janecb, Mar 19, 2008.

  1. janecb

    janecb New Member

    Joined:
    Oct 21, 2002
    Messages:
    46
    Likes Received:
    0
    Location:
    Northeast
    Hi,

    I have an oracle unix server backing up with Oracle SQLBACKTRACK and TSM file systems. I do not want to back up the database files with my filesystem backup, so I have the following exclude:

    exclude /.../oradata/.../*

    The file systems look like this -

    /pshora7/u01/oradata/dtm1p/dtmds109.dbf

    and we have u01 to u59: When we recieved an overage report showing 17 TB of data for this one server, we checked.. and this exclude is not working. see portion of log file below

    03/17/08 01:29:30 Normal File--> 2,097,160,192 /pshora7/u59/oradata/dtm1p/dtmds109.dbf [Sent]
    03/17/08 01:38:07 Normal File--> 2,097,160,192 /pshora7/u59/oradata/dtm1p/dtmds110.dbf [Sent]
    03/17/08 01:41:24 Normal File--> 2,097,160,192 /pshora7/u59/oradata/dtm1p/dtmds111.dbf [Sent]
    03/17/08 01:44:54 Normal File--> 2,097,160,192 /pshora7/u59/oradata/dtm1p/dtmds112.dbf [Sent]
    03/17/08 01:48:21 Normal File--> 2,097,160,192 /pshora7/u59/oradata/dtm1p/dtmds113.dbf [Sent]
    03/17/08 01:51:47 Normal File--> 2,097,160,192 /pshora7/u59/oradata/dtm1p/dtmds114.dbf [Sent]
    03/17/08 01:55:13 Normal File--> 2,097,160,192 /pshora7/u59/oradata/dtm1p/dtmds115.dbf [Sent]

    any suggestions? Help?

    Thanks,
    Jane
     
  2.  
  3. cwilloug

    cwilloug Senior Member

    Joined:
    Sep 13, 2006
    Messages:
    387
    Likes Received:
    11
    Occupation:
    Storage / Backup / VMware / HyperV admin
    Location:
    North Dakota
    Is this a windows box?

    Try:

    Exclude.backup "*:/.../oradata/dtm1p/*.dbf"
     
  4. janecb

    janecb New Member

    Joined:
    Oct 21, 2002
    Messages:
    46
    Likes Received:
    0
    Location:
    Northeast
    Hi,
    No its a unix server...

    Jane
     
  5. janecb

    janecb New Member

    Joined:
    Oct 21, 2002
    Messages:
    46
    Likes Received:
    0
    Location:
    Northeast
    I know in a client option set only one set of wildcard patterns can be used.. would that be the case in this exclude?

    Jane
     
  6. cwilloug

    cwilloug Senior Member

    Joined:
    Sep 13, 2006
    Messages:
    387
    Likes Received:
    11
    Occupation:
    Storage / Backup / VMware / HyperV admin
    Location:
    North Dakota
    Humm,,, UNIX boxes are not my strong point,, but maybe

    exclude /pshora7/oradata/.../*

    if you have java installed on the machine, make your changes to the dsm.sys file, then launch the GUI and "pretend" to do a backup, to see if you can see the directory or files you're trying to exclude - kind of a litmus test. If you can see the files, you need to change the dsm.sys file again.

    clay
     
  7. cwilloug

    cwilloug Senior Member

    Joined:
    Sep 13, 2006
    Messages:
    387
    Likes Received:
    11
    Occupation:
    Storage / Backup / VMware / HyperV admin
    Location:
    North Dakota
    oops,, it should be...

    exclude /pshora7/.../oradata/.../*
     
  8. janecb

    janecb New Member

    Joined:
    Oct 21, 2002
    Messages:
    46
    Likes Received:
    0
    Location:
    Northeast
    Thanks, I will try it.. we are trying to make it generic so one inclexcl file for all.. and the pshora7 is too speciific to one server..

    Jane
     
  9. BBB

    BBB Moderator

    Joined:
    Feb 13, 2007
    Messages:
    2,076
    Likes Received:
    20
    Location:
    Brisbane, Australia
    Your exclude of "exclude /.../oradata/.../*" is perfect for what you want to do.

    Can you post the output of "dsmc q inclexcl -detail". There may be an include "before" your exclude.
     
  10. janecb

    janecb New Member

    Joined:
    Oct 21, 2002
    Messages:
    46
    Likes Received:
    0
    Location:
    Northeast
    Hi,

    Thank you all for your help.. I had the admin run the command for inclexcl, and they were using a non standard account that had multiple includes and excludes that were conflicting with the intent originally!

    Jane
     
  11. ravikanth

    ravikanth New Member

    Joined:
    Apr 27, 2004
    Messages:
    42
    Likes Received:
    1
    Hi All,

    Further to above question, I have same question. Can any one advice me whether my include statements are correct or not ?

    exclude /u04/.../*
    include /u04/oradata/trn2/.../*
    include /u04/oratrn2/.../*

    and dsm.opt shows like this

    DOMAIN /u04

    My requirement is under the above two directories every thing needs to be backed up. And rest all directories and files under /u04 backup is not required.

    Any thoughts on this ?

    Thanks,

    Ravikanth
     
  12. BBB

    BBB Moderator

    Joined:
    Feb 13, 2007
    Messages:
    2,076
    Likes Received:
    20
    Location:
    Brisbane, Australia
    Yep looks fine as long as that's the order they appear in your dsm.opt or optionset.
     
  13. ravikanth

    ravikanth New Member

    Joined:
    Apr 27, 2004
    Messages:
    42
    Likes Received:
    1
    Thank you very much for the Reply ! I am worried whether required files are going to backup or not ? As the preview command shows me only direstories are included not files under those directories. Any thoughts on this ?

    Ravikanth
     
  14. BBB

    BBB Moderator

    Joined:
    Feb 13, 2007
    Messages:
    2,076
    Likes Received:
    20
    Location:
    Brisbane, Australia
    Doesn't sound right. What other includes and excludes do you have?

    Post the output from "dsmc q inclexcl -detail".
     
  15. storageadmin

    storageadmin New Member

    Joined:
    Jun 26, 2007
    Messages:
    43
    Likes Received:
    0
    size option with exclude

    Hi All,

    I have a query..on the same..

    I am working on TSM 5.5 on RHEL 4.5

    My problem is that i have some junk files created sometimes in my server..which shows 100 GB, when i use ll command, when i go for du -sh command it shows in MB. But during daily backups..TSM takes that file as 100GB. I want TSM not to backup such junk files.

    i have script to check such files and remove them, but sometimes..such files get backed up..

    Hence is there any size option that can be mentioned in exclude, to prevent backing up such files.

    do suggest

    regards
    storageadmin
     
  16. ravikanth

    ravikanth New Member

    Joined:
    Apr 27, 2004
    Messages:
    42
    Likes Received:
    1
    Hi,

    Here is the output

    tsm> q inclexcl -detail
    *** FILE INCLUDE/EXCLUDE ***
    Mode Function Pattern (match from top down) Source File
    ---- --------- ------------------------------ -----------------
    No exclude filespace statements defined.
    Excl Directory /.../.TsmCacheDir TSM
    Include All /u04/oratrn2/.../* "/usr/tivoli/tsm/client/ba/bin/inclexcl.txt"
    MC NAME:
    Include All /u04/oradata/trn2/.../* "/usr/tivoli/tsm/client/ba/bin/inclexcl.txt"
    MC NAME:
    Exclude All /u04/.../* "/usr/tivoli/tsm/client/ba/bin/inclexcl.txt"
    No DFS include/exclude statements defined.

    Any questions please feel free.

    Thanks,

    Ravikanth
     
  17. BBB

    BBB Moderator

    Joined:
    Feb 13, 2007
    Messages:
    2,076
    Likes Received:
    20
    Location:
    Brisbane, Australia
    Ravikanth - looks ok to me. Try a test restore to see if you can see the files.

    Storageadmin: you should create a new post for this. I think what you are seeing is "sparse" files - look them up.
     
: exclude

Share This Page