一个数据仓库数据刷新的实现机制（八）

shell refresh_all

通过6次调用脚本refresh_schema，刷新6各国家所有指定的数据库对象

[@more@]

该脚本比较简单，就是6次调用refresh_schema。

在前面加上环境变量，以使能通过cron调用自动运行该脚本。

为了能并行刷新，每条命令后面加了&符号。

用法：

$refresh_all

shell refresh_all脚本如下：

#############################################################
#
# Purpose: refresh all the necessary objects required by EDEN project
#
# Usage: refresh_all
#        If  there are more/less schemas' objects to be refreshed,
#        please add/delete the command here
#        To add: refresh_schema SCHEMA SCHEMA_PASSWORD SCHEMA2 SCHEMA_PASSWORD2
#
# by James.Yu TCS China
# Dec-19-2004
#
#############################################################

#!/usr/bin/bash

ORACLE_SID=service_name                           ; export ORACLE_SID
ORACLE_HOME=/oraclenew/app/oracle/product/9ias_1021; export ORACLE_HOME
ORACLE_BASE=/oraclenew/app/oracle  ; export ORACLE_BASE
ORACLE_PATH=${ORACLE_HOME}/rdbms/aps       ; export ORACLE_PATH
PATH=${PATH}:$ORACLE_HOME/bin:/usr/ccs/bin ; export PATH
PATH=${PATH}:/usr/openwin/bin              ; export PATH
PATH=${PATH}:/oracle/tools/bin             ; export PATH
PATH=${PATH}:$II_SYSTEM/ingres/bin:$II_SYSTEM/ingres/utility; export PATH
PATH=${PATH}:/erdb/bin; export PATH
LD_LIBRARY_PATH=${PATH}:$ORACLE_HOME/lib   ; export LD_LIBRARY_PATH
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/oracle/tools/lib  ; export LD_LIBRARY_PATH
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/usr/openwin/lib   ; export LD_LIBRARY_PATH
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/usr/dt/lib        ; export LD_LIBRARY_PATH
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1               ; export NLS_LANG 
TNS_ADMIN=$ORACLE_HOME/network/admin/;export TNS_ADMIN

#################################
# Main
#################################

/usr/bin/bash /erdb/bin/refresh_schema EDENFR passowrdfr EWRFRMASTER passowrdfr2 &
/usr/bin/bash /erdb/bin/refresh_schema EDENUK passowrduk  EWRUKMASTER passowrduk2 &
/usr/bin/bash /erdb/bin/refresh_schema EDENES passowrdes  EWRESMASTER passowrdes2 &
/usr/bin/bash /erdb/bin/refresh_schema EDENDE passowrdde  EWRDEMASTER passowrdde2 &
/usr/bin/bash /erdb/bin/refresh_schema EDENIT passowrdit  EWRITMASTER passowrdit2 &
/usr/bin/bash /erdb/bin/refresh_schema EDENPO passowrdpo  EWRPOMASTER passowrdpo2 &

cron里面调用：

$crontab -l

00 04 * * 1,2,3,4,5,6 /erdb/bin/refresh_all 2> /erdb/log/refresh_all_cron.log

......

其中通过cron调用该脚本时碰到了一些问题，可以参考文档

http://blog.itpub.net/post/334/14066

http://blog.itpub.net/post/334/14486

http://blog.itpub.net/post/334/14680

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/207/viewspace-795327/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/207/viewspace-795327/