How are you backing up the databases - hot Oracle backup via RMAN or normal filesystem backup?

If filesystem backup you should ensure that databases are down.

Also check that root has read access to databases as filesystem backups are done by root.

Create /usr/openv/netbackup/logs/bpbkar log directory on client to trace filesystem backups.

Hi Marianne,

Thanks for your prompt reply.

I am taking off-host normal file system level backup,

As you mentioned i have checked bpbkar log dir but there is no any details about this particular file.

Also regarding permission , it is same as other -rw-r-----.

When i am backing up this file particular file seprately, it is getting backed up.

Any thing else i can check.

Regards,

Please supply info about your backup selection list and exact location of database not getting backed up. If database is in a different filesystem, it will not be backed up.

Consider the following:

Filesystem 1: /data

Filesystem 2: /data/data1

If your backup selection says '/data' then nothing under data1 will be backed up. NBU does not cross mount points unless you explicitly select 'Cross mount points' in policy attributes.

Hi Marianne,

There are 49 backup selection in this particular backup policy

I am mentioning only one file system which is having problem

/nictstdb/nic_pty_cnd

In this file system following files are present out of that highlighted file is not getting backed up.

-rw-r-----   1 122      540         5.0G Oct  8 09:35 CTY_KND_02.DBF
-rw-r-----   1 122      540          30G Oct  8 09:35 CKR_KND_32.DBF
-rw-r-----   1 122      540          30G Oct  8 09:35 CKR_KND_33.DBF
-rw-r-----   1 122      540         300M Oct  8 09:35 DM_KND_4.DBF
-rw-r-----   1 122      540         300M Oct  8 09:35 DM_KND_3.DBF
-rw-r-----   1 122      540         300M Oct  8 09:35 DM_KND_2.DBF
-rw-r-----   1 122      540         1.5G Oct  8 09:35 DM_KND.DBF
-rw-r-----   1 122      540          32G Oct  8 09:35 CTY_KND.DBF
-rw-r-----   1 122      540          30G Oct  8 09:35 CKR_KND_34.DBF
-rw-r-----   1 122      540          30G Oct  8 09:35 CKR_KND_35.DBF
-rw-r-----   1 122      540          15G Oct  8 09:35 CKR_KND_36.DBF
-rw-r-----   1 122      540          32G Oct  8 09:35 CTY_KND_01.DBF
-rw-r-----   1 122      540         300M Oct  8 09:35 DM_KND_5.DBF

Pls advice.

Regards,
 

Can you copy the file manual ?. If possible we know Netbackup should be able to backup the file as well.

Hi Nicolai,

Yes i have already tried this, when backing up this seperate file i am able to backed up this.

Regards,

Hi,

Is the job finishing with Status 0 or Status 1. If its 0, then we know that NetBackup did most likely not make a mistake and its been configured in this manner, if its finishing with Status 1, then we can investigate why the file was skipped.

Please advise.

Yes Riaan, Job is getting sucesfully finished with status 0 i.e without any error.

put at the bp.conf file the entry

VERBOSE = 5

and retry the backup. Then check again the bpbkar log.
Is the same file omitted every time or it is a different file, randomly?

A good Idea is to put in the file list the /nictstdb/nic_pty_cnd/* and allow the "multiple data streams. Then you will have one backup per file

Check the logs of the backup with the error

stefanos

Hi,

Turn up the logging on the client (add VERBOSE = 5 to the bottom of your bp.conf) and create the bpbkar log folder. Lets see if there is a clue in there.

R