RMAN备份报错Message file RMANlang.msb not found

RMAN备份报错Message file RMANlt;langgt;.msb not found

首页 → 数据库技术

背景：

阅读新闻

RMAN备份报错Message file RMAN.msb not found

[日期：2013-05-06] 来源：Linux社区 作者：yujin2010good [字体：]

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 [e-mail] Sun May 5 05:50 24/1042 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
U 2 [e-mail] Sun May 5 05:57 24/1042 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
>N 3 [e-mail] Sun May 5 06:00 23/1032 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 4 [e-mail] Sun May 5 06:04 26/1035 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 5 [e-mail] Sun May 5 06:10 23/1013 "Cron rman target / cmdfile=/oracle/ora10g/rmanbak/"
N 6 [e-mail] Sun May 5 06:13 26/1035 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 7 [e-mail] Sun May 5 06:17 24/1130 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 8 [e-mail] Sun May 5 06:19 23/1032 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 9 [e-mail] Sun May 5 06:24 29/1423 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 10 [e-mail] Sun May 5 06:27 24/1139 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 11 [e-mail] Sun May 5 06:30 26/1035 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 12 [e-mail] Sun May 5 06:33 26/1035 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
N 13 [e-mail] Sun May 5 06:44 26/1035 "Cron /oracle/ora10g/rmanbak/script/startrman.sh >>"
& 12
Message 12:
From [e-mail] Sun May 5 06:33:01 2013
Date: Sun, 5 May 2013 06:33:01 -0400
From: [e-mail] (Cron Daemon)
To: [e-mail]
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

然后就成功了