topic Re: Schedule Oracle Export in Operating System - HP-UX

Schedule Oracle Export

Adrian Sobers2 — Thu, 21 Oct 2004 12:53:27 GMT

I would like to add the scheduling of a schema level export as part of our Backup and Recovery plan.

We are running Oracle 8.1.7.4 on HP-UX 11i. I would like to export the schema IRD to this location on the HP-UX box:

/var/export

I would like to do this every week on Saturday morning at about 3am.

How do I go about this under HP-UX?

Any help would be greatly appreciated.

Re: Schedule Oracle Export

Sanjay_6 — Thu, 21 Oct 2004 12:56:05 GMT

Hi,

do this through cron,

use oracle id (if you have one) to schedule this job through cron.

Do "man crontab" on more help on setting up cron jobs.

Hope this helps.

Regds

Re: Schedule Oracle Export

John Poff — Thu, 21 Oct 2004 12:56:55 GMT

Hi,

One way to do it would be to write a shell script for your Oracle user account to do the export, and then you can use cron to schedule that script to run on Saturday mornings at 3am.

JP

Re: Schedule Oracle Export

Adrian Sobers2 — Thu, 21 Oct 2004 13:33:24 GMT

I will use my oracle user id to run this cron job. Here is my planned entry to the crontab file to run the export every Saturday at 3am:

0 3 * * 6 (cd $ORACLE_HOME/scripts; sh export.sh)

Does this look ok?

Re: Schedule Oracle Export

John Poff — Thu, 21 Oct 2004 13:49:24 GMT

I would not count on cron knowing about your environment variables, such as $ORACLE_HOME. You'll probably have better success if you spell out the path explicitly:

0 3 * * 6 /oracle/app/oracle/scripts/export.sh

Assuming here that your ORACLE_HOME is /oracle/app/oracle. Also, cron runs with the POSIX shell and does not include the user environment, so your script should set any environment variables needed.

I also like to redirect the output of the script to a log file, so you could have something like this at the end after 'export.sh':

>/some/dir/export.logfile

Or you can redirect output inside your export.sh script.

JP

Re: Schedule Oracle Export

Adrian Sobers2 — Thu, 21 Oct 2004 13:51:30 GMT

Yes I've thought it over and I will go with this:

0 3 * * 6 /home/oracle/export.sh >> /home/oracle/export.log

Re: Schedule Oracle Export

Michael Schulte zur Sur — Thu, 21 Oct 2004 13:51:40 GMT

Hi,

cron will not give you $ORACLE_HOME. You will have to set it yourself. I would suggest giving cron the full path shell script then first thing in the shell get the oracle environment and then do the export.
0 3 * * 6 /oracle/app/oracle/products/920/scripts/sh export.sh
and inside
. /path/oracle.env.sh
export ....

greetings,

Michael

Re: Schedule Oracle Export

Marcel Boogert_1 — Thu, 21 Oct 2004 14:01:27 GMT

Hi there,

In cron I always use the root and then something like:

su - -c /oracle/app/oracle/products/920/scripts/sh export.sh >> /home/oracle/export.log

Regards, MB.

Re: Schedule Oracle Export

Adrian Sobers2 — Thu, 21 Oct 2004 14:27:21 GMT

Thanks for help all.