JayJay9882
2 Iron

Incremental Index-Backup

Hello together,

I have a separate pool configured within NetWorker to backup the index and bootstrap informations. I always thought that NetWorker would do an incremental/level save of these two backup pieces.

Now I recognized that it is always a FULL

mminfo -avot -q 'pool=INDEX,savetime>24 hours ago' -r level,name,savetime

full bootstrap                  12/14/17
full index:client         12/14/17
full index:client             12/14/17
full index:client             12/14/17
full index:client             12/14/17
full index:client             12/14/17
full index:client             12/14/17
full index:client             12/14/17
full index:client             12/14/17
full index:client             12/14/17

The configuration of the INDEX pool is mostly default, just the save set field contains this:

index: *

bootstrap

And of course a dedicated DataDomain device is used.

Is that regular behaviour of NetWorker?

Cheers

Jan

Tags (3)
32 Replies
bingo.1
4 Tellurium

Re: Incremental Index-Backup

NW never ran incrementals for these save sets.

For NW 8.x

- Index backups' will in general be the same as for the client level backups.

     Exception: For incremental backups, the index backups will be made with level 9.

- Bootstraps will always be fulls.

For NW 9.x

- Index backups' will always run with level 1 (yes, it is still there) or with level full.

- Bootstraps will always be fulls.

0 Kudos
JayJay9882
2 Iron

Re: Incremental Index-Backup

Ok, thanks for clearing that up.

I just checked one of my clients backup from last nights backup. It was a incremental backup of the client. The index backup performed though was a full. Shouldn't it be a level 9 backup then?

client    /oracle/xyz/mirrlogA    incr    Data Domain    DATA    14.12.17 04:14:32    00:00:41    0 KB   

client    /usr/sap/xyz            incr    Data Domain    DATA    14.12.17 04:15:44    00:00:36    179 MB

client    /oracle/xyz/origlogA    incr    Data Domain    DATA    14.12.17 04:15:10    00:00:39    0 KB   

client    /boot                    incr    Data Domain    DATA    14.12.17 04:14:26    00:00:46    0 KB   

client    client:index            full    Data Domain    INDEX    14.12.17 04:39:41    00:00:35    252 MB

0 Kudos
MagnusR
1 Nickel

Re: Incremental Index-Backup

For NW 9: the level for index backups is determined in the "Server db backup" action in the "Server backup" workflow under "Server Protection" policy.

For NW 8: Level is determined by the level for the client backup in the savegroup backing up the client's index.

0 Kudos
JayJay9882
2 Iron

Re: Incremental Index-Backup

I have NW 8.x running. Sorry didn't mention that.

0 Kudos
MagnusR
1 Nickel

Re: Incremental Index-Backup

Are you backing up the index in the same group or do you have a separate "index only" group?

0 Kudos
bingo.1
4 Tellurium

Re: Incremental Index-Backup

Well - as usual NW starts a backup cycle with a full. Did you accidentally delete the previous index backups?

0 Kudos
JayJay9882
2 Iron

Re: Incremental Index-Backup

Not that I'm aware of.

I did two backups in a row, a full and an incr. The second backup should run a level 9 backup of the index but it did a full.

FULL backup:

client        date     time     size       lvl name

client          12/14/17 18:08:10 full /

client          12/14/17 18:08:11 full /boot

client          12/14/17 18:08:51 full /tmp

client          12/14/17 18:08:56 full /var

nw-server    12/14/17 18:09:50 full index:ezszsg7a

INCR backup:

client         12/14/17 18:16:00 incr /

client         12/14/17 18:15:55 incr /boot

client         12/14/17 18:16:38 incr /tmp

client         12/14/17 18:16:35 incr /var

nw-server   12/14/17 18:17:29 full index:ezszsg7a

0 Kudos
MagnusR
1 Nickel

Re: Incremental Index-Backup

Check daemon.raw on NW server for messages about these backups:

From cli, cd to .../nsr/logs directory, run the command below and send us the output:


nsr_render_log -S "18:15:50" -E "18:17:30" daemon.raw

0 Kudos
Highlighted
wlee4
2 Iron

Re: Incremental Index-Backup

The index backups are "owned" by the nw server's client.

Refine your mminfo command to just run this":

     mminfo -avot -q 'pool=INDEX,savetime>24 hours ago' -r "client,savetime(20),group,level,name"

This will show you that the client for these savesets are the backup server itself.  Because of this, when these index backups are being created, it looks in the backup server's client resource for various info settings, such as browse and retention times, and also what schedule is specified so that it knows what level to use.

Index backups are always either level full or level 9.

HTH...



0 Kudos