| 錯誤訊息 | 根因 | 解決方案 |
|---|---|---|
Message file RMAN.msb not found | Cron 環境未載入 Oracle 環境變數 | 在 Shell 腳本開頭 `export ORACLE_HOME=...; export ORACLE_SID=...; export PATH=...` |
standard in must be a tty | Cron 中直接用 `su - oracle -c "cmd"` 或管道 | 將 `su` 移入 Shell 腳本內部,cron 只呼叫該腳本 |
RMAN-00556: could not open CMDFILE "backup.rcv" | RMAN `cmdfile` 參數需**絕對路徑** | 腳本中寫 `cmdfile=/full/path/backup.rcv`,不可用相對路徑或 `./` |
# /etc/cron.d/oracle_backup
# 每日 12:00、18:00 執行歸檔全備
0 12,18 * * * oracle /home/oracle/scripts/backup_arch.sh
#!/bin/bash
# /home/oracle/scripts/backup_arch.sh
export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
export ORACLE_SID=PROD
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
# 呼叫 RMAN 命令檔(絕對路徑!)
$ORACLE_HOME/bin/rman target / cmdfile=/home/oracle/scripts/backup_arch.rcv \
log=/home/oracle/logs/backup_arch_$(date +%F_%H%M).log
-- /home/oracle/scripts/backup_arch.rcv
CONNECT TARGET /
CONNECT CATALOG rman/rman@rcat
RUN {
ALLOCATE CHANNEL d1 DEVICE TYPE DISK;
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
BACKUP ARCHIVELOG ALL DELETE INPUT
FORMAT '/backup/rman/arch_%U' FILESPERSET 3;
RELEASE CHANNEL d1;
}
Oracle 自動備份失敗 90% 因環境變數與路徑問題。採用「Cron 只管排程、Shell 管環境、RCV 管邏輯」三層分離架構,並強制使用絕對路徑,即可徹底消除上述陷阱,實現穩定無人值守備份。