AWS S3、MinIO,和IBMCOS 备份和还原命令示例

部署选项：将 "Netezza Performance Server换成 "Cloud Pak for Data System'将 "Netezza Performance Server换成 "Cloud Pak for Data

本节演示并讨论备份和还原到AWS S3、MinIO,和IBMCOS 云存储的示例命令。

AWS S3

备份到AWS S3

$ nzbackup -db src_db -connector s3 -connectorArgs UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxx:SECRET_ACCESS_KEY=xxxxx:DEFAULT_REGION=us-west-1:BUCKET_URL=my.backup.bucket

从AWS S3恢复

$ nzrestore -db target_db -sourcedb src_db -connector s3 -connectorArgs UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxx:SECRET_ACCESS_KEY=xxxxx:DEFAULT_REGION=us-west-1:BUCKET_URL=my.backup.bucket

注意："ENDPOINT和 "MULTIPART_SIZE_MB不是必填项。

MinIO

备份到MinIO

nzbackup -db src_db -connector minio -connectorArgs UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxxx:SECRET_ACCESS_KEY=xxxxxx: DEFAULT_REGION=us-east-1:BUCKET_URL=my.backup.bucket: ENDPOINT=hostname

恢复到MinIO

nzrestore -db target_db -sourcedb src_db -connector minio -connectorArgs UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxxx:SECRET_ACCESS_KEY=xxxxxx: DEFAULT_REGION=us-east-1:BUCKET_URL=my.backup.bucket: ENDPOINT=hostname

注意："ENDPOINT为必填项。

IBM COS

备份到IBMCOS

$ nzbackup -db src_db -connector ibmcos -connectorArgs UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxxx:SECRET_ACCESS_KEY=xxxxx:DEFAULT_REGION=us_geo:BUCKET_URL=my.backup.bucket:ENDPOINT=s3.us-east.cloud-object-storage.appdomain.cloud

从IBMCOS 恢复

$ nzrestore -db target_db -sourcedb src_db -connector ibmcos -connectorArgs UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxxx:SECRET_ACCESS_KEY=xxxxx:DEFAULT_REGION=us_geo:BUCKET_URL=my.backup.bucket:ENDPOINT=s3.us-east.cloud-object-storage.appdomain.cloud

注意："ENDPOINT为必填项。