修改ORACLE_SID后，无法使用rman

toddhai

系统：redhat5.6
数据库：oracle 10.2.0.1.0

现在我需要执行一个rman备份脚本（rman.sh）。
脚本中需要执行一个环境变量定义脚本（PROD_ebs.env）
但是执行rman.sh后，出现报错信息如下：

Message file RMAN<lang>.msb not found

Verify that ORACLE_HOME is set properly

我以Message file RMAN<lang>.msb not found为关键词上网查询了一下这个报错信息，有人说因为找不到rman这个命令。我接着执行rman target /
结果rman真的不能执行了，报错信息如上。

稍后，我会在二楼贴上rman.sh 和PROD_ebs.env 以及未执行rman.sh之前的环境变量，希望大牛们指点迷津(如能推荐几篇相关文章就更好了 )

toddhai

这是rman.sh内容
#!/bin/bash
. /oracle/u01/db/tech_st/11.1.0/PROD_ebs.env
BACKUP_LEVEL=0
BACKUP_BASE=/oracle/backup/$ORACLE_SID/rman
LOG_FILE=$BACKUP_BASE/log/Level_$BACKUP_LEVEL_`date +%Y%m%d.`log
DATA_BACK_PATH=$BACKUP_BASE/`date +%Y%m`/datafile
ARCHLOG_BACK_PATH=$BACKUP_BASE/`date +%Y%m`/archivelog
CTL_BACK_PATH=$BACKUP_BASE/`date +%Y%m`/controlfile
PFILE_PATH=$BACKUP_BASE/`date +%Y%m`/pfile
mkdir -p $BACKUP_BASE/log
date >> $LOG_FILE
mkdir -p $PFILE_PATH >> $LOG_FILE
mkdir -p $DATA_BACK_PATH >> $LOG_FILE
mkdir -p $ARCHLOG_BACK_PATH  >> $LOG_FILE
mkdir -p $CTL_BACK_PATH >> $LOG_FILE
rman  target / >> $LOG_FILE <<EOF
run {
CONFIGURE MAXSETSIZE TO UNLIMITED;
configure retention policy to recovery window of 90 days;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '$CTL_BACK_PATH/%d_LVL`echo $BACKUP_LEVEL`_%F.ctl';
allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;
allocate channel d4 type disk;
backup incremental level $BACKUP_LEVEL format '$DATA_BACK_PATH/%d_LVL`echo $BACKUP_LEVEL`_%T_%u_s%s_p%p.dbf' database tag='level $BACKUP_LEVEL' include current controlfile;
sql 'alter system archive log current';
backup archivelog all format '$ARCHLOG_BACK_PATH/%d_AL_%T_%u_s%s_p%p.arh' delete input;
crosscheck backup;
delete noprompt obsolete;
delete noprompt expired backup;
release channel d1;
release channel d2;
release channel d3;
release channel d4;
}
exit
EOF
if [ -f $ORACLE_HOME/dbs/init$ORACLE_SID.ora ]; then
cp $ORACLE_HOME/dbs/init$ORACLE_SID.ora $PFILE_PATH/init$ORACLE_SID.ora.`date +%Y%m%d%H%M` >> $LOG_FILE
else
        echo "file `echo $ORACLE_HOME/dbs/init$ORACLE_SID.ora` not exist" >> $LOG_FILE
fi

if [ -f $ORACLE_HOME/dbs/spfile$ORACLE_SID.ora ]; then
  cp $ORACLE_HOME/dbs/spfile$ORACLE_SID.ora $PFILE_PATH/spfile$ORACLE_SID.ora.`date +%Y%m%d%H%M` >> $LOG_FILE
else
        echo "file `echo $ORACLE_HOME/dbs/spfile$ORACLE_SID.ora` not exist" >> $LOG_FILE
fi
date  >> $LOG_FILE

toddhai

这是PROD_ebs.env内容
#!/bin/sh
# $Header: ad8idbux.env 120.8 2008/03/27 08:44:13 sbandla ship $
# =============================================================================
# NAME
#    PROD.env
#
# DESCRIPTION
#    Setup environment for Oracle
#
# NOTES
#
# HISTORY
#    Created by AutoConfig
# =============================================================================
#
# ###############################################################
#
# This file is automatically generated by AutoConfig.  It will be read and
# overwritten.  If you were instructed to edit this file, or if you are not
# able to use the settings created by AutoConfig, refer to Metalink Note
# 387859.1 for assistance.
#
# ###############################################################

#

######################################
# Unset all the variables NOT required
######################################

unset TWO_TASK

unset ORA_NLS33

unset USERPATH

#####################################
# Source the custom file if it exists
#####################################

customfile=/oracle/u01/db/tech_st/11.1.0/customPROD_ebs.env
if [  -f $customfile ]; then
. /oracle/u01/db/tech_st/11.1.0/customPROD_ebs.env
fi

############################
# Set the variables required
############################

ORACLE_HOME="/oracle/u01/db/tech_st/11.1.0"
export ORACLE_HOME

ORACLE_SID="ROD"
export ORACLE_SID

ORA_NLS10="/oracle/u01/db/tech_st/11.1.0/nls/data/9idata"
export ORA_NLS10

PATH="/oracle/u01/db/tech_st/11.1.0/bin:/usr/bin:/usr/sbin:/oracle/u01/db/tech_st/11.1.0/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/binPATH:."
export PATH

LINK_CNTRL=""
export LINK_CNTRL

TNS_ADMIN="/oracle/u01/db/tech_st/11.1.0/network/admin/PROD_ebs"
export TNS_ADMIN

