Re: Script needed for hot backup

andy_at_redeye.com (Andy Cowling) wrote in <m2y9zvjq0n.fsf_at_puma.redeye>:

>I'm using Joost Mulder's orabackup.sh shell script. An excellent,
>well commented script that does hot and cold backups.

Agreed, but as an alternative to Joost's script, there's a hot backup script on my website:

    http://home.clara.net/dwotton/dba/hotbackup.htm

My script has a different objective. Instead of having hot and cold backup functionality in the same script, my script only performs hot backups. However, unlike Joost's script, my script is designed to backup large databases over several days: You specify how much data you want to back up each night and it backs up tablespaces in rotation until the limit is reached. On the next run (using the same parameters, so you can run this from cron) it'll recommence where it left off, thereby backing up the database over several runs.

Of course, if you specify a size limit which is greater than the total size of your database, it'll back up the whole lot in one session.

Dave.

--
Remove "nospam" from my address to reply to this newsgroup posting
by email