花无涯 2013-05-06
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 [email protected] Sun May 5 05:50 24/1042 "Cron <oracle@redhat> /oracle/ora10g/rmanbak/script/startrman.sh >>"
U 2 [email protected] Sun May 5 05:57 24/1042 "Cron <oracle@redhat> /oracle/ora10g/rmanbak/script/startrman.sh >>"
>N 3 [email protected] Sun May 5 06:00 23/1032 "Cron <oracle@redhat> /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 4 [email protected] Sun May 5 06:04 26/1035 "Cron <oracle@redhat> /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 5 [email protected] Sun May 5 06:10 23/1013 "Cron <oracle@redhat> rman target / cmdfile=/oracle/ora10g/rmanbak/"
N 6 [email protected] Sun May 5 06:13 26/1035 "Cron <oracle@redhat> /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 7 [email protected] Sun May 5 06:17 24/1130 "Cron <oracle@redhat> /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 8 [email protected] Sun May 5 06:19 23/1032 "Cron <oracle@redhat> /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 9 [email protected] Sun May 5 06:24 29/1423 "Cron <oracle@redhat> /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 10 [email protected] Sun May 5 06:27 24/1139 "Cron <oracle@redhat> /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 11 [email protected] Sun May 5 06:30 26/1035 "Cron <oracle@redhat> /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 12 [email protected] Sun May 5 06:33 26/1035 "Cron <oracle@redhat> /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 13 [email protected] Sun May 5 06:44 26/1035 "Cron <oracle@redhat> /oracle/ora10g/rmanbak/script/startrman.sh >>"
& 12
Message 12:
From [email protected] Sun May 5 06:33:01 2013
Date: Sun, 5 May 2013 06:33:01 -0400
From: [email protected] (Cron Daemon)
To: [email protected]
Subject: Cron <oracle@redhat> /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: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/home/oracle>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=oracle>
X-Cron-Env: <USER=oracle>
Message file RMAN<lang>.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
然后就成功了