Php文档 Php问答行业资讯 Php论坛 Php手册 Php博客

游戏榜单

软件榜单

关闭导航

热搜榜

热门下载

热门标签

关闭搜索

php爱好者> php文档>shell写的数据库自动恢复脚本

shell写的数据库自动恢复脚本

时间：2010-09-26 来源：hero--008

已经测试通过的，主要用于ETL恢复动作（也可以用于其它的操作，只要更改相应的过程就可以）

#/bin/sh

#this shell script is used to recover the data

#author colin

#file syn_data_with_paysys.sh

#date Sun Sep 26 CST 2010

##set the env variable

ORACLE_SID=orcl
ORACLE_BASE=/opt/oracle
ORACLE_HOME=/opt/oracle/product/10.2.0
export ORACLE_SID ORACLE_BASE ORACLE_HOME

PWD_DIR=/home/oracle/shell
SQLPLUS=${ORACLE_HOME}/bin/sqlplus

##define the recover date

user_gamedata=$1
recover_date=$2

case $user_gamedata in
1) ORACLE_USERNAME=1
;;
1) ORACLE_USERNAME=2
;;
3) ORACLE_USERNAME=3
;;
4) ORACLE_USERNAME=4
;;
*) echo "please input the correct gamename and date such as:">&2

echo "nohup sh ./recover.sh JX1 2010-09-26&">&2

exit 1
;;
esac

##check the hour is even or odd

hour=`date +%k`
flag=`(($(($hour%2))==0))&&echo 0 ||echo 1`
while [ $flag -ne 1 ]
do
sleep 600s
hour=`date +%k`
flag=`(($(($hour%2))==0))&&echo 0 ||echo 1`
done

##start recover the data

${SQLPLUS} ${ORACLE_USERNAME} << !

set feedback off

set timing on

spool ${PWD_DIR}/log/recover.log;

DECLARE

v_running INT;

v_stat_date date:=to_date('$recover_date','yyyy-mm-dd');

BEGIN

SELECT COUNT ( * )

INTO v_running

FROM user_scheduler_running_jobs

WHERE job_name = 'SYN_DATA_WITH_PAYSYS';

IF v_running > 0

THEN

GOTO recover;

END IF;

jobs.syn_with_paysys_hourly;

DELETE FROM paysys_account_login_log

WHERE login_date = v_stat_date;

COMMIT;

BEGIN

-- Call the procedure

calculate_account.calculate_online_time (v_stat_date);

END;

BEGIN

-- Call the procedure

calculate_account.calculate_first_login_gway (v_stat_date);

END;

BEGIN

-- Call the procedure

calculate_account.calculate_online_acnt_day (v_stat_date);

END;

BEGIN

-- Call the procedure

calculate_idcard.calculate_online_idcard_day (v_stat_date);

END;

BEGIN

-- Call the procedure

calculate_indep_ip.calculate_indep_ip_day (v_stat_date);

END;

BEGIN

-- Call the procedure

calculate_no_idcard.calculate_no_idcard_day (v_stat_date);

END;

<<recover>>

DELETE FROM paysys_account_login_log

WHERE login_date = v_stat_date;

COMMIT;

BEGIN

-- Call the procedure

calculate_account.calculate_online_time (v_stat_date);

END;

BEGIN

-- Call the procedure

calculate_account.calculate_first_login_gway (v_stat_date);

END;

BEGIN

-- Call the procedure

calculate_account.calculate_online_acnt_day (v_stat_date);

END;

BEGIN

-- Call the procedure

calculate_idcard.calculate_online_idcard_day (v_stat_date);

END;

BEGIN

-- Call the procedure

calculate_indep_ip.calculate_indep_ip_day (v_stat_date);

END;

BEGIN

-- Call the procedure

calculate_no_idcard.calculate_no_idcard_day (v_stat_date);

END;

spool off

exit