导入Dump的批量操作脚本 checkBackUpPath3

revokeRole()
{
    
    writeLog $log_file_name "Starting to execute revoke.sql file..." $log_path    
    sed -i "s#@{ProjectID}#${project}#" $INSTALL_HOME/dbscript/impdp/revoke.sql
    sed -i "s#@{ProjectIDINDEX}#${project}#" $INSTALL_HOME/dbscript/impdp/revoke.sql
    sed -i "s#@{systempassword}#${DB_SYSTEM_password}#" $INSTALL_HOME/dbscript/impdp/revoke.sql
    sed -i "s#@{dbserverip}#${DB_server_ip}#" $INSTALL_HOME/dbscript/impdp/revoke.sql
    sed -i "s#@{listenport}#${DB_listen_port}#" $INSTALL_HOME/dbscript/impdp/revoke.sql
    sed -i "s#@{sid}#${DB_instance}#" $INSTALL_HOME/dbscript/impdp/revoke.sql
    sed -i "s#@{sdm_number}#${sdm_number}#g" $INSTALL_HOME/dbscript/impdp/revoke.sql
    chmod -R 777 $INSTALL_HOME/dbscript/impdp/revoke.sql
    su - oracle -c "export ORACLE_SID=${DB_instance};sqlplus -S /nolog @$INSTALL_HOME/dbscript/impdp/revoke.sql >/opt/oracle/sdm_revoke <<EOF      
    quit;
    EOF"
    
    if [ $Oracle_instance_name != $MOST_instance_name ];then
    sed -i "s#@{sid}#${MOST_instance_name}#" $INSTALL_HOME/dbscript/impdp/revoke.sql
    su - oracle -c "export ORACLE_SID=${MOST_instance_name} ;sqlplus -S /nolog @$INSTALL_HOME/dbscript/impdp/revoke.sql >/opt/oracle/sdm_revoke <<EOF      
    quit;
    EOF"
    fi
    
    
    writeLog $log_file_name "revoke successfully..." $log_path
        
}

revokedumppermission()
{
    
    writeLog $log_file_name "start revoke sdm dump  permission begin..." $log_path    
    su - oracle -c "export ORACLE_SID=${DB_instance} ;sqlplus / as sysdba   >${dump_directory}/revoke_sdm_dump_permission_for_rollback.log  <<END
    start $INSTALL_HOME/dbscript/impdp/revoke_dump.sql;
    exit;
    END"    
    if [ $Oracle_instance_name != $MOST_instance_name ];then
    writeLog $log_file_name "start revoke most dump  permission begin..." $log_path    
    su - oracle -c "export ORACLE_SID=${MOST_instance_name} ;sqlplus / as sysdba   >${dump_directory}/revoke_most_dump_permission_for_rollback.log  <<END
    start $INSTALL_HOME/dbscript/impdp/revoke_dump.sql;
    exit;
    END" 
    fi
  
    writeLog $log_file_name "revoke dump  permission successfully..." $log_path
    
}

updateIP()
{    
    writeLog $log_file_name "Starting to execute update_servicedesk_ip.sql file..." $log_path        
    sed -i "s#@{DB_APP_username}#${DB_APP_username}#" $INSTALL_HOME/dbscript/impdp/update_servicedesk_ip.sql
    sed -i "s#@{DB_APP_password}#${DB_APP_password}#" $INSTALL_HOME/dbscript/impdp/update_servicedesk_ip.sql
    sed -i "s#@{dbserverip}#${DB_server_ip}#" $INSTALL_HOME/dbscript/impdp/update_servicedesk_ip.sql
    sed -i "s#@{listenport}#${DB_listen_port}#" $INSTALL_HOME/dbscript/impdp/update_servicedesk_ip.sql
    sed -i "s#@{sid}#${DB_instance}#" $INSTALL_HOME/dbscript/impdp/update_servicedesk_ip.sql
    sed -i "s#@{OldAppIP}#${APP_IP_OLD}#g" $INSTALL_HOME/dbscript/impdp/update_servicedesk_ip.sql
    sed -i "s#@{NewAppIP}#${APP_IP}#g" $INSTALL_HOME/dbscript/impdp/update_servicedesk_ip.sql
    sed -i "s#@{OldAppClientIP}#${APP_CLIENT_IP_OLD}#g" $INSTALL_HOME/dbscript/impdp/update_servicedesk_ip.sql
    sed -i "s#@{NewAppClientIP}#${APP_CLIENT_IP}#g" $INSTALL_HOME/dbscript/impdp/update_servicedesk_ip.sql
    chmod -R 777 $INSTALL_HOME/dbscript/impdp/update_servicedesk_ip.sql
    
    if [ ! -f ${dump_directory}/update_servicedesk_ip ] ; then
    touch ${dump_directory}/update_servicedesk_ip      
    fi
    chmod -R 777 ${dump_directory}/update_servicedesk_ip
  
    su - oracle -c "sqlplus -S /nolog @$INSTALL_HOME/dbscript/impdp/update_servicedesk_ip.sql >${dump_directory}/update_servicedesk_ip <<EOF      
    quit;
    EOF"    
    writeLog $log_file_name "update_servicedesk_ip successfully..." $log_path    
    
    writeLog $log_file_name "Starting to execute update_message_ip.sql file..." $log_path        
    sed -i "s#@{DB_APP_username}#inoc_sdm_message_1#" $INSTALL_HOME/dbscript/impdp/update_message_ip.sql
    sed -i "s#@{DB_APP_password}#${DB_APP_password}#" $INSTALL_HOME/dbscript/impdp/update_message_ip.sql
    sed -i "s#@{dbserverip}#${DB_server_ip}#" $INSTALL_HOME/dbscript/impdp/update_message_ip.sql
    sed -i "s#@{listenport}#${DB_listen_port}#" $INSTALL_HOME/dbscript/impdp/update_message_ip.sql
    sed -i "s#@{sid}#${DB_instance}#" $INSTALL_HOME/dbscript/impdp/update_message_ip.sql
    sed -i "s#@{OldAppIP}#${APP_IP_OLD}#g" $INSTALL_HOME/dbscript/impdp/update_message_ip.sql
    sed -i "s#@{NewAppIP}#${APP_IP}#g" $INSTALL_HOME/dbscript/impdp/update_message_ip.sql
    chmod -R 777 $INSTALL_HOME/dbscript/impdp/update_message_ip.sql
    if [ ! -f ${dump_directory}/update_message_ip ] ; then
      touch ${dump_directory}/update_message_ip
    fi
    chmod -R 777 ${dump_directory}/update_message_ip
    su - oracle -c "sqlplus -S /nolog @$INSTALL_HOME/dbscript/impdp/update_message_ip.sql >${dump_directory}/update_message_ip <<EOF      
    quit;
    EOF"    
    writeLog $log_file_name "update_message_ip successfully..." $log_path    
 
    if [ ! -d ${dump_directory}/log ];then
    mkdir ${dump_directory}/log
    chmod -R 777 ${dump_directory}/log
    fi
    
    mv ${dump_directory}/*.log -t ${dump_directory}/log
}