#!\/bin\/bash
\n#oracle_backup.sh version1.0 chmod 700
\n#00 00 * * * \/usr\/local\/scripts\/oracle_backup.sh
\n#chmod 700 \/usr\/local\/scripts\/oracle_backup.sh
\n#You must first import the environment variables in the Oracle user’s bash_profile file
\n#Must be used to define the DBA account first dpdata1 path and authorized directory to read and write, modify the dpdata1 group<\/p>\n
export ORACLE_BASE=\/usr\/local\/u01\/oracle
\nexport ORACLE_HOME=\/usr\/local\/u01\/oracle\/product\/11.2.0\/dbhome_1
\nexport ORACLE_SID=oracle11
\nexport LD_LIBRARY_PATH=$ORACLE_HOME\/lib
\nexport PATH=$ORACLE_HOME\/bin:$PATH
\ndatetime=$(date +”%Y%m%d”)
\ndpdata1_dir=”\/data\/backup\/oracle_backup”
\noracle_u01=”u01″
\noracle_u02=”u02″
\noracle_password1=”u01_password”
\noracle_password2=”u02_password”<\/p>\n
expdp ${oracle_u01}\/${oracle_password1} directory=dpdata1 dumpfile=${oracle_u01}_${datetime} logfile=${oracle_u01}_${datetime}.log<\/p>\n
if [ $? -ne 0 ];then
\n echo “$(date +”%Y-%m-%d_%H:%M:%S”)oracle_${oracle_u01}_backup_file!” > ${dpdata1_dir}\/${datetime}_err.log
\nfi<\/p>\n
expdp ${oracle_u02}\/${oracle_password2} directory=dpdata1 dumpfile=${oracle_u02}_${datetime} logfile=${oracle_u02}_${datetime}.log<\/p>\n
if [ $? -ne 0 ];then
\n echo “$(date +”%Y-%m-%d_%H:%M:%S”)oracle_${oracle_u02}_backup_file!” >> ${dpdata1_dir}\/${datetime}_err.log
\nfi<\/p>\n
\/usr\/bin\/bzip2 -z ${dpdata1_dir}\/*${datetime}*
\nfind $dpdata1_dir -type f -ctime +30 -name “*.bz2” -exec rm -vf {} \\;<\/p>\n","protected":false},"excerpt":{"rendered":"
#!\/bin\/bash #oracle_backup.sh version1.0 chmod 700 #00 00 * * * \/usr\/local\/scripts\/oracle_backup.sh #chmod 700 \/usr\/local\/scripts\/oracle_backup.sh #You must first import the environment variables in the Oracle user’s bash_profile file #Must be used to define the DBA account first dpdata1 path and authorized directory to read and write, modify the dpdata1 group<\/p>\n
export ORACLE_BASE=\/usr\/local\/u01\/oracle export ORACLE_HOME=\/usr\/local\/u01\/oracle\/product\/11.2.0\/dbhome_1 export ORACLE_SID=oracle11 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6967"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6967"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6967\/revisions"}],"predecessor-version":[{"id":6968,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6967\/revisions\/6968"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6967"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6967"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}