Re: Online backups

In article <3j2q4s$1pnc_at_news-s01.ny.us.ibm.net> colipha_at_ibm.net writes:
>We are getting conflicting advice on whether or not to use online backups.
>What is the feelings of this group?
>

See the Concepts Manual about "fuzzy" or "inconsistent" backups.

My (admittedly cynical) opinion is the procedures involved in restoration of these sorts of backups depends far too much on human intervention. Mistakes will be made.

A lot depends on your configuration. Do you have a huge budget to spend on failsafe hardware? Use noarchivelog mode and ordinary backups. Do you have a high volume of non-critical data and a large budget that will always be there for lots of well-trained people? Then you might consider online backups. Do you have a 7/24 requirement? Do you have full-time operators? Full-time DBA's? A graveyard shift? Which environment are you on? Mixed? How much will an ARCH bug hurt you?

What other advice have you gotten?

jg

-- 
Joel Garry           joelga_at_amber.rossinc.com            Compuserve 70661,1534
These are my opinions, not necessarily those of Ross Systems, Inc.
%DCL-W-SOFTONEDGEDONTPUSH, Software On Edge - Don't Push.  
panic: ifree: freeing free inodes...