shell脚本远程升级数据库

来源：互联网发布：男士冬季搭配知乎编辑：程序博客网时间：2024/06/05 20:45

#!/bin/shbackupdatedb(){        ssh $remoteIp "mkdir /opt/oracle/exp_dp/;chown oracle:oinstall /opt/oracle/exp_dp -R" 2>/dev/null        ssh $remoteIp "        su - oracle -c \"        sqlplus -s /\"\" as sysdba  <<ef                create directory exp_dp as '/opt/oracle/exp_dp';                grant read,write on directory exp_dp to user;        ef        \"        "         ssh $remoteIp "         su - oracle -c \"         expdp user/user@user schemas=user directory=exp_dp dumpfile=expdp_cqgdjk.dmp logfile=expdp_cqgda.log          \"        "        return 0}remoteIp=`grep DB file |awk -F ' ' '{print $2}'|tr -d ' '`echo "get remoteId is $remoteIp" >  db.logecho "begin to backupdate db" >> db.logbackupdatedbecho "backup db success and bgein to update db"  >> db.logscp update.sql $remoteIp:/home/oracle/ssh $remoteIp "chown oracle:oinstall /home/oracle/update.sql"ssh  $remoteIp "su - oracle -c \"sqlplus -s user/\"user\"  <<ef@update.sqlef\""

0 0