Please find the steps and syntax to use backup the single table
[nz@SERVER_NAME DB_NAME]$ nz_backup -db DB_NAME -t ADMINISTRATOR_140923_152501 -dir /netback/backup/test/Netezza/NZ81331-H1/TEST/DB_NAME -format binary
nz_backup of database DB_NAME started on 2014-02-28 14:09:47
NZ_HOST:
NZ_USER: ADMIN
NZ_DATABASE: DB_NAME
Backup Directory: /netback/backup/test/Netezza/NZ81331-H1/TEST/DB_NAME
Backup Format: binary
Custom Script:
# Of Threads: 1
Using lastTXid: 3327032
The stableTXid value was: 3327031
Debug Mode: Disabled
=======================================================================================
Info: table 1 of 1 ADMINISTRATOR_140923_152501
Info: backup process started 2014-02-28 14:09:51
Info: estimated # of records 57,840
Info: unloading data ( thread 1 of 1 )
Info: data flowing ...
Info: unload finished ( thread 1 of 1 ) seconds 0
Info: unload results ( thread 1 of 1 ) INSERT 0 57840
Info: data flow finished
Info: backup process ended 2014-02-28 14:09:51
Info: source table size 6,029,312
Info: backup file size 1,650,875
Info: rate (backup file size / # of seconds elapsed) 1,650,875
Info: ratio (source table size / backup file size) 3.65
Info: # of records unloaded 57,840
Info: # of seconds elapsed 0
=======================================================================================
nz_backup of database DB_NAME finished on 2014-02-28 14:09:51
Total # of tables processed: 1
Total # of records unloaded: 57,840
Total # of seconds elapsed : 0
TOTAL source table size : 6,029,312
TOTAL backup file size : 1,650,875
rate (bytes per second) : 1,650,875
ratio (source / backup) : 3.65
=======================================================================================
[nz@SERVER_NAME DB_NAME]$ ls -ltr
total 1620
-rw-r--r-- 1 nz nz 1650875 Feb 28 14:09 ADMINISTRATOR_140923_152501.1
[nz@SERVER_NAME DB_NAME]$ nz_backup -db DB_NAME -t ADMINISTRATOR_140923_152501 -dir /netback/backup/test/Netezza/NZ81331-H1/TEST/DB_NAME -format binary
nz_backup of database DB_NAME started on 2014-02-28 14:09:47
NZ_HOST:
NZ_USER: ADMIN
NZ_DATABASE: DB_NAME
Backup Directory: /netback/backup/test/Netezza/NZ81331-H1/TEST/DB_NAME
Backup Format: binary
Custom Script:
# Of Threads: 1
Using lastTXid: 3327032
The stableTXid value was: 3327031
Debug Mode: Disabled
=======================================================================================
Info: table 1 of 1 ADMINISTRATOR_140923_152501
Info: backup process started 2014-02-28 14:09:51
Info: estimated # of records 57,840
Info: unloading data ( thread 1 of 1 )
Info: data flowing ...
Info: unload finished ( thread 1 of 1 ) seconds 0
Info: unload results ( thread 1 of 1 ) INSERT 0 57840
Info: data flow finished
Info: backup process ended 2014-02-28 14:09:51
Info: source table size 6,029,312
Info: backup file size 1,650,875
Info: rate (backup file size / # of seconds elapsed) 1,650,875
Info: ratio (source table size / backup file size) 3.65
Info: # of records unloaded 57,840
Info: # of seconds elapsed 0
=======================================================================================
nz_backup of database DB_NAME finished on 2014-02-28 14:09:51
Total # of tables processed: 1
Total # of records unloaded: 57,840
Total # of seconds elapsed : 0
TOTAL source table size : 6,029,312
TOTAL backup file size : 1,650,875
rate (bytes per second) : 1,650,875
ratio (source / backup) : 3.65
=======================================================================================
[nz@SERVER_NAME DB_NAME]$ ls -ltr
total 1620
-rw-r--r-- 1 nz nz 1650875 Feb 28 14:09 ADMINISTRATOR_140923_152501.1
No comments:
Post a Comment