Re: GPL Oracle hot backup script

teolupus_at_gmail.com wrote:
> Hi,
>
> We've recently opened our multi-platform Oracle online backup script
> as an open source (GPL) project.
>
> Description: Multi-platform, storage independent, safe and flexible
> online physical backup script (aka: hot-backup) for Oracle databases
> (any version).
>
> Features:
> - Database checks before backup (online, archive_mode);
> - Dynamical backup of instance datafiles, archives and configuration
> files;
> - Extensive error detection over all steps involved in the process
> (Eg.: do not leave tablespaces in backup mode even when interrupted);
> - Clean and easy to read log with timestamps for each step;
> - Detailed error messages for troubleshooting;
> - Storage independent (File-System, TAR/GZ, Tivoli, NetBackup);
> - Multi-plataform (Linux, AIX, HP-UX, Solaris, Windows+Cygwin).
>
> You could check it at: http://sourceforge.net/projects/ora-hot-bkp/
>
> Feedbacks are welcome. Please let us know how to improve this script
> to make it even better.
>
> Best wishes,
> Bruno Almeida do Lago
>

All of the above is done quite nicely using RMAN, which is free and comes with the database. RMAN also includes many things not available in your script, including but not limited to the following:

• Incremental backups
• Incrementally updated backups
• The ability to skip READ ONLY tablespaces which have been previously backed up.
• Block level recovery
• Delete archived redo logs after backups
• Able to start backup from Enterprise Manager

And there is even more to the list.

RMAN is the way to go.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com