04-30-2013 07:28 AM
Hi all,
There was a loss of some images in NetBackUp database from one year.
It is needed to restore NetBackUp catalog.
NetBackUp catalog backup consist few files. But by some reasons I've got an only file from "BACKUP" folder -
servername_1345618852_C1_F1.1345618852.img.
And one file from "G:\BACKUP\CatalogDB" folder -
xxx-CATALOG-HOT_1345618852_FULL.
When I use "Recover the catalog" wizard it does not work.
Is there any workaround or other methods to recovering catalog?
Thank you in advance
04-30-2013 07:50 AM
Are you trying to restore the entire catalog or just part of it ?
Was the original backup done to tape or disk ?
What OS and version of NBU are you running ?
What errors are you getting ?
04-30-2013 08:27 AM
I try to restore entire catalog.
The main objective is to know tapes numbers to importing it in current database. Maybe I can achive that with another way?
Original backup was done on disk. Current file takes about 200gb.
OS-2003, NBU version 7.1 and earlier.
Unfortunately I do not remember error number, but I recall that there was sentence regarding of lack of files. If error code is really needed I will try to restore it once again tomorrow.
05-01-2013 06:40 AM
05-01-2013 07:10 AM
Bprevocer -wizard
-copy number
Specifies the number of the copy of the catalog backup image to be used for the recovery operation. This option restores from a non-primary copy of the catalog backup image.
-L output_file
Reports the results of the recovery in the specified output file.
-nbdb
Used with the -r option during catalog recovery to recover and resynchronize the NetBackup relational databases (NBDBs) and the BMR database (BMRDB), if BMR is configured.
For complete catalog recovery procedures, refer to the NetBackup Troubleshooting Guide.
-priority number
Recovers the NetBackup relational database when used with -nbdb.
-r
Recovers the images from the specified policy name.
-wizard
Enables a user to perform the same functions from a command line that are present on the recovery wizard. For example, a user can specify the full pathname to the catalog disaster recovery file or recover the entire NetBackup catalog. The wizard prompts you for the catalog disaster recovery file.
The -copy option lets you select the number of the copy
EXAMPLES
Example 1 - Recover the entire NetBackup catalog or the catalog image and configuration files. On Windows, a series of screens takes you through the recovery process. On UNIX, a series of prompts takes you through the recovery process.
# bprecover -wizard
The disaster recovery information in the Troubleshooting Guide describes each step of the recovery process.
Example 2 - Recover the NetBackup relational databases and reports the results of the recovery in the recovery.rpt file.
# bprecover -r -nbdb -L recovery.rpt
The disaster recovery information of the Troubleshooting Guide describes each step of the recove
05-01-2013 07:13 AM
I had to use the DOS command to get the restore to work on my catalog.
Path is C:\Program Files\Veritas\NetBackup\bin\admincmd
If your install is on the C drive.
Point the recover to your xxx-CATALOG-HOT_1345618852_FULL. should be a file you can open and look at where it is pointing to.
05-01-2013 07:36 AM
I am late to this party and trying to figure out what this means:
There was a loss of some images in NetBackUp database from one year.
Help me to understand what this means? Did someone delete images or were images manually expired? Something else maybe?
The catalog backup that you found is dated 08/22/2012. How is restoring this data going to help you?
Doing a Full catalog recovery will discard all EMM database updates since that date.
Just restoring Images from this backup will leave image and EMM database out of sync.
How often are you doing hot catalog backups? What is DR-path in catalog backup policy? (Probably "G:\BACKUP\CatalogDB"?) How many files in this folder? Hopefully more recent files?
If this is your only catalog backup, you will be better off starting with phase 1 import of all unassigned media. Check Results of phase 1 import to see if you can find the 'missing' images.
05-06-2013 03:50 AM
Thank you Nathan,
But I do not understand how to recover only required images from my file?
05-06-2013 04:03 AM
It means that I do not know how they missed. May be someone delete it myabe manualyy expire it, may be there were disk errors.
Let me describe current situatiom: this issue was in august. Then we continue to work with current catalog.
Then there was an import and I imported 7 from 8 backup images (I know the number of tapes that were expired). But unfortunately I cannot import last image. Because after 1st phase of import "FRAGMENT 1 -1" was not found!. Other fragments were found succesfully. Phase 2 is impossible.
The catalog backup from 08/22/2012 have to consist of this fragment. And I will find required tape number...
Could you please help me how to find this fragment data?
05-07-2013 06:01 AM
Ah sorry I though you wanted the full catalog.
05-07-2013 06:16 AM
It is not bad to recover full catalog.
I can do it as a test. Then I will collect required data.
I tried to use bprecovery. And it does not work. There was this error:
F:\Veritas\NetBackup\bin\admincmd>bprecover -wizard
Welcome to the NetBackup Catalog Recovery Wizard!
Please make sure the devices and media that contain catalog disaster recovery data are available
Are you ready to continue?(Y/N) y
Please specify the full pathname to the catalog disaster recovery file:
G:\backup\catalogDB\******-CATALOG-HOT_1345618852_FULL
server2_1345618852
Failed to find all media needed for catalog DR image
The following NetBackup backup image could not be located.
Please make sure those media servers are correctly configured and those disk images are available.
Host Disk Image
server2 G:\BACKUP\server2_1345618852_C1_TIR *NULL*
server2 G:\BACKUP\server2_1345618852_C1_F1 *NULL*
server2 G:\BACKUP\server2_1345618820_C1_F1 *NULL*
This error is the same as when I start catalog_recovery_wizard via Administration Console.
05-07-2013 06:41 AM
Are the above files on the G drive?
I no stupid question but have to ask. from the error it seems like they are missing.
05-07-2013 06:42 AM
Your backups don't seem to exist anymore. All of the following are needed (not just one):
Failed to find all media needed for catalog DR image
The following NetBackup backup image could not be located.
Please make sure those media servers are correctly configured and those disk images are available.
Host Disk Image
server2 G:\BACKUP\server2_1345618852_C1_TIR *NULL*
server2 G:\BACKUP\server2_1345618852_C1_F1 *NULL*
server2 G:\BACKUP\server2_1345618820_C1_F1 *NULL*
You have mentioned ONE file in this folder: servername_1345618852_C1_F1.1345618852.img.
See if you can import this image.
If successful, you should be able to perform a 'normal' restore using BAR GUI, not bprecover.
Select master server as source client and policy type as 'NBU-Catalog'.
You should now be able to browse netbackup/db/images folders.
Hope this helps.
05-07-2013 07:03 AM
I am also late to this post so hopefully i have read it correctly ..
It looks to me like you backup your catalog to a disk storage unit located at G:\BACKUP
Do you also duplicate these backups to tape? If so that is you best chance to do a catalog recovery - if you work through the Catalog DR files you have they will have been updated when the tape copy was written with the Media ID of the tape
If you do find the tape (or can use the remaining disk image) I would reccomend you do all of this on an isolated test system - install NetBackup there with the same server name and to the same location and patch level and do your catalog restore on that system. Then use that to identify what you need.
Your only other option that may help is to look at the media section and try and find out which could be your missing import tapes - if you know the date of the backup you need to re-import then sort your media columns by the last mounted date to see which tapes were written at around that time and try an import on those to see if you can find the data.
Hope this helps
06-04-2013 03:13 AM
Hello Mark,
I imported all possible tapes. And I implemented 2 phase of import 7 of 8 of lost policies.
In last policy were found all fragments without 1 -1.
There are about 1800 tapes that can be candidates on this last tape... It is imppossible task to import because I have insufficient window between backups.
I wanted to obtain it number via catalog restoration...
But I haven't got enough files.
06-04-2013 03:14 AM
Those files are from Wed, 22 Aug 2012 07:00:52 UTC so i am guessing that they no longer exist, though the path relates to not only the files but the server server_2 too
Do you also write your catalog backups to tape?
That seems to be your only option here although i am still concerned that recovering a 2012 catalog now will wipre everything you have done since that date so do only do this on a test system (named server_2 with the files - if they do exist - located at G:\BACKUP\
06-04-2013 03:21 AM
Catalog is backed up only to disk.
I want to recover catalog on test machine.
06-04-2013 03:27 AM
OK - so what do you have available under G:\BACKUP\ on server_2?
06-04-2013 03:30 AM
As per my post on 7 May:
Your backups don't seem to exist anymore. All of the following are needed (not just one):
Failed to find all media needed for catalog DR image
The following NetBackup backup image could not be located.
Please make sure those media servers are correctly configured and those disk images are available.
Host Disk Image
server2 G:\BACKUP\server2_1345618852_C1_TIR *NULL*
server2 G:\BACKUP\server2_1345618852_C1_F1 *NULL*
server2 G:\BACKUP\server2_1345618820_C1_F1 *NULL*
So, you won't be able to recover from this particular backup. Sorry....
06-04-2013 03:37 AM
It is bad..
Thanks for all your help!