• 有crontab中的脚本不执行,需要在脚本里面export各种环境变量


    [oracle@sta ~]$ vi .bash_profile

    # .bash_profile

    # Get the aliases and functions
    if [ -f ~/.bashrc ]; then
    . ~/.bashrc
    fi

    # User specific environment and startup programs

    PATH=$PATH:$HOME/bin

    export PATH
    export PATH
    ORACLE_BASE=/u01/app/oracle
    ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1/
    ORACLE_SID=jg
    PATH=$ORACLE_HOME/bin:$PATH
    export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH
    ~
    ~
    [oracle@sta ~]$ crontab -l
    */30 * * * * /opt/jj/system.sh
    30 11,17 * * * /opt/jj/oracle.sh
    0 0 */3 * * /u01/oracle/exp.sh
    30 4 * * * /opt/jj/back.sh
    #0 4 * * * /opt/jjbak/scripts/jjbak.sh
    0 4 * * * sh /u01/oracle/hydir/jjbak.sh >> /u01/oracle/oydir/oy.log &


    [oracle@sta ~]$ cat /u01/oracle/hydir/jjbak.sh
    #!/bin/sh
    echo 'backup start!'
    export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/
    export ORACLE_SID=jg
    /u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target / <<EOF!
    backup incremental level=1 database;
    recover copy of database;
    quit
    EOF!
    echo "image copy success!"
    /u01/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus / as sysdba <<EOF!
    CREATE PFILE='/opt/jjbak/pfile/pfilejg.ora' from spfile ;
    quit
    exit
    EOF!
    echo 'backup success!'
    [oracle@sta ~]$

  • 相关阅读:
    ICE-3.5.1-错误记录
    windows下qtcreator添加ICE库文件
    LINUX下QT与C语言通过网卡名获取网卡IP与MAC
    Apache部署Django+Vue
    三次握手和四次挥手面试常问
    配置mysql时报错
    nosql的介绍以及和关系型数据库的区别
    redis的基本操作
    在Centos安装redis-孙志奇
    git的使用
  • 原文地址:https://www.cnblogs.com/taosim/p/3962544.html
Copyright © 2020-2023  润新知