将数据库备份并推送到相应的ftp下的命令:
#!/bin/bash
#del arclog by lccsource ~/.bash_profile
LocalPath=/home/oracle/zhourl
sysdate=`date +%Y%m%d`
yesterday=`date -d '1 days ago' +%Y%m%d`
cd $LocalPath
if [ -s "exp_table_sccpuser2sccpdb240_${yesterday}.dmp" ]; then
rm exp_table_sccpuser2sccpdb240_${yesterday}.dmp
fi
echo "[`date +%Y%m%d%H%M%S`] Begin to exp exp_table_sccpuser2sccpdb240_${sysdate}.dmp!" >>$LocalPath/exp_table_sccpuser2sccpdb240_$sysdate.log
exp sccpuser/sccpuser@cleardb file=$LocalPath/exp_table_sccpuser2sccpdb240_${sysdate}.dmp tables=sccpuser.ps_settle_jnl,sccpuser.ps_manage_jnl,sccpuser.ac_mch_acc log=$LocalPath/exp_table_sccpuser2sccpdb240_$sysdate.log TRIGGERS=no;
echo "[`date +%Y%m%d%H%M%S`] Begin to ftp exp_table_sccpuser2sccpdb240_${sysdate}.dmp to 172.58.250.100 !" >>$LocalPath/exp_table_sccpuser2sccpdb240_$sysdate.log
ftp -i -n 172.58.250.100 21 <<FTPFILE >>$LocalPath/ftp_$sysdate.log
user scspftp scsp@123
bin
lcd $LocalPath
cd sccp
put exp_table_sccpuser2sccpdb240_${sysdate}.dmp
bye
FTPFILE
---------------------
linux常用命令:
ll 全部文件
ri 修改文件 desc q w
cat 查看文件
sz 下载
rz 上传
ps -ef|grep tomcat |grep 用户名 (查询用户下的进程)
lill -9 进程ID (杀死该进程)
tail -f catalina.out (在logs中查出输出)
vi 新建文件( Esc + shift + : 退出保存)
mkdir 新建文件夹(mkdir aa)
cp aa.txt bb.txt (复制)
mv 剪切;
tar vxf T+N.tar (解压tar格式)
imp sccphh/oracle@cleardb file=sccpuser.dmp full = y ignore=y
exp sccpuser/sccpuser@cleardb file=sccpuser.dmp table=sccpuser.ps_settle_jnl,sccpuser.ps_clear_jnl owner=(sccpuser)
exp sccpuser/sccpuser@cleardb file=sccpuser.dmp full = y;
exp system/manager@TEST file=d:daochu.dmp owner=(system,sys)
文件批量大小写转换:
mv aaa.txt AAA.TXT (将文件名由小写转成大写)