用户基础数据平台迁移适配经验分享

-- ------------------------------------------------------------切换步骤
-- 配置表切换
-- 1
CREATE TABLE BD_DB_F.SG_T_LOADCONFIG_INCR_20240613_BAK          LIKE  BD_DB_F.SG_T_LOADCONFIG_INCR        ;
CREATE TABLE BD_DB_APBLC.SG_T_LOADCONFIG_INCR_ODM_20240613_BAK  LIKE  BD_DB_APBLC.SG_T_LOADCONFIG_INCR_ODM;
CREATE TABLE BD_DB_F.GBASE8A_I2F_CONFIG_TABLE_20240613_BAK      LIKE  BD_DB_F.GBASE8A_I2F_CONFIG_TABLE    ;
CREATE TABLE BD_DB_APBLC.GBASE8A_I2B_CONFIG_TABLE_20240613_BAK  LIKE  BD_DB_APBLC.GBASE8A_I2B_CONFIG_TABLE;

-- 2
INSERT INTO BD_DB_F.SG_T_LOADCONFIG_INCR_20240613_BAK          SELECT * FROM BD_DB_F.SG_T_LOADCONFIG_INCR        ;
INSERT INTO BD_DB_APBLC.SG_T_LOADCONFIG_INCR_ODM_20240613_BAK  SELECT * FROM BD_DB_APBLC.SG_T_LOADCONFIG_INCR_ODM;
INSERT INTO BD_DB_F.GBASE8A_I2F_CONFIG_TABLE_20240613_BAK      SELECT * FROM BD_DB_F.GBASE8A_I2F_CONFIG_TABLE    ;
INSERT INTO BD_DB_APBLC.GBASE8A_I2B_CONFIG_TABLE_20240613_BAK  SELECT * FROM BD_DB_APBLC.GBASE8A_I2B_CONFIG_TABLE;

-- 3
四张表导出，批量替换
OPER_CODE IS NULL
为
OPER_CODE != ''D''

-- 4
TRUNCATE TABLE BD_DB_F.SG_T_LOADCONFIG_INCR        ;
TRUNCATE TABLE BD_DB_APBLC.SG_T_LOADCONFIG_INCR_ODM;
TRUNCATE TABLE BD_DB_F.GBASE8A_I2F_CONFIG_TABLE    ;
TRUNCATE TABLE BD_DB_APBLC.GBASE8A_I2B_CONFIG_TABLE;

-- 5
再批量导入四张表。

-- 核心备份程序切换
-- 1 查找
find /picclife/gbase_shell/data_load_everyday/ -name '*' -type f|grep -iv log|xargs -I {} grep -r '**.**.**.**' {} -H
find /picclife/gbase_shell/data_load_everyday/ -name '*' -type f|grep -iv log|xargs -I {} grep -r '********' {} -H

-- 2 替换
find /picclife/gbase_shell/data_load_everyday/ -name '*' -type f|grep -iv log|xargs -I {} sed -i 's/********/********/g' {}
find /picclife/gbase_shell/data_load_everyday/ -name '*' -type f|grep -iv log|xargs -I {} sed -i 's/**.**.**.**/**.**.**.**/g' {}

-- 3 验证
find /picclife/gbase_shell/data_load_everyday/ -name '*' -type f|grep -iv log|xargs -I {} grep -r '**.**.**.**' {} -H
find /picclife/gbase_shell/data_load_everyday/ -name '*' -type f|grep -iv log|xargs -I {} grep -r '********' {} -H

-- Moia程序切换
-- 1 查找
find /picclife/bdss/bdss_moia/config -name '*' -type f|xargs -I {} grep -r '**.**.**.**' {} -H
find /picclife/bdss/bdss_moia/config -name '*' -type f|xargs -I {} grep -r '********' {} -H

-- 2 替换
find /picclife/bdss/bdss_moia/config -name '*' -type f|xargs -I {} sed -i 's/********/********/g' {}
find /picclife/bdss/bdss_moia/config -name '*' -type f|xargs -I {} sed -i 's/**.**.**.**/**.**.**.**/g' {}

-- 3 验证
find /picclife/bdss/bdss_moia/config -name '*' -type f|xargs -I {} grep -r '**.**.**.**' {} -H
find /picclife/bdss/bdss_moia/config -name '*' -type f|xargs -I {} grep -r '********' {} -H

-- 准实时程序切换-由于影响当日跑数-放到0614日运行
-- 1 查找
find /picclife/gbase_shell/load_by_hour/ -name '*' -type f|grep -iv log|grep -iv txt|grep -iv tmp|xargs -I {} grep -r '**.**.**.**' {} -H
find /picclife/gbase_shell/load_by_hour/ -name '*' -type f|grep -iv log|grep -iv txt|grep -iv tmp|xargs -I {} grep -r '********' {} -H

-- 2 替换
find /picclife/gbase_shell/load_by_hour/ -name '*' -type f|grep -iv log|grep -iv txt|grep -iv tmp|xargs -I {} sed -i 's/********/********/g' {}
find /picclife/gbase_shell/load_by_hour/ -name '*' -type f|grep -iv log|grep -iv txt|grep -iv tmp|xargs -I {} sed -i 's/**.**.**.**/**.**.**.**/g' {}

