Oracle directive

Thank you for your reply.

My goal is simple and is almost like lotus directive. I need to exclude all the file or at least the data files of Oracle in the file systems backup of the server.

I'm sorry you right, I omitted in the post wich module I'm using, I use NMDA.

Directives are not suppoted for oracle backups with NMO/NMDA.

Do you want to use directices with NMO/NMDA?

If you could explain what your end goal is then i can try to help.

In that case you can create a global directive on the NetWorker server or a local directive on the client to exclude the files in the filesystem backups. Checked Page 170 in the Admin guide of Networker version 7.6.2.

You can create a global driective and apply to the client instance for the fils system backup of the DB server. If you intend to backup the oracle installation files, you can use the 1st driective otherwise use the second one to skip all the oracle files. I have not tested this.

1. << / >>

     +skip : *.dbf

     +skip : *.ctl

     +skip : *.arc

(You can add remove the extensions as per your DB configuration. I am suggesting based on the default database files naming)

2. << /oracle >>

     +skip: .

This is assuming that oracle is installed on /oracle. You can change this accordingly.

HTH

Hi all!

I want to add directive that exclude all the oracle db files from my fs backup.

The OS is Windows.

What will the directive for all disks look like?

Do I have to add each disk separately?

f.e.

<< C:\ >>

+skip : *.dbf

+skip : *.ctl

+skip : *.arc

What if i had 50 discs? Or dont know letters of the discs.

Regards

Piotr

If you want the directive to apply to all disks or partitions, just use the / directory.

eg : 

<< / >>

     +skip : *.dbf

     +skip : *.ctl

     +skip : *.arc

A new feature that was added in NetWorker 9.2 client package, and documented in the 9.2 administration guide, now allows for wildcard characters in the directory specs itself.  To activate this, you have to precede the directory with an asterisk.  For example:

<< */home/a* >>

+skip: * .?*

This directive applies to the directories starting with the letter a under the /home directory.  Please look at the administration guide for more information and examples.