expdp 匯出指令碼

#!/usr/bin/bash
#set -x
. /home/oracle/.profile
export L_PRODUCT_PWD=XXX

export L_FILE_DATE=`date +%Y%m%d`
        #**********************************************************************#
        #                                                                      #
        #            define work directory                                     #
        #               L_WORK_DIR_                                            #
        #                          |_bin                                       #
        #                          |_operlog                                   #
        #                                                                      #
        #**********************************************************************#

L_DIR_NAME=`dirname $0`
cd ${L_DIR_NAME}
cd ..
export L_WORK_DIR=$PWD
export L_BIN_DIR=${L_WORK_DIR}/bin
export L_LOG_DIR=${L_WORK_DIR}/operlog

        #************************************************************************#
        #                                                                        #
        #          Begin export product's object except                          #
        #          'USER_STAT_INFO','SMSG_LOGS', 'ATTRS'                         #
        #                                                                        #
        #************************************************************************#
echo "###########################################################"
echo "Begin export product's object: `date +%Y-%m-%d` `date +%T`"
l_scn=`sqlplus -s  '/as sysdba' <          set feedback off
          set pagesize 0
          select to_char(dbms_flashback.get_system_change_number) sys_scn  from dual;
          exit;
          !
        `
echo $l_scn
rm /backup/expdata/*.dmp

expdp product/$L_PRODUCT_PWD  parfile=${L_BIN_DIR}/exp_all_tab.par FLASHBACK_SCN=$l_scn
cat /backup/expdata/exp_all_tab.log>> ${L_LOG_DIR}/dailybackup.log
mv /backup/expdata/exp_all_tab.log ${L_LOG_DIR}/exp_all_tab.log_${L_FILE_DATE}
echo "Finish export product's object: `date +%Y-%m-%d` `date +%T`"
echo "###########################################################"

        #************************************************************************#
        #                                                                        #
        #          Begin export      ATTRS                                       #
        #                                                                        #
        #************************************************************************#
echo "###########################################################"
echo "Begin export ATTRS: `date +%Y-%m-%d` `date +%T`"
       
expdp product/$L_PRODUCT_PWD  parfile=${L_BIN_DIR}/exp_attrs_tab.par
cat /backup/expdata/exp_attrs_tab.log>> ${L_LOG_DIR}/dailybackup.log
mv /backup/expdata/exp_attrs_tab.log ${L_LOG_DIR}/exp_attrs_tab.log_${L_FILE_DATE}

echo "Finish export ATTRS: `date +%Y-%m-%d` `date +%T`"
echo "###########################################################"

        #************************************************************************#
        #                                                                        #
        #          Begin export  USER_STAT_INFO                                  #
        #                                                                        #
        #************************************************************************#
echo "###########################################################"
echo "Begin export USER_STAT_INFO:  `date +%Y-%m-%d` `date +%T`"
expdp product/$L_PRODUCT_PWD  parfile=${L_BIN_DIR}/exp_user_stat_info_tab.par
cat /backup/expdata/exp_user_stat_info_tab.log>> ${L_LOG_DIR}/dailybackup.log
mv /backup/expdata/exp_user_stat_info_tab.log ${L_LOG_DIR}/exp_user_stat_info_tab.log_${L_FILE_DATE}
echo "Finish export USER_STAT_INFO: `date +%Y-%m-%d` `date +%T`"
echo "###########################################################"

        #************************************************************************#
        #                                                                        #
        #          Begin export  SMSG_LOGS                                       #
        #                                                                        #
        #************************************************************************#
echo "###########################################################"
echo "Begin export SMSG_LOGS's METADATA: `date +%Y-%m-%d` `date +%T`"
expdp product/$L_PRODUCT_PWD  parfile=${L_BIN_DIR}/exp_smsg_logs_tab.par
cat /backup/expdata/exp_smsg_logs_tab.log>> ${L_LOG_DIR}/dailybackup.log
mv /backup/expdata/exp_smsg_logs_tab.log ${L_LOG_DIR}/exp_smsg_logs_tab.log_${L_FILE_DATE}
echo "Finish export SMSG_LOGS's METADATA: `date +%Y-%m-%d` `date +%T`"
echo "###########################################################"

echo "###########################################################"
echo "Begin copy dumpfiles to 192.168.3.37: `date +%Y-%m-%d` `date +%T`"
scp /backup/expdata/dailybackup01.dmp oracle@192.168.5.37:/backup/expdata
scp /backup/expdata/dailybackup02.dmp oracle@192.168.5.37:/backup/expdata
scp /backup/expdata/dailybackup03.dmp oracle@192.168.5.37:/backup/expdata
scp /backup/expdata/dailybackup04.dmp oracle@192.168.5.37:/backup/expdata
scp /backup/expdata/dailybackup05.dmp oracle@192.168.5.37:/backup/expdata
scp /backup/expdata/dailybackup06.dmp oracle@192.168.5.37:/backup/expdata
scp /backup/expdata/dailybackup07.dmp oracle@192.168.5.37:/backup/expdata

rm /backup/expdata/*.dmp
echo "Finish copy dumpfiles to 192.168.3.37: `date +%Y-%m-%d` `date +%T`"
echo "###########################################################"

echo "------------------"
echo "expdp end date: `date +%Y-%m-%d` `date +%T`"
scp ${L_LOG_DIR}/dailybackup.log oracle@192.168.5.37:/home/oracle/admin/dailyimp/operlog