Re: Script needed for hot backup

Jake de Haan wrote in message ...
>I'm looking for script(s) that will do a hot backup for me; One
>tablespace at a time and one that hopefully the intelligence to
>know when to switch to the next tablespace.
>
>I'd appreciate it if anyone could send me info/samples on this.

There's a script on my website:

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

It includes the intelligence to switch to the next tablespace and supports the ability to specify a maximum number of megabytes to be backed up, and
a restart facility so that the backup can be restarted at a later date to complete a partial backup created when the backup size threshold was exceeded.

Dave.

--
If you reply to this posting by email, remove the "nospam" from my email
address first.