Wednesday, November 13, 2013

script to do full restore on Netezza database

2013-08-02 12:55:09.428218 PDT Info: NZ-00022: --- program 'restoresvr' (4080) starting on host 'nsdwt03' ... ---
2013-08-02 12:55:09.454282 PDT Info: Restore command: nzrestore -u admin -db XYZ -sourcedb ABC -dir /netback_old/backup/july -backupset 20130721195736 -npshost VIP
2013-08-02 12:55:09.454302 PDT Info: Setting the command line options
2013-08-02 12:55:09.776227 PDT Info: Restoring from base directory '/netback_old/backup/july'
2013-08-02 12:55:09.776362 PDT Info: Starting the restore process
2013-08-02 12:57:24.888546 PDT Info: Reading locations file
2013-08-02 12:57:25.459500 PDT Info: Warning: Invalid backupset, found /Netezza/VIP.petc.com/ABC/20130721195736/1/FULL in locations.txt, expected /Netezza/VIP/ABC/20130721195736/1/FULL.
2013-08-02 12:57:26.871784 PDT Info: Reading schema from /netback_old/backup/july/Netezza/<VIP>/ABC/20130721195736/1/FULL/md
2013-08-02 12:57:26.872418 PDT Info: Opening pipe for schema read ...
2013-08-02 12:57:27.252432 PDT Info: Restoring a 4.0 backup from NPS Release 6.0.2 (P-1) [Build 17433] created on xs system 'nsdwp01'
2013-08-02 12:57:27.252454 PDT Info: Restore of 92 dataslice backupset to 46 dataslice system
2013-08-02 12:57:27.657741 PDT Info: Operation txid and history table record 2773474
2013-08-02 12:57:27.669672 PDT Info: Restoring schema
2013-08-02 12:58:24.897130 PDT Info: Start restoring the data, compressed format.

No comments:

Post a Comment