IBM Netezza aka PureData for Analytics
NZBACKUP |
|
Backup a database
Save user credentials into variables.
export NZ_user=<user with proper privileges>
export NZ_password=<password for above user>
nzbackup -dir <backup location> -db <dbname>
Save user credentials into variables.
export NZ_user=<user with proper privileges>
export NZ_password=<password for above user>
nzbackup -dir <backup location> -db <dbname>
Helpful Linux commands
I am a newbie to Linux. Here are 12 helpful Linux commands .
http://www.tecmint.com/how-to-check-disk-space-in-linux/
http://www.tecmint.com/how-to-check-disk-space-in-linux/
How do find Increment ID for a backupset |
|
NZRestore -incrementlist -dir <backup directory> -sourcedb <dbname>
NZRestore Examples |
|
Restore table to a new DB (must include –sourceschema or restore will fail)
nzrestore –dir /<file path> –db <dbname> -sourcedb <dbname> -sourceschema <schema name> –tables <table name>
Restore to another server
nzrestore –dir /<file path >–db <dbname> -npshost <virtual instance>
Restore differential and cumulative (-lockdb sets db to readonly… use –unlock parameter when to finish restore differentials)
Nzrestore –dir /<file path>–db <dbname> -npshost <virtual instance> –increment 1 –lockdb true
nzrestore –dir /<file path> –db <dbname> -sourcedb <dbname> -sourceschema <schema name> –tables <table name>
Restore to another server
nzrestore –dir /<file path >–db <dbname> -npshost <virtual instance>
Restore differential and cumulative (-lockdb sets db to readonly… use –unlock parameter when to finish restore differentials)
Nzrestore –dir /<file path>–db <dbname> -npshost <virtual instance> –increment 1 –lockdb true
NZRestore Disaster Recovery Process |
|
If you need a DR copy of a database. Here is the process. Restore DB with a new name. Drop the old database and rename the freshly restored DB to the old DB name. The apply cumulative backups and you are done.
export NZ_user=<username>
export NZ_password=<password>
<dbname>nzrestore -dir /nzbkup/dev -db <newdbname> -sourcedb <dbname> -lockdb true
drop database <olddbname>
ALTER DATABASE <newdbname> RENAME TO <olddbName>;
nzrestore -dir /nzbkup/dev -db <dbname> -npshost <hostname> -increment REST -lockdb true
export NZ_user=<username>
export NZ_password=<password>
<dbname>nzrestore -dir /nzbkup/dev -db <newdbname> -sourcedb <dbname> -lockdb true
drop database <olddbname>
ALTER DATABASE <newdbname> RENAME TO <olddbName>;
nzrestore -dir /nzbkup/dev -db <dbname> -npshost <hostname> -increment REST -lockdb true