求助：rman自动备份的问题，望光临指导。

nethzt

日前小弟试着编了一个RMAN自动备份的脚本（其实是借鉴旁人的），但是苦于总是不能自动执行，郁闷之至，还望个位大侠雅正。


.profile文件
root@ts_oss_bak # more .profile
# @(#)local.profile 1.8 99/03/26 SMI
stty istrip
PATH=/usr/bin:/usr/ucb:/etc:.
export PATH

#
# If possible, start the windows system
#
if [ "`tty`" = "/dev/console" ] ; then
        if [ "$TERM" = "sun" -o "$TERM" = "sun-color" -o "$TERM" = "AT386" ]
        then

                if [ ${OPENWINHOME:-""} = "" ] ; then
                        OPENWINHOME=/usr/openwin
                        export OPENWINHOME
                fi

                echo ""
                echo "Starting OpenWindows in 5 seconds (type Control-C to interrupt)"
                sleep 5
                echo ""
                $OPENWINHOME/bin/openwin

                clear           # get rid of annoying cursor rectangle
                exit            # logout after leaving windows system

        fi
fi

umask 022
ORACLE_OWNER=oracle;export ORACLE_OWNER
ORACLE_BASE=/opt/oracle/db01;export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/app;export ORACLE_HOME
ORACLE_TERM=ansi;export ORACLE_TERM
ORACLE_SID=inms;export ORACLE_SID
ORACLE_NLS33=$ORACLE_HOME/ocommon/nls/admin/data;export ORACLE_NLS33

AGENT_HOME=/opt/oracle/serveragent;export AGENT_HOME
ulimit -n 256

PATH=.:/bin:/sbin:/usr/bin:/usr/sbin:/etc:/usr/ccs/bin:/usr/ucb:/usr/local/binORACLE_HOME/bin:/opt/SUNWspro/bin:/opt/binPATH;exp
ort PATH

TERM=vt100
HISTSIZE=200;export HISTSIZE
NLS_LANG=AMERICAN_AMERICA.ZHS16CGB231280;export NLS_LANG
LD_LIBRARY_PATH=$ORACLE_HOME/LIB:/usr/lib; export LD_LIBRARY_PATH



脚本文件
root@ts_oss_bak # more backupctrl.sh
#ORACLE_OWNER=oracle;export ORACLE_OWNER
ORACLE_BASE=/opt/oracle/db01;export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/app;export ORACLE_HOME
ORACLE_TERM=ansi;export ORACLE_TERM
ORACLE_SID=inms;export ORACLE_SID
ORACLE_NLS33=$ORACLE_HOME/ocommon/nls/admin/data;export ORACLE_NLS33

$/opt/oracle/db01/app/bin/rman <<EOF
# connect database
connect catlog rman/rman@rman
connect target system/manager

# start backup database
run{
allocate channel c1 type disk;
backup current controlfile
format '/opt/oracle/db01/rmandb/ctrls%t%s.%p';
}
EOF

执行报错
root@ts_oss_bak # backupctrl.sh
backupctrl.sh: ORACLE_BASE^M: is not an identifier

nethzt

各位大虾帮帮忙啊………………

rollingpig

$/opt/oracle/db01/app/bin/rman

去掉前面的 $

jieyancai

connect catlog rman/rman@rman写错了
＝＝》connect catalog rman/rman@rman

luocb1980

执行报错
root@ts_oss_bak # backupctrl.sh
backupctrl.sh: ORACLE_BASE^M: is not an identifier
你是不是没有把 backupctrl.sh文件用asc方式传上去

nethzt

原来这么多错误啊：（

继续努力！

exitgogo

run{
allocate channel c1 type disk;
backup current controlfile
format '/opt/oracle/db01/rmandb/ctrls%t%s.%p';
}


run{
allocate channel c1 type disk;
backup include current controlfile
format '/opt/oracle/db01/rmandb/ctrls%t%s.%p' database;
}