Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN and cron

RE: RMAN and cron

From: Stephen Lee <slee_at_dollar.com>
Date: Mon, 23 Dec 2002 07:49:02 -0800
Message-ID: <F001.00521365.20021223074902@fatcity.com>

I suppose I should add that you can also have the backup script "dot" the env script.
For example:

. /path/to/env_script

etc.
etc.
etc.
---------------------------

> -----Original Message-----
> From: Stephen Lee [mailto:slee_at_dollar.com]
> Sent: Monday, December 23, 2002 8:49 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RMAN and cron
>
>
>
> Are you executing (or running) the env variable script; then
> running the
> backup script? If so, then the env script sets the variables
> OK ... in the
> sub-shell that ran it! When that sub-shell finishes the env
> script, then
> your variables exit with the sub-shell. If this is what you
> have going on,
> then put the variable in the same script as the backup, or
> "dot" the env
> script.
>
> . env_script
> /execute/the/backup
>
>
> > -----Original Message-----
> > From: Ron Rogers [mailto:RROGERS_at_galottery.org]
> > Sent: Monday, December 23, 2002 8:24 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RMAN and cron
> >
> >
> > list,
> > Cron server os RedHat 7.2
> > Database server os OpenVMS 7.3-1
> > Database Oracle 8.1.7 rel 3
> > Rman server os OpenVMS 7.3-1
> > Rman Oracle 8.1.7 rel 3
> >
> > On the Cron server I have created a script that will backup the
> > database server and catalog the action on the rman server.
> > When I try to
> > have cron perform the backup sctipt I get
> > RMAN-571 and LEM-00031, and LEM-00033 error message. According to
> > Metalink it is an environmental error that the oracle
> > variables are not
> > set. I have set up my environment as follows:
> >
> > file: /alphaprd/profile
> > ORACLE_HOME = cron server ORACLE_HOME
> > ORACLE_BASE =cron server ORACLE_BASE
> > LD_LIBRARY_PATH = cron server LD_LIBRARY_PATH
> > TNS_ADMIN = cron server TNS_ADMIN
> > export ORACLE_HOME ORACLE_BASE LD_LIBRARY_PATH TNS_ADMIN
> >
> > Script to backup the database controlfile: test.sh
> >
> > ./alphaprd/profile
> > echo "start backup:" >/alphaprd/rman_test.log
> > /home/oracle/OraHome1/bin/rman <<EOF>> /alphaprd/rman_test.log
> > connect target "sys/password_at_database server"
> > connect catalog rman/rman_at_rman server
> > run {
> > allocate channel di type disk;
> > backup format
> > 'orabck:[backups]control_%U.bus'
> > (current controlfile);
> > }
> > EOF
> >
> > Crontab entry as ROOT:
> > 10 01 * * 1 su oracle "-c /alphaprd/test.sh -u"
> >
> > OR
> > Crontab entry as ORACLE
> > 10 01 * * 1 /alphaprd/test.sh
> >
> > The script functions properly if I run it from the command line as
> > oracle but fails with
> > RMAN-571 and LEM-00031 and LEM-00033 errors when run from cron.
> >
> > I don't see how it could be Oracle environmentals when I am
> running it
> > as an Oracle cron and the target and catalog are on a
> different server
> > that the cron server.
> > Can you point me in the direction where I can get this resovled?
> > Thanks,
> > Ron
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Ron Rogers
> > INET: RROGERS_at_galottery.org
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web
> hosting services
> >
> ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephen Lee
> INET: slee_at_dollar.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: slee_at_dollar.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon Dec 23 2002 - 09:49:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US