if test "LINUX_X86-64" = "IBM AIX"; then
export AIXTHREAD_SCOPE=S
fi

####################################################################
# The CONTEXT_FILE variable stores the location of the context file.
####################################################################

CONTEXT_FILE="/oracle/u01/db/tech_st/11.1.0/appsutil/PROD_ebs.xml"
export CONTEXT_FILE

####################################################################
# The CONTEXT_NAME variable stores the value for the current context
####################################################################

CONTEXT_NAME="ROD_ebs"
export CONTEXT_NAME

##################
# Set Library Path
##################

LD_LIBRARY_PATH="/oracle/u01/db/tech_st/11.1.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/oracle/u01/db/tech_st/11.1.0/lib:/usr/dt/lib:/oracle/u01/db/tech_st/11.1.0/ctx/lib"
export LD_LIBRARY_PATH

SHLIB_PATH="/oracle/u01/db/tech_st/11.1.0/lib:/usr/lib:/oracle/u01/db/tech_st/11.1.0/ctx/lib"
export SHLIB_PATH

LIBPATH="/oracle/u01/db/tech_st/11.1.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/oracle/u01/db/tech_st/11.1.0/lib:/usr/dt/lib:/oracle/u01/db/tech_st/11.1.0/ctx/lib"
export LIBPATH

#######################################
# Add perl to the PATH and set PERL5LIB
#######################################

PERLBIN=`dirname /oracle/u01/db/tech_st/11.1.0/perl/bin/perl`

PATH=${PERLBIN}{PATH}
export PATH

PERL5LIB=/oracle/u01/db/tech_st/11.1.0/perl/lib/5.8.3:/oracle/u01/db/tech_st/11.1.0/perl/lib/site_perl/5.8.3:/oracle/u01/db/tech_st/11.1.0/appsutil/perl
export PERL5LIB

ADPERLPRG=/oracle/u01/db/tech_st/11.1.0/perl/bin/perl
export ADPERLPRG

#################################################
# National Language Support environment variables
#################################################

NLS_LANG="American_America.ZHS16GBK"
export NLS_LANG

NLS_DATE_FORMAT="DD-MON-RR"
export NLS_DATE_FORMAT

NLS_NUMERIC_CHARACTERS=".,"
export NLS_NUMERIC_CHARACTERS

NLS_SORT="binary"
export NLS_SORT

#############################
# Set java program used by AD
#############################

ADJVAPRG="/oracle/u01/db/tech_st/11.1.0/appsutil/jre/bin/java"
export ADJVAPRG

ADJREOPTS="-Xms128M -Xmx512M"
export ADJREOPTS

#############################
# Timezone Specification file
#############################

ORA_TZFILE="$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat"
export ORA_TZFILE

toddhai

这是执行rman.sh前的环境变量
declare -x CLASSPATH=".:/usr/java/jdk1.6.0_21/lib/dt.jar:/usr/java/jdk1.6.0_21/lib/tools.jar"
declare -x CVS_RSH="ssh"
declare -x G_BROKEN_FILENAMES="1"
declare -x HISTSIZE="1000"
declare -x HOME="/home/oracle"
declare -x HOSTNAME="localhost.localdomain"
declare -x INPUTRC="/etc/inputrc"
declare -x JAVA_BINDIR="/oracle/product/10.2.0/db_1/jdk/bin"
declare -x JAVA_HOME="/oracle/product/10.2.0/db_1/jdk"
declare -x JAVA_ROOT="/oracle/product/10.2.0/db_1"
declare -x LANG="en_US.UTF-8"
declare -x LANGUAGE="zh_CN.GB18030:zh_CN.GB2312:zh_CN"
declare -x LD_LIBRARY_PATH="/oracle/product/10.2.0/db_1/lib"
declare -x LESSOPEN="|/usr/bin/lesspipe.sh %s"
declare -x LOGNAME="oracle"
declare -x LS_COLORS="no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01r=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:"
declare -x MAIL="/var/spool/mail/oracle"
declare -x NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"
declare -x OLDPWD
declare -x ORACLE_BASE="/oracle"
declare -x ORACLE_HOME="/oracle/product/10.2.0/db_1"
declare -x ORACLE_SID="orcl"
declare -x PATH="/oracle/product/10.2.0/db_1/jdk/bin:/usr/java/jdk1.6.0_21/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/home/oracle/bin:/oracle/product/10.2.0/db_1/bin:/oracle/OPatch:/sbin"
declare -x PWD="/home/oracle"
declare -x SHELL="/bin/bash"
declare -x SHLVL="1"
declare -x SSH_ASKPASS="/usr/libexec/openssh/gnome-ssh-askpass"
declare -x TERM="vt100"
declare -x USER="oracle"

Minsic

不知道你是怎么跑的rman，可能的原因：
PROD_ebs.env跑完退出后，其定义的变量都已失效，应用source或者“.”命令让这些变量在当前shell生效。

toddhai

Minsic 发表于 2016-01-21 17:32
不知道你是怎么跑的rman，可能的原因：
PROD_ebs.env跑完退出后，其定义的变量都已失效，应用source或者“ ...

你好，不明白你所说的“不知道你是怎么跑的rman”
这里的rman指的是我的rman.sh脚本？还是rman target /中的rman。
新手，很多地方不懂。见谅！

Minsic

回复 6# toddhai

这是从其他地方搬过来的脚本？它里面的变量不适合你的环境啊，把rman.sh中的第二行注释掉或者删掉试试，就是这行：. /oracle/u01/db/tech_st/11.1.0/PROD_ebs.env

toddhai

回复 7# Minsic
删掉以后可以登录了，谢谢啊！