Skip to main content
commvault.com commvault.com
Solved

nFilterApplicationFiles additional setting

  • January 14, 2022
  • 4 replies
  • 335 views
L
Byte
Forum|alt.badge.img+5

Hello,

I’ve found the setting called “nFilterApplicationFiles”

 

Create this additional setting and set its value as 1 to exclude the database application files from the file system backup. This applies to DB2, Oracle, SAP for Oracle and SAP HANA.

Additional Settings Description (commvault.com)

 

 

As for the DB2 it’s being covered under this link: Excluding Application Files from a UNIX File System Backup (commvault.com)

 

Excluded DB2 Files

The following files are excluded when you set the additional setting on a DB2 client:

  • The DB2 datafiles that the software displays in the CommCell Console DB2 browse pane.
  • The files that reside in the DB2 archive log path (Db2Agent\sDB2_ARCHIVE_PATH)
  • The files that reside in the DB2 audit error path (Db2Agent\sDB2_AUDIT_ERROR_PATH)
  • The files that reside in the DB2 retrieve error path (Db2Agent\sDB2_RETRIEVE_PATH)

 

But what does exactly that part means - “The DB2 datafiles that the software displays in the CommCell Console DB2 browse pane” ?

Best answer by Sunil

@Steven R is right. The idea behind this key is to avoid backing up the DB data backed up twice (once by the Database agent and once by File System agent). So, if the DB2 database is discovered and configured for backup in Commvault, then the data files details are collected and stored in Commvault’s catalog. Only such data files will be skipped by File System agent when this additional setting is set.

Any DB data of instances that are not being backed up by Commvault won’t be skipped.

 

Thanks,

Sunil-

 

View original
Did this answer your question?

Steven Robinson
Vaulter
Forum|alt.badge.img+5

One thing to understand with this additional setting is that it only applies to configured DB instances/databases that have at least one successfully completed DB agent backup in Commvault.  So if there is a DB datafile on the server that hasn’t been backed up using a DB agent it will not be skipped during filesystem backups.  Once you have a successful backup, it will then be filtered.

So what the line you referenced is trying to state is that the database needs to have been discovered in Commvault and will therefore be visible in the console. 

Hope that helps.

“I did then what I knew how to do. Now that I know better, I do better.” ― Maya Angelou
Sunil
L
2 people like this
  • Sunil
    Sunil
  • L
    Lukas_S
Sunil
Vaulter
Forum|alt.badge.img+13
  • SunilVaulter
  • Vaulter
  • 300 replies
  • Answer
  • January 17, 2022

@Steven R is right. The idea behind this key is to avoid backing up the DB data backed up twice (once by the Database agent and once by File System agent). So, if the DB2 database is discovered and configured for backup in Commvault, then the data files details are collected and stored in Commvault’s catalog. Only such data files will be skipped by File System agent when this additional setting is set.

Any DB data of instances that are not being backed up by Commvault won’t be skipped.

 

Thanks,

Sunil-

 

L
1 person likes this
  • L
    Lukas_S
L
Byte
Forum|alt.badge.img+5
  • Lukas_S
  • Byte
  • January 17, 2022

Thank you guys for clarifying this, but are you aware how exactly it works? What files are being excluded? i.e. everything in the DB directory, some particular extensions (after proper DB backup) and so on?

 

Sunil
Vaulter
Forum|alt.badge.img+13
  • SunilVaulter
  • Vaulter
  • January 17, 2022

As mentioned in the documentation page, the following paths will be skipped.

 

  • The files that reside in the DB2 archive log path (Db2Agent\sDB2_ARCHIVE_PATH)
  • The files that reside in the DB2 audit error path (Db2Agent\sDB2_AUDIT_ERROR_PATH)
  • The files that reside in the DB2 retrieve error path (Db2Agent\sDB2_RETRIEVE_PATH)

Along with these, all the data files under the data area will be skipped. These files can be of extensions .LRG, .CAT, .TMP, .dbf, .USR but not limited to. Basically any file that’s discovered as a datafile by Commvault will be skipped.

 

Thanks,

Sunil-

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings