Video Screencast Help

Correct Policy directives for File System backup on Oracle, SQL & Exchange servers

Created: 05 Apr 2013 • Updated: 06 Apr 2013 | 6 comments
This issue has been solved. See solution.

Hi all,

I use this forum all the time to get answers to issues I am having setting up a new NetBackup solution but I can't find the answer to this one.

I need to get complete backups of systems running MS SQL, Exchange and Oracle on both Windows and Solaris/Linux.

I can configure the Exchange, SQL and Oracle policies no problem but I also want to backup the file systems.

We had a consultant in who did the initial config of some policies etc on our 5220 appliances and he said that selecting the ALL_LOCAL_DRIVES directive should be OK because the client knew the server was an Oracle/SQL/Exchange server and would avoid backing up the database files etc.

Judging by what a stellar job he did I am lothed to trust this answer.

So the question is... Will the ALL_LOCAL_DRIVES directive do the job for me or should I manually exclude the files in an exclude list?

Any help you can give would be most appreciated

Cheers

Operating Systems:

Comments 6 CommentsJump to latest comment

Yasuhisa Ishikawa's picture

 because the client knew the server was an Oracle/SQL/Exchange server and would avoid backing up the database files etc.

Not true. NetBackup does not exclude these database files automatically. You need to exclude DB files manually as you wrote.

Authorized Symantec Consultant(ASC) Data Protection in Tokyo, Japan

SOLUTION
Marianne's picture

The answer to your last question is Yes.
You need to manually exclude the files in an exclude list to prevent filesystem backup from attempting to backup db files.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

Dan@NB's picture

Backups will complete but will be partially successful, if you dont exclude manually as sugested by Marianne and Yasuhisa. DB files will be skipped as they will be locked or will be busy. Go for manual exclusion and you should be fine with backing up filesystems.

 

+Dan

TonyGreenwood5164's picture

Thanks to you all for helping me with this.  I couldn't find anything about it in the manuals or the forums.

Cheers

Ankit Maheshwari's picture

 

ALL_LOCAL_DRIVES does not use any agent for backup. So if you will put this in backup selection this will backup all data will not ignore whether this file belong to DB or simple file.

 

Best solution is to configure DB policy for database and use ALL_LOCAL_DRIVES for rest data for avoiding partially completion use exclude file option. You need to add DB files location in exclude_list file.

 

 

Ankit Maheshwari

 

 

 

 

Ankit Maheshwari

Marianne's picture

There is no point in repeating what has already been said.
Post has already been solved.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links