Re: Q: Backup solutions

Jerry Gitomer <jgitomer_at_p3.net> wrote in article <3429D87E.71F5_at_p3.net>...
> Oracle supports hot backups. Turn archivelog mode on and then for
> each tablespace in turn set the tablespace into backup mode, backup
> the datafiles, set the tablespace back to normal mode and then after
> all of the tablespaces have been backed up turn off archivelog mode.
> See the chapter on backup and recovery in the Server Concepts Manual
> (I may be wrong on which manual its in since I don't have a set of
> manuals at home, but ...).

For a high availabilty environment, archivelog mode should ALWAYS be on. Otherwise one can only restore back to the time of the last backup rather than the point of failure.

> Jerry
>
> Don wrote:
> >
> > We have jumped into the world of Oracle 7.3 on a SUN Ultra Enterprise
> > server. We are currently using striping, double mirrors, shared disk
> > arrays, and a second server. We've implemented the Veritas
> > First-Watch high availability solution for max up-time.
> >

-- 
==========================================================================
Scott Overby                  E-mail  scott.overby_at_sdsdata.com
Sr. Systems Analyst		Phone   (414) 459-7999
INPire Insurance Solutions    FAX     (414) 459-9123
615 Penn Ave.                   
Sheboygan, WI 53082

     _/_/_/  _/_/   _/  _/_/_/        \  |  /
       _/   _/ _/  _/  _/              \ | /
      _/   _/  _/ _/  _/_/_/  _/_/_/_/  _/  _/_/_/  _/_/_
     _/   _/   _/_/      _/  _/    _/  _/  _/  _/  _/  _/
  _/_/_/ _/    _/   _/_/_/  _/_/_/_/  _/  _/      _/_/_/
                          _/
                         _/
===========================================================================