#########################check.sh###################################
#!/bin/bash
export PATH
unset USERNAME
source ~/.bash_profile
unset USERNAME
echo `date +%Y%m%d` 比对任务开始 ,`date +%Y%m%d-%T`>> /check_system/log.txt
sqlplus / as sysdba << EOF
set linesize 200
@/check_system/cc.sql;
exit;
EOF
mv /check_system/diff.log /check_system/diff_`date +%Y%m%d`.log
echo `date +%Y%m%d` 比对任务完成 ,`date +%Y%m%d-%T`>> /check_system/log.txt
echo ' '>> /check_system/log.txt
################################cc.sql################################
set echo on ;
spool /check_system/diff.log;
select count(*) from SECURITIES.TZQGL@X5RAC2 minus select count(*) from SECURITIES.TZQGL;
select count(*) from ACCOUNT.TZJZH@X5RAC2 minus select count(*) from ACCOUNT.TZJZH;
……
spool off;
