用run_full_trafodion_backup.sh全库备份恢复单表

来源：互联网发布：mac安装win10激活码编辑：程序博客网时间：2024/05/29 19:37

先把文件拷贝到

Hbase org.trafodion.utility.backuprestore.TrafExportSnapshot -D hbase.rootdir=hdfs://zhhost1.localdomain:8020/trafodion_backups/DBdata_bak/backup_20170627-1414/TRAFODION.BOSTECH_SCHEMA.CONF_CATALOG_FIELD_SNAP_20170627-1414 -snapshot TRAFODION.BOSTECH_SCHEMA.CONF_CATALOG_FIELD_SNAP_20170627-1414 -copy-to hdfs://zhhost1.localdomain:8020/hbase -mappers 0 -mr-lowlimit-mb 100

执行该命令把TRAFODION.BOSTECH_SCHEMA.CONF_CATALOG_FIELD_SNAP_20170627-1414目录下的snapshot文件拷贝到/hbase/.hbase-snapshot目录下面，重点就是要把这个表的主键和外键都要拷贝过去
hbase org.trafodion.utility.backuprestore.TrafExportSnapshot -D hbase.rootdir=hdfs://zhhost1.localdomain:8020/trafodion_backups/DBdata_bak/backup_20170627-1414/TRAFODION.BOSTECH_SCHEMA.FK_CONF_CATALOG_FIELD_CATALOG_ID_SNAP_20170627-1414 -snapshot TRAFODION.BOSTECH_SCHEMA.FK_CONF_CATALOG_FIELD_CATALOG_ID_SNAP_20170627-1414 -copy-to hdfs://zhhost1.localdomain:8020/hbase -mappers 0 -mr-lowlimit-mb 100

然后进去hbase shell执行下面命令：

list_snapshots查看snapshot

顺序执行：

disable 'TRAFODION.BOSTECH_SCHEMA.CONF_CATALOG_FIELD'

disable 'TRAFODION.BOSTECH_SCHEMA.FK_CONF_CATALOG_FIELD_CATALOG_ID'

restore_snapshot'TRAFODION.BOSTECH_SCHEMA.CONF_CATALOG_FIELD_SNAP_20170627-1414'

restore_snapshot'TRAFODION.BOSTECH_SCHEMA.FK_CONF_CATALOG_FIELD_CATALOG_ID_SNAP_20170627-1414'

enable 'TRAFODION.BOSTECH_SCHEMA.CONF_CATALOG_FIELD'

enable'TRAFODION.BOSTECH_SCHEMA.FK_CONF_CATALOG_FIELD_CATALOG_ID'

阅读全文

0 0