批处理真不好写~,现把成果粘贴出来留个纪念~~~
@echo off
rem =======================================================================
rem = ① 本批处理实现目录数据的导出 ---20160816 =
rem =======================================================================
cd..
set OrgID=83a9280f-2b19-4bc9-ab37-78f94b64dc76
set DumpFolder=d:
set LogFolder=d:
set FileDate=%Date:~0,4%%Date:~5,2%%Date:~8,2%
set UserName=datacenter
set Password=datacenter
set NetServer=orcl
rem ===================
rem = 备份源库 =
rem ===================
cd %DumpFolder%
echo 开始备份源库数据......
start /b /wait exp %UserName%/%Password%@%NetServer% tables=(rc_catalog_basic,rc_resource_info,rc_dynamic_authority) file=%DumpFolder%\%OrgID%_%FileDate%.dmp log=%LogFolder%\%OrgID%_exp_%FileDate%.log
echo 源库数据备份完毕!
pause
exit
@echo off
rem =======================================================================
rem = ② 本批处理实现目录数据同步到中心 ---20160816 =
rem =======================================================================
set DumpFolder=d:\dmp
set LogFolder=d:\log
set FileDate=%Date:~0,4%%Date:~5,2%%Date:~8,2%
set UserName=datacenter
set Password=datacenter
set NetServer=orcl
for /f "tokens=1 delims=_" %%i in ('dir /a-d /b *.dmp') do (
echo insert into rc_catalog_basic_bak select * from rc_catalog_basic where organization_id = '%%i';>%DumpFolder%\pre.sql
echo insert into rc_resource_info_bak select * from rc_resource_info t where (t.catalog_resource_id,t.version^) in (select catalog_resource_id,version from rc_catalog_basic where organization_id = '%%i'^);>>%DumpFolder%\pre.sql
echo insert into rc_dynamic_authority_bak select * from rc_dynamic_authority t where (t.catalog_resource_id,t.version^) in (select catalog_resource_id,version from rc_catalog_basic where organization_id = '%%i'^);>>%DumpFolder%\pre.sql
echo commit;>>%DumpFolder%\pre.sql
echo delete from rc_catalog_basic where organization_id = '%%i';>>%DumpFolder%\pre.sql
echo delete from rc_resource_info t where (t.catalog_resource_id,t.version^) in (select catalog_resource_id,version from rc_catalog_basic where organization_id = '%%i'^);>>%DumpFolder%\pre.sql
echo delete from rc_dynamic_authority t where (t.catalog_resource_id,t.version^) in (select catalog_resource_id,version from rc_catalog_basic where organization_id = '%%i'^);>>%DumpFolder%\pre.sql
echo commit;>>%DumpFolder%\pre.sql
echo exit;>>%DumpFolder%\pre.sql
echo 前置机%%i数据环境准备初始化。。。
start /b /wait sqlplus %UserName%/%Password%@%NetServer% @%DumpFolder%\pre.sql >%LogFolder%\%%i_pre_%FileDate%.log
echo 前置机%%i数据环境初始化完毕!
echo 前置机%%i准备同步数据。。。
imp %UserName%/%Password%@%NetServer% fromuser=%UserName% touser=%UserName% ignore=y file=%DumpFolder%\%%i_%FileDate%.dmp log=%LogFolder%\%%i_imp_%FileDate%.log
echo 前置机%%i同步数据完成!
echo 前置机%%iDMP文件准备删除。。。
del %DumpFolder%\%%i_%FileDate%.dmp
echo 前置机%%iDMP文件删除完成!
)
pause