-- 3 验证
find /picclife/gbase_shell/load_by_hour/ -name '*' -type f|grep -iv log|grep -iv txt|grep -iv tmp|xargs -I {} grep -r '**.**.**.**' {} -H
find /picclife/gbase_shell/load_by_hour/ -name '*' -type f|grep -iv log|grep -iv txt|grep -iv tmp|xargs -I {} grep -r '********' {} -H

-- ------------------------------------------------------------回退步骤
-- 配置表回退
-- 1
TRUNCATE TABLE BD_DB_F.SG_T_LOADCONFIG_INCR        ;
TRUNCATE TABLE BD_DB_APBLC.SG_T_LOADCONFIG_INCR_ODM;
TRUNCATE TABLE BD_DB_F.GBASE8A_I2F_CONFIG_TABLE    ;
TRUNCATE TABLE BD_DB_APBLC.GBASE8A_I2B_CONFIG_TABLE;

-- 2
INSERT INTO BD_DB_F.SG_T_LOADCONFIG_INCR          SELECT * FROM BD_DB_F.SG_T_LOADCONFIG_INCR_20240613_BAK        ;
INSERT INTO BD_DB_APBLC.SG_T_LOADCONFIG_INCR      SELECT * FROM BD_DB_APBLC.SG_T_LOADCONFIG_INCR_ODM_20240613_BAK;
INSERT INTO BD_DB_F.GBASE8A_I2F_CONFIG_TABLE      SELECT * FROM BD_DB_F.GBASE8A_I2F_CONFIG_TABLE_20240613_BAK    ;
INSERT INTO BD_DB_APBLC.GBASE8A_I2B_CONFIG_TABLE  SELECT * FROM BD_DB_APBLC.GBASE8A_I2B_CONFIG_TABLE_20240613_BAK;

-- 核心备份程序回退
-- 1 查找
find /picclife/gbase_shell/data_load_everyday/ -name '*' -type f|grep -iv log|xargs -I {} grep -r '**.**.**.**' {} -H
find /picclife/gbase_shell/data_load_everyday/ -name '*' -type f|grep -iv log|xargs -I {} grep -r '********' {} -H

-- 2 替换
find /picclife/gbase_shell/data_load_everyday/ -name '*' -type f|grep -iv log|xargs -I {} sed -i 's/********/********/g' {}
find /picclife/gbase_shell/data_load_everyday/ -name '*' -type f|grep -iv log|xargs -I {} sed -i 's/**.**.**.**/**.**.**.**/g' {}

-- 3 验证
find /picclife/gbase_shell/data_load_everyday/ -name '*' -type f|grep -iv log|xargs -I {} grep -r '**.**.**.**' {} -H
find /picclife/gbase_shell/data_load_everyday/ -name '*' -type f|grep -iv log|xargs -I {} grep -r '********' {} -H

-- Moia程序回退
-- 1 查找
find /picclife/bdss/bdss_moia/config -name '*' -type f|xargs -I {} grep -r '**.**.**.**' {} -H
find /picclife/bdss/bdss_moia/config -name '*' -type f|xargs -I {} grep -r '********' {} -H

-- 2 替换
find /picclife/bdss/bdss_moia/config -name '*' -type f|xargs -I {} sed -i 's/********/********/g' {}
find /picclife/bdss/bdss_moia/config -name '*' -type f|xargs -I {} sed -i 's/**.**.**.**/**.**.**.**/g' {}

-- 3 验证
find /picclife/bdss/bdss_moia/config -name '*' -type f|xargs -I {} grep -r '**.**.**.**' {} -H
find /picclife/bdss/bdss_moia/config -name '*' -type f|xargs -I {} grep -r '********' {} -H

-- 准实时程序回退
-- 1 查找
find /picclife/gbase_shell/load_by_hour/ -name '*' -type f|grep -iv log|grep -iv txt|grep -iv tmp|xargs -I {} grep -r '**.**.**.**' {} -H
find /picclife/gbase_shell/load_by_hour/ -name '*' -type f|grep -iv log|grep -iv txt|grep -iv tmp|xargs -I {} grep -r '********' {} -H

-- 2 替换
find /picclife/gbase_shell/load_by_hour/ -name '*' -type f|grep -iv log|grep -iv txt|grep -iv tmp|xargs -I {} sed -i 's/********/********/g' {}
find /picclife/gbase_shell/load_by_hour/ -name '*' -type f|grep -iv log|grep -iv txt|grep -iv tmp|xargs -I {} sed -i 's/**.**.**.**/**.**.**.**/g' {}

-- 3 验证
find /picclife/gbase_shell/load_by_hour/ -name '*' -type f|grep -iv log|grep -iv txt|grep -iv tmp|xargs -I {} grep -r '**.**.**.**' {} -H
find /picclife/gbase_shell/load_by_hour/ -name '*' -type f|grep -iv log|grep -iv txt|grep -iv tmp|xargs -I {} grep -r '********' {} -H

-- 核心备份程序、Moia程序、准实时程序上述回退失败，请使用/picclife/ScriptBak/20240604/目录下的文件进行cp复制替换，而不是删除源目录再拷贝，
-- 因为备份只有代码，没有日志目录、备份目录等，请注意。