Help needed nbdb_unload

[unkn0wnn]

Hello,

I need help running nbdb_unload on live system without breaking things...

Basically I have restored all db/images directory without nbdb and just need to read these files.

So we are in:

/usr/openv/netbackup/db/images/backupclient/1367000000

cd ../

We are now in /usr/openv/netbackup/db/images/backupclient/

Can I now run this:

nbdb_unload 1367000000

Or can I just read these files somehow ?

else I need help on running nbdb_unload on /usr/openv/db/staging/ *.db

[Marianne]

Have you double-checked the retentions in UK-AdvDisk-Tape-Infinity SLP? 

nbstl UK-AdvDisk-Tape-Infinity -L [-all_versions]
(not sure in which NBU version was -all_versions added).

If the SLP has correct retentions, then the images WILL be stored with matching retention.

One more thing -  for DB-type backups (e.g. SQL), then the SLP or retention selected in Default-Application schedule will be applied to backup streams.

[unkn0wnn]

Ok I am going to import manually all tape contents as I do not have any server where I could test things...

[unkn0wnn]

Marianne / all, is phase 1 enough to recover BAR or phase 2 is also required ???

[Marianne]

Phase 1 will bring back header info only.

You still need to run phase 2 to bring back 'files files' that will enable restores.

Please be aware that phase 1 import has an automatic retention of 1 week. you need to complete phase 2 import before phase 1 expires.

[unkn0wnn]

So if I want all the images then these will get written to a disk, right ? As you already know, all I wanted is to have bar so I can do restores

[Marianne]

@unkn0wnn wrote:

So if I want all the images then these will get written to a disk, right ? 

---

Apologies, I have no idea what this means.

Phase 1 will create header info in nbdb database.

Phase 2 will create 'files' list in images folder on the master server and update header info (in nbdb) with 2-week retention. 

Next step is to use bpexpdate to change retention that matches business requirements. 

[unkn0wnn]

Next step is to use bpexpdate to change retention that matches business requirements. 

What do you mean ? I want to have images imported to be infinity retention.

How do I do that ?

[Marianne]

Apologies. The NBU documentation says that after phase 2 import, the retention level will match the original retention level.

BUT you REALLY need to check bpimagelist output after successful phase 2 import.

My view is that the duplication had the incorrect retention level to start off with and that is why the images expired in the first place. 

So, if bpimagelist output after phase 2 shows anything other than INFINITY, you need to use bpexpdate to change retention to INFINITY.

[unkn0wnn]

Ah right I see,

See below phase 1 import results please, it's found multiple clients backups however only 1 was available for phase 2 import, why would that be ?

