OraFAQ Forum: Backup & Recovery » How to set a cronjob

Home » RDBMS Server » Backup & Recovery » How to set a cronjob

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to set a cronjob [message #211179]

Wed, 27 December 2006 01:10

gthrisg
Messages: 17
Registered: August 2006

Junior Member

Hi,
Im a newbie in oracle.Im using linux fedora core.
I have a script for backup
my backup.ksh file contains
#!/bin/ksh
rman target=/ << EOF
RUN {
ALLOCATE CHANNEL ch1 TYPE
DISK FORMAT '$ORACLE_HOME/backup/%d_DB_%u_%s_%p';
BACKUP DATABASE PLUS ARCHIVELOG;
RELEASE CHANNEL ch1;
}
EXIT;
EOF
How do i set a cronjob for it example i want this to run daily at 3pm or so.
Can anyone guide me how to do it.

thanks
gthri

Report message to a moderator

Re: How to set a cronjob [message #211198 is a reply to message #211179]

Wed, 27 December 2006 02:45

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

# minute hour day_of_month month weekday command
0 15 * * * /path/to/backup.ksh >/tmp/backup.log 2>&1

Report message to a moderator

Re: How to set a cronjob [message #211269 is a reply to message #211179]

Wed, 27 December 2006 13:06

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

More than likely the script will likely fail 'cuz your environment has not been properly established.

Report message to a moderator

Previous Topic:	Drop Dual/User_objects
Next Topic:	diff between rman and sql backtrack

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 12:14:29 CST 2024