Linux下rman备份报错信息
很明显找不到rman这个命令,path上有问题,或者说环境变量的问题
[Oracle@RedHat /]$ mail
Mail version 8.1 6/6/93. Type ? for help.
"/var/spool/mail/oracle": 13 messages 11 new 13 unread
U 1 root@localhost.local Sun May 5 05:50 24/1042 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
U 2 root@localhost.local Sun May 5 05:57 24/1042 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
>N 3 root@localhost.local Sun May 5 06:00 23/1032 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 4 root@localhost.local Sun May 5 06:04 26/1035 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 5 root@localhost.local Sun May 5 06:10 23/1013 "Cron rman target / cmdfile=/oracle/ora10g/rmanbak/"
N 6 root@localhost.local Sun May 5 06:13 26/1035 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 7 root@localhost.local Sun May 5 06:17 24/1130 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 8 root@localhost.local Sun May 5 06:19 23/1032 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 9 root@localhost.local Sun May 5 06:24 29/1423 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 10 root@localhost.local Sun May 5 06:27 24/1139 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 11 root@localhost.local Sun May 5 06:30 26/1035 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 12 root@localhost.local Sun May 5 06:33 26/1035 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 13 root@localhost.local Sun May 5 06:44 26/1035 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
& 12
Message 12:
From oracle@localhost.localdomain Sun May 5 06:33:01 2013
Date: Sun, 5 May 2013 06:33:01 -0400
From: root@localhost.localdomain (Cron Daemon)
To: oracle@localhost.localdomain
Subject: Cron /oracle/ora10g/rmanbak/script/startrman.sh >> /oracle/ora10g/rmanbak/script/crontab.log
Content-Type: text/plain; charset=UTF-8
Auto-Submitted: auto-generated
X-Cron-Env:
X-Cron-Env:
X-Cron-Env:
X-Cron-Env:
X-Cron-Env:
Message file RMAN.msb not found
Verify that ORACLE_HOME is set properly
解决方法:
加上环境变量export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_BASE=/oracle/ora10g
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=wolf
export ORACLE_TERM=xterm
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/usr/x11R6/lib64
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export LD_ASSUME_KERNEL=2.6.18
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.UTF8"
export PATH=/oracle/ora10g/product/10.2.0/db_1/bin:/usr/sbin:/usr/lib/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin
SH_HOME=/oracle/ora10g/rmanbak
然后就成功了