先把文件拷贝到
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'