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

先把文件拷贝到

 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'