Home » RDBMS Server » Backup & Recovery » How to set a cronjob
How to set a cronjob [message #211179] Wed, 27 December 2006 01:10 Go to next message
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
Re: How to set a cronjob [message #211198 is a reply to message #211179] Wed, 27 December 2006 02:45 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
# minute hour day_of_month month weekday command
0 15 * * * /path/to/backup.ksh >/tmp/backup.log 2>&1

Re: How to set a cronjob [message #211269 is a reply to message #211179] Wed, 27 December 2006 13:06 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
More than likely the script will likely fail 'cuz your environment has not been properly established.
Previous Topic: Drop Dual/User_objects
Next Topic: diff between rman and sql backtrack
Goto Forum:
  


Current Time: Sun Dec 04 10:45:37 CST 2016

Total time taken to generate the page: 0.08382 seconds