Import phase 1 started Thu 14 Dec 2017 11:22:56 GMT
11:22:56 INF - Create DB information for media id 0003L5.
11:22:56 INF - Initiation of bptm process to phase 1 import media id 0003L5 was successful.
11:22:57 INF - Waiting for mount of media id 0003L5 on server n5220uk for reading.
11:23:45 INF - Recreating image information for client postfix-full, policy Notes-Server-MailFiles, and schedule Period_End, done on 06/10/2013 00:00:05.
11:23:45 INF - Recreating copy 2, fragment 6 information for image.
11:25:17 INF - Found existing image information for client postfix-full, policy Notes-Server-MailFiles, and schedule Period_End, done on 06/10/2013 00:00:05.
11:25:17 INF - Recreating copy 2, fragment 7 information for image.
11:26:44 INF - Found existing image information for client postfix-full, policy Notes-Server-MailFiles, and schedule Period_End, done on 06/10/2013 00:00:05.
11:26:44 INF - Recreating copy 2, fragment 8 information for image.
11:28:34 INF - Found existing image information for client postfix-full, policy Notes-Server-MailFiles, and schedule Period_End, done on 06/10/2013 00:00:05.
11:28:34 INF - Recreating copy 2, fragment 9 information for image.
11:29:59 INF - Found existing image information for client postfix-full, policy Notes-Server-MailFiles, and schedule Period_End, done on 06/10/2013 00:00:05.
11:29:59 INF - Recreating copy 2, fragment 10 information for image.
11:31:02 INF - Found existing image information for client postfix-full, policy Notes-Server-MailFiles, and schedule Period_End, done on 06/10/2013 00:00:05.
11:31:02 INF - Recreating copy 2, fragment 11 information for image.
11:31:53 INF - Found existing image information for client postfix-full, policy Notes-Server-MailFiles, and schedule Period_End, done on 06/10/2013 00:00:05.
11:31:53 INF - Recreating copy 2, fragment 12 information for image.
11:32:29 INF - Found existing image information for client postfix-full, policy Notes-Server-MailFiles, and schedule Period_End, done on 06/10/2013 00:00:05.
11:32:29 INF - Recreating copy 2, fragment 13 information for image.
11:32:51 INF - Found existing image information for client postfix-full, policy Notes-Server-MailFiles, and schedule Period_End, done on 06/10/2013 00:00:05.
11:32:51 INF - Recreating copy 2, fragment 14 information for image.
11:33:13 INF - Found existing image information for client postfix-full, policy Notes-Server-MailFiles, and schedule Period_End, done on 06/10/2013 00:00:05.
11:33:13 INF - Recreating copy 2, fragment 15 information for image.
11:33:39 INF - Found existing image information for client postfix-full, policy Notes-Server-MailFiles, and schedule Period_End, done on 06/10/2013 00:00:05.
11:33:39 INF - Recreating copy 2, fragment 16 information for image.
11:34:11 INF - Found existing image information for client postfix-full, policy Notes-Server-MailFiles, and schedule Period_End, done on 06/10/2013 00:00:05.
11:34:11 INF - Recreating copy 2, fragment 17 information for image.
11:34:54 INF - Found existing image information for client postfix-full, policy Notes-Server-MailFiles, and schedule Period_End, done on 06/10/2013 00:00:05.
11:34:54 INF - Recreating copy 2, fragment 18 information for image.
11:35:37 INF - Found existing image information for client postfix-full, policy Notes-Server-MailFiles, and schedule Period_End, done on 06/10/2013 00:00:05.
11:35:37 INF - Recreating copy 2, fragment 19 information for image.
11:36:43 INF - Found existing image information for client postfix-full, policy Notes-Server-MailFiles, and schedule Period_End, done on 06/10/2013 00:00:05.
11:36:43 INF - Recreating copy 2, fragment 20 information for image.
11:37:21 INF - Found existing image information for client postfix-full, policy Notes-Server-MailFiles, and schedule Period_End, done on 06/10/2013 00:00:05.
11:37:21 INF - Recreating copy 2, fragment TIR information for image.

