BackupCleanDB_RestoreData

更新数据保留时间

塞入

已完成

结束

主体流程

获取SNList

审批

调用

3.循环恢复数据

SNWOBSNBWOIP

循环备份表BKList

Table

删除SNList表数据tb:RestoreData_SNList

用户上传SN/WO

BackupCleanDB_RestoreData_One 恢复数据

KeyType=SN/WO

KeyType=Special

Job/人工

BackupCleanDB_RestoreData_Special获取特殊表的SNList

BackupCleanDB_RestoreData_GetSNList获取需恢复的SNList

SP

SNFindFlagIP

开始

tb:RestoreData_InputList

TableName(目标表)BK_TableName(备份表)KeyList(备份主键)KeyType(主键类型)RestoreContinue(是否继续)SqlType(恢复方式)

BackupCleanDB_RestoreData_GenTableList获取所有需要恢复的表

tb:BackupCleanDB_RestoreTableList

1.获取SNList

tb:RestoreData_SNList

BackupCleanDB_RestoreData

2.获取备份表BKList

BackupCleanDB_RestoreData_GenBKTableList获取所有备份表