[SunHELP] How to Backup

[sunhelp at sunhelp.org]

You should read the man page for the crontab command.

 To run a command at 1am every day:
0 1 * * * /your/script

 The following should run a command every hour, every day:
0 * * * * /some/command/like/your/script
 (note the issue that would happen at 1am each day)

 The fields for the crontab entries are:
minute(0-59) hour(0-23) day of the month(1-31) month of the year(1-12) day of the week(0-6
(0=Sunday)) string

 And ___please___ consult a DBA before you trust the
tar command to be able to backup a live Oracle database.
You must do exports, and backup the export files. Otherwise
you'll probably be out of a job and your company would be
screwed if a restore of a hot-backup were ever needed.

 -david

> I would like to fire the scripts in cold backup at 01:00am and hot
> backup every 1 hour.
> 
> Please show me the step to create a cron for cold and hot backup.
> 
> Thank you.
> Wadi Achmed
> 
> 
> dhansen at zebra.net wrote:
> 
> > > backup.sh:
> > > tar c $HOME/oradata
> > > With those scripts, how can I create a cron jobs?
> >
> >  When would you like for this to run? I'm assuming that
> > you only want to fire off the backup.sh script from cron.
> > BTW, you _do_ know that the backup.sh script is completely
> > useless to you when the database is running. You'll want
> > to run exports from within Oracle to get "hot" backups.