11:37:21 INF - Recreating copy 2, fragment TIR information for image.
11:37:21 INF - Recreating image information for client ubuntu-live, policy ubuntu-live-Users, and schedule Period_End, done on 06/10/2013 01:00:01.
11:37:21 INF - Recreating copy 2, fragment 1 information for image.
11:37:57 INF - Found existing image information for client ubuntu-live, policy ubuntu-live-Users, and schedule Period_End, done on 06/10/2013 01:00:01.
11:37:57 INF - Recreating copy 2, fragment 2 information for image.
11:38:27 INF - Found existing image information for client ubuntu-live, policy ubuntu-live-Users, and schedule Period_End, done on 06/10/2013 01:00:01.
11:38:27 INF - Recreating copy 2, fragment 3 information for image.
11:38:46 INF - Found existing image information for client ubuntu-live, policy ubuntu-live-Users, and schedule Period_End, done on 06/10/2013 01:00:01.
11:38:46 INF - Recreating copy 2, fragment 4 information for image.
11:39:04 INF - Found existing image information for client ubuntu-live, policy ubuntu-live-Users, and schedule Period_End, done on 06/10/2013 01:00:01.
11:39:04 INF - Recreating copy 2, fragment 5 information for image.
11:39:48 INF - Found existing image information for client ubuntu-live, policy ubuntu-live-Users, and schedule Period_End, done on 06/10/2013 01:00:01.
11:39:48 INF - Recreating copy 2, fragment 6 information for image.
11:40:43 INF - Found existing image information for client ubuntu-live, policy ubuntu-live-Users, and schedule Period_End, done on 06/10/2013 01:00:01.
11:40:43 INF - Recreating copy 2, fragment 7 information for image.
11:42:18 INF - Found existing image information for client ubuntu-live, policy ubuntu-live-Users, and schedule Period_End, done on 06/10/2013 01:00:01.
11:42:18 INF - Recreating copy 2, fragment 8 information for image.
11:43:19 INF - Found existing image information for client ubuntu-live, policy ubuntu-live-Users, and schedule Period_End, done on 06/10/2013 01:00:01.
11:43:19 INF - Recreating copy 2, fragment 9 information for image.
11:43:46 INF - Found existing image information for client ubuntu-live, policy ubuntu-live-Users, and schedule Period_End, done on 06/10/2013 01:00:01.
11:43:46 INF - Recreating copy 2, fragment 10 information for image.
11:44:08 INF - Found existing image information for client ubuntu-live, policy ubuntu-live-Users, and schedule Period_End, done on 06/10/2013 01:00:01.
11:44:08 INF - Recreating copy 2, fragment 11 information for image.
11:44:30 INF - Found existing image information for client ubuntu-live, policy ubuntu-live-Users, and schedule Period_End, done on 06/10/2013 01:00:01.
11:44:30 INF - Recreating copy 2, fragment 12 information for image.
11:44:49 INF - Found existing image information for client ubuntu-live, policy ubuntu-live-Users, and schedule Period_End, done on 06/10/2013 01:00:01.
11:44:49 INF - Recreating copy 2, fragment 13 information for image.
11:45:23 INF - Found existing image information for client ubuntu-live, policy ubuntu-live-Users, and schedule Period_End, done on 06/10/2013 01:00:01.
11:45:23 INF - Recreating copy 2, fragment 14 information for image.
11:46:29 INF - Creation of database information for import of media id 0003L5 complete.

[unkn0wnn]

test

[unkn0wnn]

Looks like something removes my posts

[unkn0wnn]

Phase 1 found images for 2 clients however only 1 was available for phase 2 process, why would that be ?

[Marianne]

I honestly have no idea.

Maybe not all fragments for the image were found in the phase 1 import. Maybe more than one tape was used for this backup/duplication.
Have you checked the Results tab of the Import?

It is important that all fragments for phase 1 is completed before phase 2 import is started.

[unkn0wnn]

Marianne please find attached and advise.

[Marianne]

Have a look at the very first image fragment on this tape:

11:23:45 INF - Recreating image information for client postfix-full, policy Notes-Server-MailFiles, and schedule Period_End, done on 06/10/2013 00:00:05.
11:23:45 INF - Recreating copy 2, fragment 6 information for image.
 

Fragments 1 - 5 was written on another tape. NBU has no idea which media id. If you have a manual record of media-ids used on this day, then you need to complete phase 1 import for all of them.

[unkn0wnn]

Ah right I see, so currently in the db I have a chunk of information but just needs to get the rest to have it available for phase 2 import right ? Basically I am going to do phase 1 on each tape and check what is available for phase 2, is that ok ?

[Marianne]

Correct.

You need to complete phase 1 import on all tapes before starting phase 2.
Please be mindful of the 1-week retention on phase 1 image headers.

[unkn0wnn]

Is it a must ? Can I not do phase 2 for images that are available straight after phase 1 then ?

[Marianne]

It is not a must. Just best practise as you may loose track of what has been imported and what not.

Please go ahead with the process that works for you.

[unkn0wnn]

Pretty much lenght process, it takes 6 hours to read lto5 tape, both phases. so I have over 360 tapes to import.