Restore History report

Deployment options: IBM Netezza Appliance IBM Netezza Appliance

Use the Restore History report during a multistep restore to learn what restores were run on the system.

The following example displays the restore history for a specific database:

nzrestore -history

Note: You can further refine your results by using the -db and -connector options, or use the -v option for more information. You use the -db option to see only the history of a specified database.

The command displays the following information:

Table 1. Restore history source
Column	Description
Restore DB	The name of the restore database.
Backup DB	The name of the source database.
Backup Set	The unique value that identifies the backup set.
Seq.No	The sequence number that identifies the increment within the backup set.
Database	The name of the backup database.
OpType	The type of restore (for example, users, full, Incr:upto, Incr:next, Incr:rest).
Db Locked	Whether the database is locked.
Date	The date and time that the restore was initiated.
Status	The status (completed, failed, in-progress).
Log File	The log file for the restore.