Friday, June 1, 2018

what will happen when you do the full Netezza database restore without specifying the back upset number?

When you try to restore the Netezza database without specifying the back upset ,it will success and it will perform the restore and It will pick the latest backup set from the list and do the restore.

nz@Netezza_Server:/backup1/Netezza/NZ81258-H1/Netezza_DB> ls -ltr
total 24
drwxr-xr-x 3 nz nz 4096 Apr 18 17:53 20180417210222
drwxr-xr-x 3 nz nz 4096 May 14 10:30 20180508000011
drwxr-xr-x 3 nz nz 4096 May 14 10:30 20180501000013
drwxr-xr-x 3 nz nz 4096 May 14 10:30 20180424000009
drwxr-xr-x 3 nz nz 4096 May 14 20:51 20180515000109
drwxr-xr-x 3 nz nz 4096 May 26 23:18 20180522000016


/nz/kit/bin/nzrestore -db  Netezza_DB  -dir /backup1 -lockdb true  -npshost NZ81258-H1

Restore of increment 1 from backupset 20180522000016 to database 'Netezza_DB' committed.

from the above demo,we have 6 backup set with full backup on database,but when we do the Netezza database restore,it picked the last backup and recent backup set and completed the restore.

No comments:

Post a Comment