Re: GPL Oracle hot backup script

On Mar 23, 4:15 am, Brian Peasland <d..._at_nospam.peasland.net> wrote:
> teolu..._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
> d...@nospam.peasland.nethttp://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 fromhttp://www.teranews.com- Hide quoted text -
>
> - Show quoted text -

Moreover the script doesn't recognize log_archive_dest can change, doesn't retrieve log_archive_dest from the database, and doesn't retrieve the filespecs of the applicable archivelogs from v $archive_log.
Consequently, the script is potentially error prone, and no improvement upon the KLoney script in the Oracle 7.3 DBA handbook!!

--
Sybrand Bakker
Senior Oracle DBA