Troubleshooting
Problem
The nzrestore -dir command fails with "Error: No backupset for host error."
Resolving The Problem
This error usually occurs because either the -connector veritas option was specified or the path supplied with -dir was incorrect.
You can only use the -dir option if you also specified -connector filesystem. If you specified -connector veritas, the -dir option is invalid.
Another common error is specifying the wrong pathname to the -dir option. You must specify the same directory path that was used when the backup was created. For example:
If the backup was created using the following command:
- nzbackup -db TEST -connector filesystem -dir /backups/prod
then the following command would restore this backup:
- nzrestore -db TEST -connector filesystem -dir /backups/prod
Also note that the pathname you should use is not the full path found in the backup log files. Although the full path is of the form /<chosen root dir>/Netezza/<hostname>/<db name>/<backupset>/1/FULL, the nzrestore command expects only the root directory.
The no backupset for host error command can also be caused by syntax issues:
1. The original database backed up is being restored to a database with a different name.
a. Use these two options: -db <target database> -sourcedb <source database>
2. The original database was backed up on a different NPS system.
a. Use this option: -npshost <source npshost>
Note that sometimes you may need a combination of the above depending on the restore scenario.
Historical Number
NZ103703
Was this topic helpful?
Document Information
More support for:
IBM PureData System
Software version:
1.0.0
Document number:
462751
Modified date:
17 October 2019
UID
swg21570472