#!/bin/sh
PATH=$PATH:$HOME/bin
export PATH
PATH=$PATH:$HOME/bin
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product
export ORACLE_SID=orcl
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export TNS_ADMIN=$ORACLE_HOME/network/admin
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
cd /u01/lvdata/dump/
sqlplus system/SYSSYS@DFNFDB<<EOF
ALTER SYSTEM SET "_SYSTEM_TRIG_ENABLED"=FALSE;
EXIT;
EOF
expdp system/SYSSYS@DFNFDB directory=dfs_kf file=`date +%Y%m%d`_dfi_data.dump log=dfi_data.log owner=dfi_data
expdp system/SYSSYS@DFNFDB directory=dfs_kf file=`date +%Y%m%d`_dfi.dump log=dfi.log owner=dfi
expdp system/SYSSYS@DFNFDB directory=dfs_kf file=`date +%Y%m%d`_dfs_cs.dump log=dfs_cs.log owner=dfs_cs
sqlplus system/SYSSYS@DFNFDB<<EOF
ALTER SYSTEM SET "_SYSTEM_TRIG_ENABLED"=TRUE;
EXIT;
EOF
sqlplus system/SYSSYS@DFI<<EOF
ALTER SYSTEM SET "_SYSTEM_TRIG_ENABLED"=FALSE;
EXIT;
EOF
expdp system/SYSSYS@DFI directory=dfs_if file=`date +%Y%m%d`_dfs_if.dump log=dfs_if.log owner=dfs_if
sqlplus system/SYSSYS@DFI<<EOF
ALTER SYSTEM SET "_SYSTEM_TRIG_ENABLED"=TRUE;
EXIT;
EOF
find -ctime +2|xargs rm -f
|
