Oracle-L: RE: RMAN and cron

From: Hately, Mike (NESL-IT) <Mike.Hately_at_npowernorthern.com>
Date: Mon, 23 Dec 2002 06:53:49 -0800
Message-ID: <F001.005212BE.20021223065349@fatcity.com>

Ron

try altering test.sh to read

". /alphaprd/profile" [ notice the extra space ]

That should set the environment in your current shell which isn't happenijng at the moment.

Regards,
Mike Hately
Oracle DBA

-----Original Message-----
Sent: 23 December 2002 14:24
To: Multiple recipients of list ORACLE-L

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: Hately, Mike (NESL-IT)
INET: Mike.Hately_at_npowernorthern.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------