#!/bin/bash

網(wǎng)站建設(shè)哪家好，找創(chuàng)新互聯(lián)！專注于網(wǎng)頁設(shè)計、網(wǎng)站建設(shè)、微信開發(fā)、小程序開發(fā)、集團(tuán)企業(yè)網(wǎng)站建設(shè)等服務(wù)項目。為回饋新老客戶創(chuàng)新互聯(lián)還提供了綦江免費建站歡迎大家使用！

export ORACLE_HOME=/usr/local/instantclient_11_2
export PATH=$ORACLE_HOME:$PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH
#export NLS_LANG='simplified chinese_china.ZHS16GBK'
export NLS_LANG='simplified chinese_china.AL32UTF8'

d=$(date -d "yesterday" +"%Y%m%d")cDir=/usr/local/instantclient_11_2
fDir=/bakup
_user=hadoop
_passwd=P@ssw0rd
br/>cDir=/usr/local/instantclient_11_2
fDir=/bakup
_user=hadoop
_passwd=P@ssw0rd

/bin/find $fDir/ -mtime +7 -exec /bin/rm -rf {} \; >/dev/null 2>&1

$cDir/exp $_user/$_passwd@$_ip/jssis file=$fDir/$d.dmp log=$fDir/$d.log owner=hadoop

zip -m $fDir/oracle_bak$d.zip $fDir/$d.log $fDir/$d.dmp