导入Dump的批量操作脚本 importDB2

最新推荐文章于 2023-06-01 09:41:46 发布
最新推荐文章于 2023-06-01 09:41:46 发布
阅读量220 收藏
点赞数
分类专栏： SUSE Linux Oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/gufanwd/article/details/103007777
版权

        #依次导入用户数据
        arr_user=(${user_list//,/ })    
        for user_name in ${arr_user[@]}
        do
            sed -i "s#@cur_path#$INSTALL_HOME/dbscript/impdp#g" $INSTALL_HOME/dbscript/impdp/get_fk_disable.sql
            su - oracle -c "sqlplus ${user_name}/${DB_APP_password}@//${DB_server_ip}:${DB_Port}/${DB_instance} @$INSTALL_HOME/dbscript/impdp/get_fk_disable.sql;"            
            while read fk_low_line ; do
            if [ "x${fk_low_line}" != "x" ] ; then
                fk_low=`echo $fk_low_line | grep [a-z] | awk '{print $NF }' `
                if [ "x${fk_low}" != "x" ] ; then
                    fk_low=`echo ${fk_low%;*}`
                    fk_low_replace=\"$fk_low\"
                    sed -i "s#${fk_low}#${fk_low_replace}#g" $INSTALL_HOME/dbscript/impdp/set_fk_disable.sql
                fi
            fi
            done < $INSTALL_HOME/dbscript/impdp/set_fk_disable.sql    
            

            su - oracle -c "sqlplus ${user_name}/${DB_APP_password}@//${DB_server_ip}:${DB_Port}/${DB_instance} <<EOF
            @$INSTALL_HOME/dbscript/impdp/set_fk_disable.sql;
            quit;
            EOF";
            if [ "$user_name" == "inoc_sdm_servicedesk_${sdm_number}" ]
            then
                if [ "$except_flag" == "min" ] ; then
                    
                    su - oracle -c "impdp ${DB_System_username}/${DB_System_password}@//${DB_server_ip}:${DB_Port}/${DB_instance} DIRECTORY=dumpdir parallel=4  ENCRYPTION_PASSWORD=${DB_wallet_password} logfile=impdp_${user_name}_min_exclude.log  DUMPFILE=${user_name}_%u.dump SCHEMAS=$user_name EXCLUDE=TABLE:\"IN\($table_list\)\"  content=data_only;"                    
                    RESULT=`cat ${dump_directory}/impdp_${user_name}_min_exclude.log | grep ERROR | grep -i ORA- | grep -v -E ${except_ora_err}`
                    if [ "$RESULT" ];
                    then
                        writeLog $log_file_name "import ${user_name}.dump Faild, please check impdp_${user_name}_min_exclude.log" $log_path
                        exit 1;
                    fi

                else
                    su - oracle -c "impdp ${DB_System_username}/${DB_System_password}@//${DB_server_ip}:${DB_Port}/${DB_instance} DIRECTORY=dumpdir parallel=4 ENCRYPTION_PASSWORD=${DB_wallet_password} logfile=impdp_${user_name}.log DUMPFILE=${user_name}_%u.dump SCHEMAS=$user_name content=data_only;"
                    RESULT=`cat ${dump_directory}/impdp_${user_name}.log | grep ERROR | grep -i ORA- | grep -v -E ${except_ora_err}`
                    if [ "$RESULT" ];
                    then
                        writeLog $log_file_name "import ${user_name}.dump Faild, please check impdp_${user_name}.log" $log_path
                        exit 1;
                    fi
                fi
            else

                su - oracle -c "impdp ${DB_System_username}/${DB_System_password}@//${DB_server_ip}:${DB_Port}/${DB_instance} DIRECTORY=dumpdir parallel=4  ENCRYPTION_PASSWORD=${DB_wallet_password} logfile=impdp_${user_name}.log DUMPFILE=${user_name}_%u.dump SCHEMAS=$user_name content=data_only;"

                RESULT=`cat ${dump_directory}/impdp_${user_name}.log | grep ERROR | grep -i ORA- | grep -v -E ${except_ora_err}`
                if [ "$RESULT" ];
                then
                    writeLog $log_file_name "import ${user_name}.dump Faild, please check impdp_${user_name}.log" $log_path
                    exit 1;
                fi            
            fi
            
            
            sed -i "s#@cur_path#$INSTALL_HOME/dbscript/impdp#g" $INSTALL_HOME/dbscript/impdp/get_fk_enable.sql
            su - oracle -c "sqlplus ${user_name}/${DB_APP_password}@//${DB_server_ip}:${DB_Port}/${DB_instance} @$INSTALL_HOME/dbscript/impdp/get_fk_enable.sql;"            
            while read fk_low_line ; do
            if [ "x${fk_low_line}" != "x" ] ; then
                fk_low=`echo $fk_low_line | grep [a-z] | awk '{print $NF }' `
                if [ "x${fk_low}" != "x" ] ; then
                    fk_low=`echo ${fk_low%;*}`
                    fk_low_replace=\"$fk_low\"
                    sed -i "s#${fk_low}#${fk_low_replace}#g" $INSTALL_HOME/dbscript/impdp/set_fk_enable.sql
                fi
            fi
            done < $INSTALL_HOME/dbscript/impdp/set_fk_enable.sql    
            
            
            su - oracle -c "sqlplus ${user_name}/${DB_APP_password}@//${DB_server_ip}:${DB_Port}/${DB_instance} <<EOF
            @$INSTALL_HOME/dbscript/impdp/set_fk_enable.sql;
            quit;
            EOF";
        done
        
        #MOSTCMDB用户
        if [ -f ${dump_directory}/full_most.dump ]
        then
            sed -i "s#@cur_path#$INSTALL_HOME/dbscript/impdp#g" $INSTALL_HOME/dbscript/impdp/get_fk_disable.sql
            su - oracle -c "sqlplus mostcmdb_${sdm_number}/${MOSTCMDB_password}@//${DB_server_ip}:${MOST_DB_listen_port}/${MOST_instance_name} @$INSTALL_HOME/dbscript/impdp/get_fk_disable.sql;"
            while read fk_low_line ; do
                if [ "x${fk_low_line}" != "x" ] ; then
                    fk_low=`echo $fk_low_line | grep [a-z] | awk '{print $NF }' `
                    if [ "x${fk_low}" != "x" ] ; then
                        fk_low=`echo ${fk_low%;*}`
                        fk_low_replace=\"$fk_low\"
                        sed -i "s#${fk_low}#${fk_low_replace}#g" $INSTALL_HOME/dbscript/impdp/set_fk_disable.sql
                    fi
                fi
            done < $INSTALL_HOME/dbscript/impdp/set_fk_disable.sql    
            
            su - oracle -c "sqlplus mostcmdb_${sdm_number}/${MOSTCMDB_password}@//${DB_server_ip}:${MOST_DB_listen_port}/${MOST_instance_name} <<EOF
            @$INSTALL_HOME/dbscript/impdp/set_fk_disable.sql;
            quit;
            EOF";
            
            su - oracle -c "impdp ${DB_System_username}/${DB_System_password}@//${DB_server_ip}:${MOST_DB_listen_port}/${MOST_instance_name} DIRECTORY=dumpdir parallel=4  ENCRYPTION_PASSWORD=${DB_wallet_password} logfile=impdp_mostcmdb_${sdm_number}.log DUMPFILE=mostcmdb_${sdm_number}_%u.dump SCHEMAS=mostcmdb_${sdm_number} content=data_only;"
            #TABLE_EXISTS_ACTION=REPLACE; "    
            
            sed -i "s#@cur_path#$INSTALL_HOME/dbscript/impdp#g" $INSTALL_HOME/dbscript/impdp/get_fk_enable.sql
            su - oracle -c "sqlplus mostcmdb_${sdm_number}/${MOSTCMDB_password}@//${DB_server_ip}:${MOST_DB_listen_port}/${MOST_instance_name} @$INSTALL_HOME/dbscript/impdp/get_fk_enable.sql;"
            while read fk_low_line ; do
                if [ "x${fk_low_line}" != "x" ] ; then
                    fk_low=`echo $fk_low_line | grep [a-z] | awk '{print $NF }' `
                    if [ "x${fk_low}" != "x" ] ; then
                        fk_low=`echo ${fk_low%;*}`
                        fk_low_replace=\"$fk_low\"
                        sed -i "s#${fk_low}#${fk_low_replace}#g" $INSTALL_HOME/dbscript/impdp/set_fk_enable.sql
                    fi
                fi
            done < $INSTALL_HOME/dbscript/impdp/set_fk_enable.sql    
            su - oracle -c "sqlplus mostcmdb_${sdm_number}/${MOSTCMDB_password}@//${DB_server_ip}:${MOST_DB_listen_port}/${MOST_instance_name} <<EOF
            @$INSTALL_HOME/dbscript/impdp/set_fk_enable.sql;
            quit;
            EOF";
            RESULT=`cat ${dump_directory}/impdp_mostcmdb_${sdm_number}.log | grep ERROR | grep -i ORA- | grep -v -E ${except_ora_err}`
            if [ "$RESULT" ];
            then
                writeLog $log_file_name "import mostcmdb_${sdm_number}.dump Faild, please check impdp_mostcmdb_${sdm_number}.log" $log_path
                exit 1;
            fi
        fi    
        
    else
        #mv ${DBBACKUP_DIR}/* /opt/oracle/autobackup_20150210103527/
        sed -i "s/@{ProjectID}/${project}/g" $INSTALL_HOME/dbscript/impdp/createUser_archive.sql
        sed -i "s#@{systempassword}#${DB_SYSTEM_password}#g" $INSTALL_HOME/dbscript/impdp/createUser_archive.sql
        sed -i "s#@{dbserverip}#${DB_server_ip}#g" $INSTALL_HOME/dbscript/impdp/createUser_archive.sql
        sed -i "s#@{listenport}#${DB_listen_port}#g" $INSTALL_HOME/dbscript/impdp/createUser_archive.sql
        sed -i "s#@{SDMUserName}#${DB_APP_username}#g" $INSTALL_HOME/dbscript/impdp/createUser_archive.sql
        sed -i "s#@{DBUSERSDMPASSWORD}#${DB_APP_password}#g" $INSTALL_HOME/dbscript/impdp/createUser_archive.sql
        sed -i "s#@{sdm_number}#${sdm_number}#g" $INSTALL_HOME/dbscript/impdp/createUser_archive.sql
        echo "------------"
        echo "sdm_number is $sdm_number......"
        echo "------------"
        chmod -R 777 $INSTALL_HOME/dbscript/impdp/createUser_archive.sql    
        
        sed -i "s/@{ProjectID}/${project}/g" $INSTALL_HOME/dbscript/impdp/createUser_servicedesk.sql
        sed -i "s#@{systempassword}#${DB_SYSTEM_password}#g" $INSTALL_HOME/dbscript/impdp/createUser_servicedesk.sql
        sed -i "s#@{dbserverip}#${DB_server_ip}#g" $INSTALL_HOME/dbscript/impdp/createUser_servicedesk.sql
        sed -i "s#@{listenport}#${DB_listen_port}#g" $INSTALL_HOME/dbscript/impdp/createUser_servicedesk.sql
        sed -i "s#@{SDMUserName}#${DB_APP_username}#g" $INSTALL_HOME/dbscript/impdp/createUser_servicedesk.sql
        sed -i "s#@{DBUSERSDMPASSWORD}#${DB_APP_password}#g" $INSTALL_HOME/dbscript/impdp/createUser_servicedesk.sql
        sed -i "s#@{sdm_number}#${sdm_number}#g" $INSTALL_HOME/dbscript/impdp/createUser_servicedesk.sql
        chmod -R 777 $INSTALL_HOME/dbscript/impdp/createUser_servicedesk.sql
        
        sed -i "s/@{ProjectID}/${project}/g" $INSTALL_HOME/dbscript/impdp/createUser_message.sql
        sed -i "s#@{systempassword}#${DB_SYSTEM_password}#g" $INSTALL_HOME/dbscript/impdp/createUser_message.sql
        sed -i "s#@{dbserverip}#${DB_server_ip}#g" $INSTALL_HOME/dbscript/impdp/createUser_message.sql
        sed -i "s#@{listenport}#${DB_listen_port}#g" $INSTALL_HOME/dbscript/impdp/createUser_message.sql
        sed -i "s#@{SDMUserName}#${DB_APP_username}#g" $INSTALL_HOME/dbscript/impdp/createUser_message.sql
        sed -i "s#@{DBUSERSDMPASSWORD}#${DB_APP_password}#g" $INSTALL_HOME/dbscript/impdp/createUser_message.sql
        sed -i "s#@{sdm_number}#${sdm_number}#g" $INSTALL_HOME/dbscript/impdp/createUser_message.sql
        chmod -R 777 $INSTALL_HOME/dbscript/impdp/createUser_message.sql
        
        sed -i "s/@{ProjectID}/${project}/g" $INSTALL_HOME/dbscript/impdp/createUser_studio.sql
        sed -i "s#@{systempassword}#${DB_SYSTEM_password}#g" $INSTALL_HOME/dbscript/impdp/createUser_studio.sql
        sed -i "s#@{dbserverip}#${DB_server_ip}#g" $INSTALL_HOME/dbscript/impdp/createUser_studio.sql
        sed -i "s#@{listenport}#${DB_listen_port}#g" $INSTALL_HOME/dbscript/impdp/createUser_studio.sql
        sed -i "s#@{SDMUserName}#${DB_APP_username}#g" $INSTALL_HOME/dbscript/impdp/createUser_studio.sql
        sed -i "s#@{DBUSERSDMPASSWORD}#${DB_APP_password}#g" $INSTALL_HOME/dbscript/impdp/createUser_studio.sql
        sed -i "s#@{sdm_number}#${sdm_number}#g" $INSTALL_HOME/dbscript/impdp/createUser_studio.sql
        chmod -R 777 $INSTALL_HOME/dbscript/impdp/createUser_studio.sql
        
        sed -i "s/@{ProjectID}/${project}/g" $INSTALL_HOME/dbscript/impdp/createUser_si.sql
        sed -i "s#@{systempassword}#${DB_SYSTEM_password}#g" $INSTALL_HOME/dbscript/impdp/createUser_si.sql
        sed -i "s#@{dbserverip}#${DB_server_ip}#g" $INSTALL_HOME/dbscript/impdp/createUser_si.sql
        sed -i "s#@{listenport}#${DB_listen_port}#g" $INSTALL_HOME/dbscript/impdp/createUser_si.sql
        sed -i "s#@{SDMUserName}#${DB_APP_username}#g" $INSTALL_HOME/dbscript/impdp/createUser_si.sql
        sed -i "s#@{DBUSERSDMPASSWORD}#${DB_APP_password}#g" $INSTALL_HOME/dbscript/impdp/createUser_si.sql
        sed -i "s#@{sdm_number}#${sdm_number}#g" $INSTALL_HOME/dbscript/impdp/createUser_si.sql
        chmod -R 777 $INSTALL_HOME/dbscript/impdp/createUser_si.sql
        
        sed -i "s/@{ProjectID}/${project}/g" $INSTALL_HOME/dbscript/impdp/createUser_mostcbb.sql
        sed -i "s#@{systempassword}#${DB_SYSTEM_password}#g" $INSTALL_HOME/dbscript/impdp/createUser_mostcbb.sql
        sed -i "s#@{dbserverip}#${DB_server_ip}#g" $INSTALL_HOME/dbscript/impdp/createUser_mostcbb.sql
        sed -i "s#@{listenport}#${DB_listen_port}#g" $INSTALL_HOME/dbscript/impdp/createUser_mostcbb.sql
        sed -i "s#@{SDMUserName}#${DB_APP_username}#g" $INSTALL_HOME/dbscript/impdp/createUser_mostcbb.sql
        sed -i "s#@{DBUSERSDMPASSWORD}#${DB_APP_password}#g" $INSTALL_HOME/dbscript/impdp/createUser_mostcbb.sql
        sed -i "s#@{sdm_number}#${sdm_number}#g" $INSTALL_HOME/dbscript/impdp/createUser_mostcbb.sql
        chmod -R 777 $INSTALL_HOME/dbscript/impdp/createUser_mostcbb.sql
        
        #add mostcmdb by gufan
        sed -i "s/@{ProjectID}/${project}/g" $INSTALL_HOME/dbscript/impdp/createUser_mostcmdb.sql
        sed -i "s#@{systempassword}#${DB_SYSTEM_password}#g" $INSTALL_HOME/dbscript/impdp/createUser_mostcmdb.sql
        sed -i "s#@{dbserverip}#${DB_server_ip}#g" $INSTALL_HOME/dbscript/impdp/createUser_mostcmdb.sql
        sed -i "s#@{listenport}#${DB_listen_port}#g" $INSTALL_HOME/dbscript/impdp/createUser_mostcmdb.sql
        sed -i "s#@{SDMUserName}#${DB_APP_username}#g" $INSTALL_HOME/dbscript/impdp/createUser_mostcmdb.sql
        sed -i "s#@{DBUSERSDMPASSWORD}#${DB_APP_password}#g" $INSTALL_HOME/dbscript/impdp/createUser_mostcmdb.sql
        sed -i "s#@{sdm_number}#${sdm_number}#g" $INSTALL_HOME/dbscript/impdp/createUser_mostcmdb.sql
        chmod -R 777 $INSTALL_HOME/dbscript/impdp/createUser_mostcmdb.sql
        #end add mostcmdb by gufan
        
        chmod -R 777 $INSTALL_HOME/dbscript/impdp/grant_archive.sql
        chmod -R 777 $INSTALL_HOME/dbscript/impdp/grant_mostcbb.sql
        chmod -R 777 $INSTALL_HOME/dbscript/impdp/grant_servicedesk.sql
        echo "------------"
        echo "sdm_number is $sdm_number......"
        echo "------------"
        sed -i "s#@{sdm_number}#${sdm_number}#g" $INSTALL_HOME/dbscript/impdp/grant_archive.sql
        sed -i "s#@{sdm_number}#${sdm_number}#g" $INSTALL_HOME/dbscript/impdp/grant_mostcbb.sql
        sed -i "s#@{sdm_number}#${sdm_number}#g" $INSTALL_HOME/dbscript/impdp/grant_servicedesk.sql
        
        writeLog $log_file_name "DB_instance is ${DB_instance}......" $log_path    
        
        sed -i "s#@{DB_instance}#${DB_instance}#g" $INSTALL_HOME/dbscript/impdp/createTableSpace_inoc.sql
        sed -i "s#@{inoc_number}#${sdm_number}#g" $INSTALL_HOME/dbscript/impdp/createTableSpace_inoc.sql
        
        su - oracle -c "export ORACLE_SID=${DB_instance} ; sqlplus / as sysdba  <<END
        start $INSTALL_HOME/dbscript/impdp/createTableSpace_inoc.sql
        exit;
        END"
        sleep 20s
        
        #begin create mostcbb user and import dump and grant mostcbb
        writeLog $log_file_name "Starting to importdata ...inoc_sdm_mostcbb_${sdm_number}" $log_path
        su - oracle -c "export ORACLE_SID=${DB_instance} ; sqlplus / as sysdba  <<END
        start $INSTALL_HOME/dbscript/impdp/createUser_mostcbb.sql
        exit;
        END"
        sleep 20s
    
        su - oracle -c "impdp inoc_sdm_mostcbb_${sdm_number}/${DB_APP_password}@//${DB_server_ip}:${DB_listen_port}/${DB_instance} DIRECTORY=dumpdir DUMPFILE=inoc_sdm_mostcbb_${sdm_number}.dump LOGFILE=import_inoc_sdm_mostcbb_${sdm_number}.log  parallel=4 ENCRYPTION_PASSWORD=${DB_wallet_password} TABLE_EXISTS_ACTION=REPLACE"
        RESULT=`cat ${dump_directory}/import_inoc_sdm_mostcbb_${sdm_number}.log | grep ERROR | grep -i ORA- | grep -v -E ${except_ora_err}`
        if [ "$RESULT" ];
        then
            writeLog $log_file_name "import inoc_sdm_mostcbb_${sdm_number}.dump Faild, please check import_mostcbb" $log_path
            exit 1;
        fi
    
        su - oracle -c "export ORACLE_SID=${DB_instance} ; sqlplus / as sysdba  <<END
        start $INSTALL_HOME/dbscript/impdp/grant_mostcbb.sql
        exit;
        END"    
        writeLog $log_file_name "end to importdata ...inoc_sdm_mostcbb_${sdm_number}" $log_path
        #end create mostcbb user and import dump and grant mostcbb    
    
    
    
        #begin create archive user and import dump and grant archive    
        writeLog $log_file_name  "Starting to importdata ...inoc_sdm_archive_${sdm_number}" $log_path    
        su - oracle -c "export ORACLE_SID=${DB_instance} ; sqlplus / as sysdba  <<END
        start $INSTALL_HOME/dbscript/impdp/createUser_archive.sql
        exit;
        END"
        sleep 20s
 
        su - oracle -c "impdp inoc_sdm_archive_${sdm_number}/${DB_APP_password}@//${DB_server_ip}:${DB_listen_port}/${DB_instance} DIRECTORY=dumpdir DUMPFILE=inoc_sdm_archive_${sdm_number}.dump LOGFILE=import_inoc_sdm_archive_${sdm_number}.log parallel=4 ENCRYPTION_PASSWORD=${DB_wallet_password} TABLE_EXISTS_ACTION=REPLACE"
        RESULT=`cat ${dump_directory}/import_inoc_sdm_archive_${sdm_number}.log | grep ERROR | grep -i ORA- | grep -v -E ${except_ora_err}`
        if [ "$RESULT" ];
        then
            writeLog $log_file_name  "import inoc_sdm_archive_${sdm_number}.dump Faild, please check import_inoc_sdm_archive_${sdm_number}.log" $log_path
            exit 1;
        fi
    
        su - oracle -c "export ORACLE_SID=${DB_instance} ; sqlplus / as sysdba  <<END
        start $INSTALL_HOME/dbscript/impdp/grant_archive.sql
        exit;
        END"
        writeLog $log_file_name  "end to importdata ...inoc_sdm_archive_${sdm_number}" $log_path
        #end create archive user and import dump and grant archive

    
    
        #begin create servicedesk user and import dump and grant servicedesk
        writeLog $log_file_name "Starting to importdata ...inoc_sdm_servicedesk_${sdm_number}"  $log_path
        su - oracle -c "export ORACLE_SID=${DB_instance} ; sqlplus / as sysdba  <<END
        start $INSTALL_HOME/dbscript/impdp/createUser_servicedesk.sql
        exit;
        END"
        sleep 20s        
        
        if [ "$except_flag" == "min" ] ; then
            su - oracle -c "impdp inoc_sdm_servicedesk_${sdm_number}/${DB_APP_password}@//${DB_server_ip}:${DB_listen_port}/${DB_instance} DIRECTORY=dumpdir DUMPFILE=inoc_sdm_servicedesk_${sdm_number}.dump LOGFILE=import_inoc_sdm_servicedesk_${sdm_number}_exclude.log  EXCLUDE=TABLE:\"IN\($table_list\)\" parallel=4 ENCRYPTION_PASSWORD=${DB_wallet_password} TABLE_EXISTS_ACTION=REPLACE "    
            su - oracle -c "impdp inoc_sdm_servicedesk_${sdm_number}/${DB_APP_password}@//${DB_server_ip}:${DB_listen_port}/${DB_instance} DIRECTORY=dumpdir DUMPFILE=inoc_sdm_servicedesk_${sdm_number}.dump LOGFILE=import_inoc_sdm_servicedesk_${sdm_number}_include.log  INCLUDE=TABLE:\"IN\($table_list\)\" parallel=4 ENCRYPTION_PASSWORD=${DB_wallet_password} TABLE_EXISTS_ACTION=REPLACE rows=n"
        else
            su - oracle -c "impdp inoc_sdm_servicedesk_${sdm_number}/${DB_APP_password}@//${DB_server_ip}:${DB_listen_port}/${DB_instance} DIRECTORY=dumpdir DUMPFILE=inoc_sdm_servicedesk_${sdm_number}.dump LOGFILE=import_inoc_sdm_servicedesk_${sdm_number}.log  parallel=4 ENCRYPTION_PASSWORD=${DB_wallet_password} TABLE_EXISTS_ACTION=REPLACE "    
        fi
        
        su - oracle -c "export ORACLE_SID=${DB_instance} ; sqlplus / as sysdba  <<END
        start $INSTALL_HOME/dbscript/impdp/grant_servicedesk.sql
        exit;
        END"
        writeLog $log_file_name "end to importdata ...inoc_sdm_servicedesk_${sdm_number}" $log_path
        #end create servicedesk user and import dump and grant servicedesk

    
    
        #begin create message user and import dump and grant message    
        writeLog $log_file_name "Starting to importdata ...inoc_sdm_message_${sdm_number}" $log_path
        su - oracle -c "export ORACLE_SID=${DB_instance} ; sqlplus / as sysdba  <<END
        start $INSTALL_HOME/dbscript/impdp/createUser_message.sql
        exit;
        END"
        sleep 20s
  
        su - oracle -c "impdp inoc_sdm_message_${sdm_number}/${DB_APP_password}@//${DB_server_ip}:${DB_listen_port}/${DB_instance} DIRECTORY=dumpdir DUMPFILE=noc_sdm_message_${sdm_number}.dump LOGFILE=import_noc_sdm_message_${sdm_number}.log parallel=4 ENCRYPTION_PASSWORD=${DB_wallet_password} EXCLUDE=STATISTICS TABLE_EXISTS_ACTION=REPLACE "
        RESULT=`cat ${dump_directory}/import_noc_sdm_message_${sdm_number}.log | grep ERROR | grep -i ORA- | grep -v -E ${except_ora_err}`
        if [ "$RESULT" ];
        then
            writeLog $log_file_name "import noc_sdm_message_${sdm_number}.dump Faild, please check import_noc_sdm_message_${sdm_number}" $log_path
            exit 1;
        fi
        writeLog $log_file_name "end to importdata ...inoc_sdm_message_${sdm_number}" $log_path
        #end create message user and import dump and grant message


    
        #begin create studio user and import dump and grant studio
        writeLog $log_file_name "Starting to importdata ...inoc_sdm_studio_${sdm_number}" $log_path
        su - oracle -c "export ORACLE_SID=${DB_instance} ; sqlplus / as sysdba  <<END
        start $INSTALL_HOME/dbscript/impdp/createUser_studio.sql
        exit;
        END"
        sleep 20s
  
        su - oracle -c "impdp inoc_sdm_studio_${sdm_number}/${DB_APP_password}@//${DB_server_ip}:${DB_listen_port}/${DB_instance} DIRECTORY=dumpdir DUMPFILE=inoc_sdm_studio_${sdm_number}.dump LOGFILE=import_inoc_sdm_studio_${sdm_number}.log parallel=4 ENCRYPTION_PASSWORD=${DB_wallet_password} EXCLUDE=STATISTICS TABLE_EXISTS_ACTION=REPLACE "
        RESULT=`cat ${dump_directory}/import_inoc_sdm_studio_${sdm_number}.log | grep ERROR | grep -i ORA- | grep -v -E ${except_ora_err}`
        if [ "$RESULT" ];
        then
            writeLog $log_file_name "import inoc_sdm_studio_${sdm_number}.dump Faild, please check import_inoc_sdm_studio_${sdm_number}" $log_path
            exit 1;
        fi
        writeLog $log_file_name "end to importdata ...inoc_sdm_studio_${sdm_number}" $log_path
        #end create studio user and import dump and grant studio    
    
    
    
        #begin create si user and import dump and grant si
        writeLog $log_file_name "Starting to importdata ...inoc_sdm_si_${sdm_number}" $log_path
        su - oracle -c "export ORACLE_SID=${DB_instance} ; sqlplus / as sysdba  <<END
        start $INSTALL_HOME/dbscript/impdp/createUser_si.sql
        exit;
        END"
        sleep 20s
  
        su - oracle -c "impdp inoc_sdm_si_${sdm_number}/${DB_APP_password}@//${DB_server_ip}:${DB_listen_port}/${DB_instance} DIRECTORY=dumpdir DUMPFILE=inoc_sdm_si_${sdm_number}.dump LOGFILE=import_inoc_sdm_si_${sdm_number}.log parallel=4 ENCRYPTION_PASSWORD=${DB_wallet_password} TABLE_EXISTS_ACTION=REPLACE "
        RESULT=`cat ${dump_directory}/import_inoc_sdm_si_${sdm_number}.log | grep ERROR | grep -i ORA- | grep -v -E ${except_ora_err}`
        if [ "$RESULT" ];
        then
            writeLog $log_file_name "import inoc_sdm_si_${sdm_number}.dump Faild, please check import_inoc_sdm_si_${sdm_number}" $log_path
            exit 1;
        fi
        writeLog $log_file_name  "end to importdata ...inoc_sdm_si_${sdm_number}" $log_path
        #end create si user and import dump and grant si
        
        
        
        #begin create mostcmdb user and import dump and grant mostcmdb
        writeLog $log_file_name "Starting to importdata ...mostcmdb_${sdm_number}" $log_path
        su - oracle -c "export ORACLE_SID=${MOST_instance_name} ; sqlplus / as sysdba  <<END
        start $INSTALL_HOME/dbscript/impdp/createUser_mostcmdb.sql
        exit;
        END"
        sleep 20s
      
        su - oracle -c "impdp system/iNOC_oper_001@//${DB_server_ip}:${MOST_DB_listen_port}/${MOST_instance_name} DIRECTORY=dumpdir DUMPFILE=mostcmdb_${sdm_number}.dump LOGFILE=import_mostcmdb_${sdm_number}.log parallel=4 ENCRYPTION_PASSWORD=${DB_wallet_password} TABLE_EXISTS_ACTION=REPLACE "
        RESULT=`cat ${dump_directory}/import_mostcmdb_${sdm_number}.log | grep ERROR | grep -i ORA- | grep -v -E ${except_ora_err}`
        if [ "$RESULT" ];
        then
            writeLog $log_file_name "import mostcmdb_${sdm_number}.dump Faild, please check import_mostcmdb_${sdm_number}" $log_path
            exit 1;
        fi
        writeLog $log_file_name  "end to importdata ...mostcmdb_${sdm_number}" $log_path
        #end create mostcmdb user and import dump and grant mostcmdb    
    fi
     
    #add sequence for all user schema    
    sh $current_path/db_modify_sequence.sh ${sdm_number}
    
    
     #mv /opt/oracle/autobackup_20150210103527/* ${DBBACKUP_DIR}/
    writeLog $log_file_name "import all dump successfully..." $log_path
}

gufanwd
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
导入Dump的批量操作脚本 importDB
gufanwd的博客
11-11 306
#删除用户然后重新建用户再导入dump数据 importDB() { arr_sys_user=(${sys_user_list//,/ }) sys_schemalist=""; for sys_user_name in ${arr_sys_user[@]} do if [ "x${sys_user_name}" != "x" ] ; then ...
导入Dump的批量操作脚本 checkBackUpPath
gufanwd的博客
11-11 140
#数据库目录 DBBACKUP_DIR=$backupDB_SDM_dir #DBBACKUP_DIR="/opt/oracle/C20_spcbackup_20150210103527" #Recover_date_DB format: YYYY-MM-DD 2018-04-16 #Recover_date_DB=`date +%Y-%m-%d` #Recover_date_DB='2018-...
linux dump命令 异机,linux之间实现db2异机备份还原总结
weixin_36130575的博客
04-28 174
数据库备份还原测试：思路：将数据库服务器(32.74.4.125)中数据库(bras)备份到归档服务器(32.74.4.123)上--说明：准确的说是备份到挂载在归档服务器(32.74.4.123)上的归档设备上，归档设备的挂载点为/mnt/efile步骤：一. 实现共享服务由于数据库服务器和归档服务器都是linux系统故而使用nfs共享将归档服务器当作nfs共享服务器端(server)，数据库服...
DB2中的数据移动
Annebabyli的专栏
07-03 1031
DB2中所谓的数据移动，包括： 1. 数据的导入（Import） 2. 数据的导出（Export） 3. 数据的装入（Load） 导入和装入都是利用DB2的相关命令把某种格式的文件中的数据保存到数据库中的表中 导出是指把DB2数据库的表中的数据保存到某种格式的文件当中去 数据移动的作用： 如果要在不同的数据库管理系统之间转移数据，数据移动通常是最实用的一种方法，因为任何一种数据库管理系统都支持
DB2 中的文件
05-18 1771
DB2中的文件 很多刚刚接触 DB2 的朋友，可能会发现 DB2 中有着形形色色的文件，但并不了解这些文件所起的作用。本文将对 DB2 中的重要的文件进行介绍。这些文件有些用于数据的存储，有
Google Breakpad的dump自动解析脚本
08-12
使用Google Breakpad产生异常dump文件后通常需要敲一堆命令，然后产生你要找的堆栈信息，这里提供的脚本直接运行如下命令crash.sh ./luncher /tmp/d23f8d5e-5832-45ac-da9a718d-7d847b15.dmp ，即可自动产生/tmp/d23...
Android设备挂机dump日志抓取脚本bat
10-12
使用bat脚本编写，简单，点击就能用 不要安装各种软件环境
docker实现elasticsearch批量dump导出导入
01-16
docker实现elasticsearch批量dump导出导入，实现es批量导入导出
抓dump批处理脚本
10-26
它允许用户通过编写一系列命令，实现批量执行任务，比如在本例中的"CatchIt.bat"，可能包含了启动调试器、设置捕获参数、保存dump文件等一系列操作。批处理脚本的使用可以大大简化手动操作的复杂性，提高工作效率。 ...
读取LAMMPS dump文件的matlab脚本
05-19
采用lammps进行分子动力学计算，dump出文件中进行后处理，首先需要读取信息，代码可实现读取全部帧的dump文件，形成三维矩阵，文件中有详细说明
DB2数据库操作与调优笔记
william823的专栏
06-01 1552
Ø xx稳定压测中出现报错: Error: ('57011', -289, '[IBM][CLI Driver][DB2/AIX64] SQL0289N Unable to allocate new pages in table space "AFA_IDX_UDF". SQLSTATE=57011\n')表明AFA_IDX_UDF表空间已满，此时需要使用du -sm home/db2inst1/ecity命令查看当前表空间的大小。即使用./ipclean命令来清理IPC(进程间通讯)资源。
DB2故障诊断工具
cuigaijiao2361的博客
12-11 689
一、db2cklog 使用db2cklog工具来检查归档日志文件。 检查归档日志文件可确保需要前滚恢复时已知正常的日志文件可用，并且恢复操作不会因为日志文件存在问题而失败。 db2cklog工具读取单个日志文件或一定范围的...
DB2数据库的备份和恢复（转）
cuankuangzhong6373的博客
05-23 382
最近，我恢复了一个数据库.其中的辛苦不予言表，我想写出自己用到的一些语句，和遇到相同问题的xdjm共勉。 首先谈db2数据库的备份，我用的是backup命令。 db2 backup database 数据库名（我的库是jsdb）...
db2 启动日志 SQL5043N
jesseen的专栏
05-25 4984
2013-05-22-19.32.35.666037-240 I576123G301        LEVEL: Event PID     : 4267                 TID  : 2256000     PROC : db2start INSTANCE: db2inst1             NODE : 000 FUNCTION: DB2 UDB, base sy
DB2文件系统已满的解决方法
shenghuiping2001的专栏
09-05 9492
DB2文件系统已满的解决方法.
【DB.Oracle】export/import dmp 文件
王晓斌的专栏
10-29 3453
java.lang.Class 对象 getdeclaredfileds(), 对每个filed，获取annotation
DB2常用命令(一)
l-jobs的专栏
08-21 1759
大版本升级命令： db2iupgrade $DB2DIR/instance/db2iupgrade InstName 安装： tar -xzvf file.tar.gz cd server_t ./db2_inistall SERVER purescale选NO 添加用户： groupadd -g 10000 db2igrp grouped -g 10001 db2fgrp ...
mysql 导入dump文件
最新发布
06-11
您可以使用以下命令导入 MySQL dump 文件： ``` mysql -u username -p database_name < dump_file.sql ``` 其中，`username` 是您的 MySQL 用户名，`database_name` 是您要导入到的数据库的名称，`dump_file.sql` ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值