[Oracle]檢查impdp的log時忽略常見錯誤

impdp常常出現報錯，但是經常是屬於可忽略的錯誤， 因此增加判斷避免每日都需要去檢查log。 用grep把所有ORA-[五碼數字]的字都抓出來， 然後用For迴圈一個一個比對錯誤碼清單，如果在清單中就found=true，不在清單中就found=false LOGDIR=[log路徑] # 可接受的錯誤碼清單 ACCEPTABLE_ERRORS=( "ORA-31684" # Object already exists "ORA-39151" # Object skipped due to insufficient privileges "ORA-39082" # Created with compilation warnings "ORA-01917" # User does not exist "ORA-01430" # Cannot create object, already exists "ORA-06512" # PL/SQL stack trace (usually not critical) "ORA-00955" # Name is already used by an existing object "ORA-00942" # Table or view does not exist (depends on context) "ORA-39111" # Dependent object skipped due to existing base object ) is_acceptable_error=true # 從 log 中找出所有 ORA 錯誤碼 error_codes=$(grep -o "ORA-[0-9]\{5\}" "${LOGDIR}" | sort | uniq) for code in $error_codes; do found=false for acceptable in "${ACCEPTABLE_ERRORS[@]}"; do if [ "$code" == "$acceptable" ]; then found=true break fi done if [ "$found" = false ]; then is_acceptable_error=false break fi done # 根據錯誤碼與返回碼判斷是否成功 if [ $EXIT_CODE -ne 0 ]; then if [ "$is_acceptable_error" = true ]; then echo "[log]發現僅有可接受錯誤，視為成功。" else echo "[err]發生不可接受錯誤，返回碼 $EXIT_CODE，請檢查 log。" fi fi