用run

xiaoxiao2021-02-28  130

先把文件拷贝到

 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'

转载请注明原文地址: https://www.6miu.com/read-45969.html

最新回复(0)